Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
35
Total Travel Cost
$1,677
2,503 miles
Avoidable Cost
$693
1,034 excess miles
Optimal Cost
$984
If closest tech always used
Avg Excess / WO
29.5 mi
$19.79 per WO
Median Excess
11.9 mi
Outlier Rate (>50mi)
20%
7 WOs

Actual Travel Expenses

From 20 WOs with expense data
Total Expenses
$5,952
Labor - Travel
$5,326
Mileage
$327
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$0
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)
$5,952
20 WOs with expenses
Billed to Client
$897
15.1% recovery rate
Margin Gap (Unbilled)
$5,055
Cost absorbed internally
Avg Expense / WO
$298
Avg billed: $45
Internal Cost
$5,952
Billed
$897

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) 39 22 $5,326 $728 $4,599 13.7%
Mileage 4 2 $327 $0 $327 0%
Other Expenses 15 12 $299 $170 $130 56.7%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 10 $5,021 $588 $4,433 11.7%
EMS 12 $913 $309 $604 33.8%
Kiosk 5 $18 $0 $18 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 15 $5,510 $897 $4,613 16.3%
Preventive Maintenance 8 $420 $0 $420 0%
Part Order 1 $18 $0 $18 0%
Inspection 1 $5 $0 $5 0%
Evaluation 1 $0 $0 $0 0%
Repair/PM 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed