Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
11
Total Travel Cost
$785
1,171 miles
Avoidable Cost
$154
230 excess miles
Optimal Cost
$631
If closest tech always used
Avg Excess / WO
20.9 mi
$14.01 per WO
Median Excess
16.7 mi
Outlier Rate (>50mi)
9.1%
1 WOs

Actual Travel Expenses

From 6 WOs with expense data
Total Expenses
$1,138
Labor - Travel
$835
Mileage
$0
Lodging
$139
Airfare
$0
Car Rental
$0
Per Diem
$0
Meals
$0
Other
$164

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)
$1,138
6 WOs with expenses
Billed to Client
$636
55.9% recovery rate
Margin Gap (Unbilled)
$502
Cost absorbed internally
Avg Expense / WO
$190
Avg billed: $106
Internal Cost
$1,138
Billed
$636

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) 13 8 $835 $565 $270 67.7%
Other Expenses 7 5 $164 $71 $93 43.1%
Lodging 1 1 $139 $0 $139 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Animal Health 1 $510 $240 $270 47.1%
EMS 3 $394 $396 $2 100.5%
Kiosk 5 $234 $0 $234 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 5 $994 $636 $358 64%
Preventive Maintenance 4 $144 $0 $144 0%

Monthly Expense Trend — Internal Cost vs Billed