Travel & Margin Analysis

Quantify excess travel cost and identify optimization opportunities across your field service operation

Tech Placement Detail →
WOs Analyzed
38
Total Travel Cost
$3,421
5,105 miles
Avoidable Cost
$666
994 excess miles
Optimal Cost
$2,755
If closest tech always used
Avg Excess / WO
26.2 mi
$17.53 per WO
Median Excess
13.8 mi
Outlier Rate (>50mi)
28.9%
11 WOs

Actual Travel Expenses

From 22 WOs with expense data
Total Expenses
$6,536
Labor - Travel
$2,929
Mileage
$1,925
Lodging
$688
Airfare
$0
Car Rental
$132
Per Diem
$300
Meals
$0
Other
$562

Billable vs Internal Cost — Margin Gap

Compares what was billed to clients against what we actually paid for travel expenses. The gap represents unbilled internal cost.

Internal Cost (What We Paid)
$6,536
22 WOs with expenses
Billed to Client
$2,332
35.7% recovery rate
Margin Gap (Unbilled)
$4,205
Cost absorbed internally
Avg Expense / WO
$297
Avg billed: $106
Internal Cost
$6,536
Billed
$2,332

Expense Breakdown by Category

Internal cost vs billed amount by expense type. Negative margin = we paid more than we billed.

Category Lines WOs Internal Cost Billed to Client Margin Gap Recovery % Gap Distribution
Labor - Travel (Hours) 35 17 $2,929 $1,356 $1,573 46.3%
Mileage 28 9 $1,925 $858 $1,067 44.5%
Lodging 5 5 $688 $0 $688 0%
Other Expenses 30 15 $562 $118 $445 20.9%
Per Diem 7 3 $300 $0 $300 0%
Car Rental 2 1 $132 $0 $132 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 18 $4,245 $1,649 $2,596 38.8%
Healthcare Provider 5 $2,274 $683 $1,591 30%
Kiosk 6 $18 $0 $18 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 16 $3,367 $1,180 $2,187 35%
Repair 7 $2,058 $1,152 $906 56%
Delivery 1 $693 $0 $693 0%
Installation 1 $392 $0 $392 0%
Inspection 2 $18 $0 $18 0%
Repair/PM 2 $9 $0 $9 0%

Monthly Expense Trend — Internal Cost vs Billed