Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
373
Total Travel Cost
$6,140
9,165 miles
Avoidable Cost
$2,396
3,577 excess miles
Optimal Cost
$3,744
If closest tech always used
Avg Excess / WO
9.6 mi
$6.42 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
3.5%
13 WOs

Actual Travel Expenses

From 256 WOs with expense data
Total Expenses
$45,887
Labor - Travel
$36,034
Mileage
$4,136
Lodging
$530
Airfare
$720
Car Rental
$403
Per Diem
$525
Meals
$0
Other
$3,538

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,886
256 WOs with expenses
Billed to Client
$15,058
32.8% recovery rate
Margin Gap (Unbilled)
$30,829
Cost absorbed internally
Avg Expense / WO
$179
Avg billed: $59
Internal Cost
$45,886
Billed
$15,058

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) 407 247 $36,034 $10,529 $25,505 29.2%
Mileage 169 47 $4,136 $3,938 $199 95.2%
Other Expenses 191 151 $3,538 $591 $2,946 16.7%
Airfare 1 1 $720 $0 $720 0%
Lodging 1 1 $530 $0 $530 0%
Per Diem 12 4 $525 $0 $525 0%
Car Rental 2 2 $403 $0 $403 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 99 $29,716 $4,748 $24,968 16%
EMS 144 $12,521 $10,241 $2,280 81.8%
Training/Other 2 $2,104 $0 $2,104 0%
Kiosk 73 $1,383 $68 $1,314 4.9%
Animal Health 1 $163 $0 $163 0%
Lab/Power 1 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 183 $31,333 $8,495 $22,837 27.1%
Preventive Maintenance 101 $5,805 $4,455 $1,350 76.7%
Cross-Training 4 $4,357 $0 $4,357 0%
Evaluation 11 $1,090 $830 $260 76.2%
Misc. Inspection 4 $1,006 $1,006 $0 100%
Delivery 3 $833 $0 $833 0%
Installation 4 $597 $0 $597 0%
Repair/PM 6 $499 $0 $499 0%
Inspection 3 $287 $272 $15 94.8%
Connectivity 1 $80 $0 $80 0%

Monthly Expense Trend — Internal Cost vs Billed