Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
255
Total Travel Cost
$29,316
43,755 miles
Avoidable Cost
$20,437
30,502 excess miles
Optimal Cost
$8,879
If closest tech always used
Avg Excess / WO
119.6 mi
$80.14 per WO
Median Excess
11.2 mi
Outlier Rate (>50mi)
22%
56 WOs

Actual Travel Expenses

From 109 WOs with expense data
Total Expenses
$45,696
Labor - Travel
$41,873
Mileage
$0
Lodging
$1,745
Airfare
$885
Car Rental
$158
Per Diem
$375
Meals
$0
Other
$660

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)
$45,696
109 WOs with expenses
Billed to Client
$26,124
57.2% recovery rate
Margin Gap (Unbilled)
$19,572
Cost absorbed internally
Avg Expense / WO
$419
Avg billed: $240
Internal Cost
$45,696
Billed
$26,124

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) 244 146 $41,873 $24,605 $17,268 58.8%
Lodging 8 5 $1,745 $233 $1,512 13.3%
Airfare 1 1 $885 $1,018 $133 ✓ 115%
Other Expenses 41 27 $660 $121 $539 18.4%
Per Diem 9 4 $375 $0 $375 0%
Car Rental 3 1 $158 $147 $12 92.6%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 154 $45,696 $26,124 $19,572 57.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 64 $37,627 $21,164 $16,464 56.2%
Repair 20 $4,191 $2,945 $1,246 70.3%
Preventive Maintenance 66 $3,866 $2,015 $1,851 52.1%
PM 4 $12 $0 $12 0%

Monthly Expense Trend — Internal Cost vs Billed