Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
586
Total Travel Cost
$80,524
120,186 miles
Avoidable Cost
$55,129
82,283 excess miles
Optimal Cost
$25,395
If closest tech always used
Avg Excess / WO
140.4 mi
$94.08 per WO
Median Excess
20.5 mi
Outlier Rate (>50mi)
36.2%
212 WOs

Actual Travel Expenses

From 235 WOs with expense data
Total Expenses
$62,076
Labor - Travel
$42,221
Mileage
$0
Lodging
$7,988
Airfare
$2,347
Car Rental
$2,153
Per Diem
$3,425
Meals
$0
Other
$3,942

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)
$62,076
235 WOs with expenses
Billed to Client
$42,061
67.8% recovery rate
Margin Gap (Unbilled)
$20,015
Cost absorbed internally
Avg Expense / WO
$264
Avg billed: $179
Internal Cost
$62,076
Billed
$42,061

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) 384 270 $42,221 $31,198 $11,023 73.9%
Lodging 52 25 $7,988 $5,348 $2,640 67%
Other Expenses 213 126 $3,942 $1,823 $2,120 46.2%
Per Diem 81 44 $3,425 $550 $2,875 16.1%
Airfare 5 4 $2,347 $2,446 $100 ✓ 104.3%
Car Rental 12 7 $2,153 $696 $1,457 32.3%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 338 $61,137 $42,061 $19,076 68.8%
Project 17 $939 $0 $939 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 124 $39,933 $26,460 $13,473 66.3%
Installation 32 $9,289 $9,320 $31 100.3%
Preventive Maintenance 140 $8,160 $3,720 $4,440 45.6%
Repair 18 $3,691 $2,561 $1,130 69.4%
Upgrade 17 $939 $0 $939 0%
PM 24 $64 $0 $64 0%

Monthly Expense Trend — Internal Cost vs Billed