Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
2,300
Total Travel Cost
$268,638
400,952 miles
Avoidable Cost
$215,250
321,269 excess miles
Optimal Cost
$53,402
If closest tech always used
Avg Excess / WO
139.7 mi
$93.58 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
31.2%
718 WOs

Actual Travel Expenses

From 195 WOs with expense data
Total Expenses
$86,006
Labor - Travel
$48,979
Mileage
$1,429
Lodging
$12,399
Airfare
$6,427
Car Rental
$4,586
Per Diem
$4,000
Meals
$458
Other
$7,727

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)
$86,006
195 WOs with expenses
Billed to Client
$41,490
48.2% recovery rate
Margin Gap (Unbilled)
$44,516
Cost absorbed internally
Avg Expense / WO
$441
Avg billed: $213
Internal Cost
$86,006
Billed
$41,490

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) 424 230 $48,979 $32,436 $16,543 66.2%
Lodging 49 30 $12,399 $3,690 $8,709 29.8%
Other Expenses 195 122 $7,727 $656 $7,071 8.5%
Airfare 15 7 $6,427 $3,106 $3,321 48.3%
Car Rental 27 10 $4,586 $933 $3,654 20.3%
Per Diem 94 43 $4,000 $475 $3,525 11.9%
Mileage 11 3 $1,429 $195 $1,234 13.6%
Meals 1 1 $458 $0 $458 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 74 $34,906 $16,698 $18,208 47.8%
Healthcare Provider 52 $31,419 $19,445 $11,975 61.9%
Bed Services 52 $6,663 $598 $6,064 9%
EMS 20 $6,172 $1,979 $4,193 32.1%
Lab/Power 6 $2,732 $2,719 $13 99.5%
Kiosk 61 $2,418 $50 $2,368 2.1%
Project 24 $943 $0 $943 0%
Animal Health 1 $754 $0 $754 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 51 $26,688 $12,683 $14,005 47.5%
Repair 92 $23,699 $15,360 $8,340 64.8%
Preventive Maintenance 92 $12,594 $3,175 $9,419 25.2%
Cross-Training 4 $9,655 $1,788 $7,868 18.5%
Delivery 2 $5,041 $4,641 $400 92.1%
Repair/PM 9 $3,649 $2,719 $929 74.5%
Inspection 8 $1,502 $500 $1,003 33.3%
Misc. Inspection 4 $1,207 $484 $723 40.1%
Upgrade 24 $943 $0 $943 0%
Asset Tagging 1 $754 $0 $754 0%
Installation 2 $220 $140 $80 63.6%
Connectivity 1 $54 $0 $54 0%

Monthly Expense Trend — Internal Cost vs Billed