Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
69
Total Travel Cost
$1,089
1,626 miles
Avoidable Cost
$302
451 excess miles
Optimal Cost
$787
If closest tech always used
Avg Excess / WO
6.5 mi
$4.38 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
7.2%
5 WOs

Actual Travel Expenses

From 50 WOs with expense data
Total Expenses
$8,911
Labor - Travel
$8,239
Mileage
$146
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$0
Meals
$0
Other
$525

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)
$8,911
50 WOs with expenses
Billed to Client
$2,575
28.9% recovery rate
Margin Gap (Unbilled)
$6,336
Cost absorbed internally
Avg Expense / WO
$178
Avg billed: $51
Internal Cost
$8,911
Billed
$2,575

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) 83 48 $8,239 $2,427 $5,812 29.5%
Other Expenses 49 28 $525 $148 $378 28.1%
Mileage 4 2 $146 $0 $146 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 23 $6,037 $395 $5,642 6.5%
EMS 29 $2,814 $2,120 $694 75.3%
Animal Health 1 $60 $60 $0 100%
Kiosk 6 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 37 $7,418 $1,795 $5,624 24.2%
Preventive Maintenance 13 $749 $325 $424 43.4%
Evaluation 4 $258 $247 $11 95.7%
Delivery 1 $222 $0 $222 0%
Misc. Inspection 1 $149 $149 $0 100%
Asset Tagging 1 $60 $60 $0 100%
Installation 2 $55 $0 $55 0%

Monthly Expense Trend — Internal Cost vs Billed