Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
466
Total Travel Cost
$74,675
111,456 miles
Avoidable Cost
$64,080
95,642 excess miles
Optimal Cost
$10,595
If closest tech always used
Avg Excess / WO
205.2 mi
$137.51 per WO
Median Excess
14.8 mi
Outlier Rate (>50mi)
40.8%
190 WOs

Actual Travel Expenses

From 186 WOs with expense data
Total Expenses
$68,955
Labor - Travel
$54,141
Mileage
$0
Lodging
$4,932
Airfare
$2,109
Car Rental
$979
Per Diem
$1,900
Meals
$458
Other
$4,436

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)
$68,955
186 WOs with expenses
Billed to Client
$36,262
52.6% recovery rate
Margin Gap (Unbilled)
$32,694
Cost absorbed internally
Avg Expense / WO
$371
Avg billed: $195
Internal Cost
$68,955
Billed
$36,262

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) 353 207 $54,141 $34,635 $19,506 64%
Lodging 32 17 $4,932 $1,132 $3,800 23%
Other Expenses 109 84 $4,436 $80 $4,356 1.8%
Airfare 9 5 $2,109 $415 $1,694 19.7%
Per Diem 46 25 $1,900 $0 $1,900 0%
Car Rental 11 5 $979 $0 $979 0%
Meals 1 1 $458 $0 $458 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 266 $68,955 $36,262 $32,694 52.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 152 $57,411 $30,031 $27,380 52.3%
Preventive Maintenance 93 $6,114 $2,170 $3,944 35.5%
Repair 19 $3,949 $2,635 $1,314 66.7%
Installation 2 $1,481 $1,426 $55 96.3%

Monthly Expense Trend — Internal Cost vs Billed