Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,254
Total Travel Cost
$187,340
279,611 miles
Avoidable Cost
$178,665
266,664 excess miles
Optimal Cost
$8,675
If closest tech always used
Avg Excess / WO
212.7 mi
$142.48 per WO
Median Excess
66.2 mi
Outlier Rate (>50mi)
50.6%
634 WOs

Actual Travel Expenses

From 129 WOs with expense data
Total Expenses
$15,273
Labor - Travel
$6,820
Mileage
$0
Lodging
$5,188
Airfare
$0
Car Rental
$0
Per Diem
$2,400
Meals
$0
Other
$865

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)
$15,273
129 WOs with expenses
Billed to Client
$3,909
25.6% recovery rate
Margin Gap (Unbilled)
$11,364
Cost absorbed internally
Avg Expense / WO
$118
Avg billed: $30
Internal Cost
$15,273
Billed
$3,909

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) 211 195 $6,820 $3,565 $3,255 52.3%
Lodging 33 30 $5,188 $344 $4,844 6.6%
Per Diem 56 48 $2,400 $0 $2,400 0%
Other Expenses 70 68 $865 $0 $865 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 44 $8,180 $3,909 $4,271 47.8%
Project 194 $7,093 $0 $7,093 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Upgrade 194 $7,093 $0 $7,093 0%
FCO 32 $3,793 $1,274 $2,519 33.6%
Repair 11 $2,604 $1,705 $899 65.5%
Preventive Maintenance 1 $1,783 $930 $853 52.2%

Monthly Expense Trend — Internal Cost vs Billed