Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
82
Total Travel Cost
$8,793
13,125 miles
Avoidable Cost
$3,408
5,086 excess miles
Optimal Cost
$5,386
If closest tech always used
Avg Excess / WO
62.0 mi
$41.56 per WO
Median Excess
18.9 mi
Outlier Rate (>50mi)
26.8%
22 WOs

Actual Travel Expenses

From 25 WOs with expense data
Total Expenses
$4,409
Labor - Travel
$1,238
Mileage
$1,537
Lodging
$792
Airfare
$0
Car Rental
$162
Per Diem
$400
Meals
$0
Other
$279

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)
$4,409
25 WOs with expenses
Billed to Client
$1,447
32.8% recovery rate
Margin Gap (Unbilled)
$2,961
Cost absorbed internally
Avg Expense / WO
$176
Avg billed: $58
Internal Cost
$4,409
Billed
$1,447

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
Mileage 8 4 $1,537 $500 $1,037 32.5%
Labor - Travel (Hours) 35 27 $1,238 $545 $693 44%
Lodging 5 5 $792 $340 $453 42.9%
Per Diem 11 9 $400 $0 $400 0%
Other Expenses 15 13 $279 $63 $216 22.5%
Car Rental 3 2 $162 $0 $162 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 9 $2,386 $953 $1,433 39.9%
FCO 25 $1,254 $495 $759 39.4%
Healthcare Provider 1 $693 $0 $693 0%
Kiosk 3 $76 $0 $76 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 26 $2,532 $500 $2,032 19.8%
Delivery 1 $693 $0 $693 0%
Repair 4 $486 $453 $33 93.1%
Installation 3 $459 $340 $120 74%
FCO 4 $239 $155 $84 64.9%

Monthly Expense Trend — Internal Cost vs Billed