Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
488
Total Travel Cost
$66,374
99,066 miles
Avoidable Cost
$43,474
64,886 excess miles
Optimal Cost
$22,901
If closest tech always used
Avg Excess / WO
133.0 mi
$89.09 per WO
Median Excess
14.4 mi
Outlier Rate (>50mi)
27%
132 WOs

Actual Travel Expenses

From 229 WOs with expense data
Total Expenses
$61,137
Labor - Travel
$42,221
Mileage
$0
Lodging
$7,424
Airfare
$2,347
Car Rental
$2,153
Per Diem
$3,150
Meals
$0
Other
$3,842

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)
$61,137
229 WOs with expenses
Billed to Client
$42,061
68.8% recovery rate
Margin Gap (Unbilled)
$19,076
Cost absorbed internally
Avg Expense / WO
$267
Avg billed: $184
Internal Cost
$61,137
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) 369 255 $42,221 $31,198 $11,023 73.9%
Lodging 49 22 $7,424 $5,348 $2,075 72%
Other Expenses 203 125 $3,842 $1,823 $2,020 47.4%
Per Diem 75 38 $3,150 $550 $2,600 17.5%
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%

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%
PM 24 $64 $0 $64 0%

Monthly Expense Trend — Internal Cost vs Billed