Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,645
Total Travel Cost
$137,777
205,637 miles
Avoidable Cost
$82,867
123,683 excess miles
Optimal Cost
$54,910
If closest tech always used
Avg Excess / WO
75.2 mi
$50.38 per WO
Median Excess
6.5 mi
Outlier Rate (>50mi)
22.9%
376 WOs

Actual Travel Expenses

From 939 WOs with expense data
Total Expenses
$316,957
Labor - Travel
$241,366
Mileage
$6,987
Lodging
$20,401
Airfare
$11,676
Car Rental
$5,360
Per Diem
$12,400
Meals
$0
Other
$18,766

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)
$316,957
939 WOs with expenses
Billed to Client
$95,355
30.1% recovery rate
Margin Gap (Unbilled)
$221,602
Cost absorbed internally
Avg Expense / WO
$338
Avg billed: $102
Internal Cost
$316,957
Billed
$95,355

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) 2,108 1,065 $241,366 $72,812 $168,554 30.2%
Lodging 77 58 $20,401 $5,533 $14,869 27.1%
Other Expenses 437 302 $18,766 $4,110 $14,657 21.9%
Per Diem 301 166 $12,400 $1,525 $10,875 12.3%
Airfare 32 26 $11,676 $6,079 $5,597 52.1%
Mileage 116 57 $6,987 $3,742 $3,245 53.6%
Car Rental 50 31 $5,360 $1,554 $3,806 29%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 640 $232,029 $59,384 $172,645 25.6%
EMS 152 $30,913 $16,029 $14,884 51.9%
Kiosk 283 $20,141 $578 $19,563 2.9%
Lab/Power 21 $14,431 $13,342 $1,089 92.5%
Animal Health 53 $12,164 $5,251 $6,912 43.2%
Bed Services 42 $5,220 $770 $4,450 14.8%
Training/Other 2 $1,884 $0 $1,884 0%
Installation 2 $175 $0 $175 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 585 $182,720 $42,168 $140,551 23.1%
Preventive Maintenance 341 $32,748 $10,329 $22,418 31.5%
Installation 30 $23,874 $6,344 $17,530 26.6%
Inspection 63 $21,297 $1,959 $19,338 9.2%
Misc. Inspection 67 $13,944 $9,220 $4,723 66.1%
Delivery 23 $12,282 $9,285 $2,997 75.6%
Repair/PM 31 $8,920 $6,959 $1,961 78%
Cross-Training 10 $8,354 $1,664 $6,690 19.9%
Evaluation 18 $4,907 $2,018 $2,890 41.1%
Overhaul 1 $2,825 $2,825 $0 100%
PM/CAL 2 $2,617 $1,556 $1,061 59.5%
Calibration 4 $722 $722 $0 100%
Connectivity 9 $428 $0 $428 0%
Removal 4 $424 $305 $119 71.9%
Warranty 1 $390 $0 $390 0%
Relocation 1 $311 $0 $311 0%
Asset Tagging 1 $119 $0 $119 0%
Support 2 $75 $0 $75 0%
PM-EXT 1 $0 $0 $0 0%
Upgrade 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed