Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
311
Total Travel Cost
$28,533
42,587 miles
Avoidable Cost
$18,674
27,871 excess miles
Optimal Cost
$9,859
If closest tech always used
Avg Excess / WO
89.6 mi
$60.04 per WO
Median Excess
21.5 mi
Outlier Rate (>50mi)
36%
112 WOs

Actual Travel Expenses

From 205 WOs with expense data
Total Expenses
$76,121
Labor - Travel
$67,015
Mileage
$0
Lodging
$3,022
Airfare
$2,683
Car Rental
$976
Per Diem
$1,150
Meals
$0
Other
$1,275

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)
$76,121
205 WOs with expenses
Billed to Client
$8,728
11.5% recovery rate
Margin Gap (Unbilled)
$67,393
Cost absorbed internally
Avg Expense / WO
$371
Avg billed: $43
Internal Cost
$76,121
Billed
$8,728

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) 364 200 $67,015 $8,613 $58,402 12.9%
Lodging 11 9 $3,022 $0 $3,022 0%
Airfare 4 3 $2,683 $0 $2,683 0%
Other Expenses 52 35 $1,275 $116 $1,160 9.1%
Per Diem 27 21 $1,150 $0 $1,150 0%
Car Rental 9 5 $976 $0 $976 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 206 $76,121 $8,728 $67,393 11.5%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 157 $55,157 $3,684 $51,473 6.7%
Inspection 9 $7,413 $58 $7,356 0.8%
Preventive Maintenance 19 $3,531 $98 $3,433 2.8%
Cross-Training 1 $2,957 $0 $2,957 0%
Evaluation 6 $2,655 $2,201 $454 82.9%
Delivery 7 $2,129 $743 $1,387 34.9%
Misc. Inspection 5 $1,390 $1,057 $333 76%
Calibration 1 $460 $460 $0 100%
Installation 1 $429 $429 $0 100%

Monthly Expense Trend — Internal Cost vs Billed