Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
13
Total Travel Cost
$3,547
5,294 miles
Avoidable Cost
$1,810
2,702 excess miles
Optimal Cost
$1,737
If closest tech always used
Avg Excess / WO
207.8 mi
$139.24 per WO
Median Excess
68.5 mi
Outlier Rate (>50mi)
69.2%
9 WOs

Actual Travel Expenses

From 9 WOs with expense data
Total Expenses
$7,654
Labor - Travel
$5,017
Mileage
$0
Lodging
$1,130
Airfare
$263
Car Rental
$520
Per Diem
$425
Meals
$0
Other
$299

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)
$7,654
9 WOs with expenses
Billed to Client
$2,944
38.5% recovery rate
Margin Gap (Unbilled)
$4,710
Cost absorbed internally
Avg Expense / WO
$850
Avg billed: $327
Internal Cost
$7,654
Billed
$2,944

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) 21 10 $5,017 $2,475 $2,542 49.3%
Lodging 7 4 $1,130 $175 $955 15.5%
Car Rental 2 1 $520 $0 $520 0%
Per Diem 10 6 $425 $0 $425 0%
Other Expenses 12 5 $299 $31 $268 10.3%
Airfare 1 1 $263 $263 $0 ✓ 100%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 4 $5,522 $1,968 $3,554 35.6%
Healthcare Provider 2 $1,224 $945 $279 77.2%
Animal Health 1 $643 $31 $612 4.8%
EMS 1 $216 $0 $216 0%
Kiosk 2 $50 $0 $50 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 4 $5,522 $1,968 $3,554 35.6%
Repair 2 $1,796 $976 $820 54.3%
Preventive Maintenance 2 $286 $0 $286 0%
Installation 2 $50 $0 $50 0%

Monthly Expense Trend — Internal Cost vs Billed