Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
980
Total Travel Cost
$121,653
181,571 miles
Avoidable Cost
$114,720
171,224 excess miles
Optimal Cost
$6,933
If closest tech always used
Avg Excess / WO
174.7 mi
$117.06 per WO
Median Excess
5.7 mi
Outlier Rate (>50mi)
45.2%
443 WOs

Actual Travel Expenses

From 90 WOs with expense data
Total Expenses
$9,253
Labor - Travel
$3,294
Mileage
$0
Lodging
$3,668
Airfare
$0
Car Rental
$0
Per Diem
$1,350
Meals
$0
Other
$941

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)
$9,253
90 WOs with expenses
Billed to Client
$2,359
25.5% recovery rate
Margin Gap (Unbilled)
$6,894
Cost absorbed internally
Avg Expense / WO
$103
Avg billed: $26
Internal Cost
$9,253
Billed
$2,359

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
Lodging 23 22 $3,668 $344 $3,324 9.4%
Labor - Travel (Hours) 125 117 $3,294 $2,015 $1,279 61.2%
Per Diem 32 27 $1,350 $0 $1,350 0%
Other Expenses 55 54 $941 $0 $941 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 39 $4,774 $2,359 $2,415 49.4%
Project 114 $4,479 $0 $4,479 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Upgrade 114 $4,479 $0 $4,479 0%
FCO 30 $2,523 $964 $1,559 38.2%
Repair 9 $2,251 $1,395 $856 62%

Monthly Expense Trend — Internal Cost vs Billed