Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,166
Total Travel Cost
$65,503
97,766 miles
Avoidable Cost
$43,276
64,590 excess miles
Optimal Cost
$22,244
If closest tech always used
Avg Excess / WO
55.4 mi
$37.10 per WO
Median Excess
7.6 mi
Outlier Rate (>50mi)
12.6%
147 WOs

Actual Travel Expenses

From 671 WOs with expense data
Total Expenses
$227,107
Labor - Travel
$150,107
Mileage
$2,649
Lodging
$27,476
Airfare
$10,372
Car Rental
$11,502
Per Diem
$10,025
Meals
$0
Other
$14,976

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)
$227,107
671 WOs with expenses
Billed to Client
$85,078
37.5% recovery rate
Margin Gap (Unbilled)
$142,029
Cost absorbed internally
Avg Expense / WO
$338
Avg billed: $127
Internal Cost
$227,107
Billed
$85,078

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) 1,257 747 $150,107 $77,417 $72,689 51.6%
Lodging 112 53 $27,476 $3,656 $23,821 13.3%
Other Expenses 821 449 $14,976 $2,564 $12,412 17.1%
Car Rental 57 29 $11,502 $0 $11,502 0%
Airfare 21 10 $10,372 $50 $10,321 0.5%
Per Diem 233 95 $10,025 $0 $10,025 0%
Mileage 20 10 $2,649 $1,390 $1,259 52.5%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 529 $143,488 $67,748 $75,740 47.2%
Healthcare Provider 197 $57,066 $9,473 $47,593 16.6%
EMS 56 $13,036 $7,791 $5,245 59.8%
Installation 1 $11,084 $0 $11,084 0%
Kiosk 82 $1,907 $0 $1,907 0%
Animal Health 2 $500 $40 $460 8%
Lab/Power 1 $25 $25 $0 100%
Bed Services 2 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 113 $102,074 $45,266 $56,807 44.3%
Repair 196 $49,791 $16,799 $32,993 33.7%
Preventive Maintenance 365 $25,582 $11,835 $13,747 46.3%
Installation 31 $16,984 $3,825 $13,159 22.5%
Cross-Training 7 $13,964 $0 $13,964 0%
Inspection 38 $5,402 $648 $4,754 12%
Evaluation 16 $4,029 $1,553 $2,476 38.5%
Misc. Inspection 17 $3,688 $3,407 $281 92.4%
PM 65 $3,025 $1,240 $1,785 41%
Repair/PM 12 $908 $0 $908 0%
New Hire Training 1 $651 $0 $651 0%
Calibration 3 $544 $228 $317 41.8%
Delivery 6 $465 $278 $187 59.8%

Monthly Expense Trend — Internal Cost vs Billed