Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
165
Total Travel Cost
$204,639
305,431 miles
Avoidable Cost
$64,433
96,169 excess miles
Optimal Cost
$140,205
If closest tech always used
Avg Excess / WO
582.8 mi
$390.51 per WO
Median Excess
414.3 mi
Outlier Rate (>50mi)
77.6%
128 WOs

Actual Travel Expenses

From 131 WOs with expense data
Total Expenses
$102,498
Labor - Travel
$68,764
Mileage
$0
Lodging
$9,894
Airfare
$10,260
Car Rental
$2,820
Per Diem
$3,150
Meals
$0
Other
$7,610

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)
$102,498
131 WOs with expenses
Billed to Client
$63,238
61.7% recovery rate
Margin Gap (Unbilled)
$39,260
Cost absorbed internally
Avg Expense / WO
$782
Avg billed: $483
Internal Cost
$102,498
Billed
$63,238

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) 240 131 $68,764 $41,863 $26,901 60.9%
Airfare 19 16 $10,260 $11,031 $771 ✓ 107.5%
Lodging 39 19 $9,894 $6,619 $3,276 66.9%
Other Expenses 106 21 $7,610 $967 $6,643 12.7%
Per Diem 71 23 $3,150 $0 $3,150 0%
Car Rental 20 11 $2,820 $2,759 $61 97.8%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 131 $102,498 $63,238 $39,260 61.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 125 $101,785 $62,526 $39,260 61.4%
Repair 6 $713 $713 $0 100%

Monthly Expense Trend — Internal Cost vs Billed