Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
732
Total Travel Cost
$41,343
61,707 miles
Avoidable Cost
$28,193
42,079 excess miles
Optimal Cost
$13,151
If closest tech always used
Avg Excess / WO
57.5 mi
$38.52 per WO
Median Excess
32.7 mi
Outlier Rate (>50mi)
33.7%
247 WOs

Actual Travel Expenses

From 501 WOs with expense data
Total Expenses
$157,843
Labor - Travel
$145,783
Mileage
$0
Lodging
$3,689
Airfare
$1,098
Car Rental
$0
Per Diem
$1,975
Meals
$0
Other
$5,298

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)
$157,843
501 WOs with expenses
Billed to Client
$96,739
61.3% recovery rate
Margin Gap (Unbilled)
$61,104
Cost absorbed internally
Avg Expense / WO
$315
Avg billed: $193
Internal Cost
$157,843
Billed
$96,739

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) 785 499 $145,783 $96,255 $49,528 66%
Other Expenses 215 146 $5,298 $0 $5,298 0%
Lodging 25 15 $3,689 $484 $3,205 13.1%
Per Diem 53 31 $1,975 $0 $1,975 0%
Airfare 2 2 $1,098 $0 $1,098 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 571 $157,843 $96,739 $61,104 61.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 318 $107,873 $65,271 $42,602 60.5%
Preventive Maintenance 132 $24,925 $15,035 $9,890 60.3%
Repair 105 $24,280 $16,120 $8,160 66.4%
Installation 15 $765 $313 $452 40.9%
PM 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed