Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
973
Total Travel Cost
$119,661
178,598 miles
Avoidable Cost
$112,805
168,366 excess miles
Optimal Cost
$6,856
If closest tech always used
Avg Excess / WO
173.0 mi
$115.94 per WO
Median Excess
5.7 mi
Outlier Rate (>50mi)
44.9%
437 WOs

Actual Travel Expenses

From 86 WOs with expense data
Total Expenses
$8,018
Labor - Travel
$2,209
Mileage
$0
Lodging
$3,543
Airfare
$0
Car Rental
$0
Per Diem
$1,325
Meals
$0
Other
$941

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)
$8,018
86 WOs with expenses
Billed to Client
$1,739
21.7% recovery rate
Margin Gap (Unbilled)
$6,279
Cost absorbed internally
Avg Expense / WO
$93
Avg billed: $20
Internal Cost
$8,018
Billed
$1,739

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
Lodging 22 21 $3,543 $344 $3,199 9.7%
Labor - Travel (Hours) 117 113 $2,209 $1,395 $814 63.2%
Per Diem 31 26 $1,325 $0 $1,325 0%
Other Expenses 55 54 $941 $0 $941 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Project 114 $4,479 $0 $4,479 0%
FCO 35 $3,538 $1,739 $1,799 49.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Upgrade 114 $4,479 $0 $4,479 0%
FCO 30 $2,523 $964 $1,559 38.2%
Repair 5 $1,016 $775 $241 76.3%

Monthly Expense Trend — Internal Cost vs Billed