Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
20
Total Travel Cost
$1,292
1,928 miles
Avoidable Cost
$909
1,357 excess miles
Optimal Cost
$383
If closest tech always used
Avg Excess / WO
67.8 mi
$45.46 per WO
Median Excess
49.7 mi
Outlier Rate (>50mi)
40%
8 WOs

Actual Travel Expenses

From 18 WOs with expense data
Total Expenses
$6,845
Labor - Travel
$4,353
Mileage
$0
Lodging
$612
Airfare
$582
Car Rental
$381
Per Diem
$325
Meals
$0
Other
$592

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)
$6,845
18 WOs with expenses
Billed to Client
$1,415
20.7% recovery rate
Margin Gap (Unbilled)
$5,430
Cost absorbed internally
Avg Expense / WO
$380
Avg billed: $79
Internal Cost
$6,845
Billed
$1,415

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) 28 16 $4,353 $1,175 $3,178 27%
Lodging 2 2 $612 $0 $612 0%
Other Expenses 19 15 $592 $241 $352 40.6%
Airfare 1 1 $582 $0 $582 0%
Car Rental 2 1 $381 $0 $381 0%
Per Diem 8 4 $325 $0 $325 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Animal Health 18 $6,845 $1,415 $5,430 20.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Installation 2 $2,940 $0 $2,940 0%
Repair 6 $2,275 $431 $1,845 18.9%
Preventive Maintenance 10 $1,630 $984 $645 60.4%

Monthly Expense Trend — Internal Cost vs Billed