Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
121
Total Travel Cost
$8,468
12,639 miles
Avoidable Cost
$4,034
6,021 excess miles
Optimal Cost
$4,491
If closest tech always used
Avg Excess / WO
49.1 mi
$32.87 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
28.1%
34 WOs

Actual Travel Expenses

From 80 WOs with expense data
Total Expenses
$12,192
Labor - Travel
$8,078
Mileage
$2,486
Lodging
$184
Airfare
$0
Car Rental
$0
Per Diem
$550
Meals
$0
Other
$895

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)
$12,192
80 WOs with expenses
Billed to Client
$6,643
54.5% recovery rate
Margin Gap (Unbilled)
$5,550
Cost absorbed internally
Avg Expense / WO
$152
Avg billed: $83
Internal Cost
$12,192
Billed
$6,643

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) 77 53 $8,078 $5,120 $2,958 63.4%
Mileage 54 35 $2,486 $890 $1,596 35.8%
Other Expenses 37 31 $895 $633 $263 70.7%
Per Diem 14 11 $550 $0 $550 0%
Lodging 1 1 $184 $0 $184 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 94 $12,192 $6,643 $5,550 54.5%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 43 $6,545 $4,998 $1,547 76.4%
Preventive Maintenance 38 $2,816 $1,020 $1,796 36.2%
Evaluation 9 $1,796 $375 $1,422 20.9%
Cross-Training 2 $395 $0 $395 0%
Warranty 1 $390 $0 $390 0%
Parts Sale 1 $250 $250 $0 100%

Monthly Expense Trend — Internal Cost vs Billed