Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
53
Total Travel Cost
$8,646
12,904 miles
Avoidable Cost
$1,098
1,639 excess miles
Optimal Cost
$7,547
If closest tech always used
Avg Excess / WO
30.9 mi
$20.72 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
9.4%
5 WOs

Actual Travel Expenses

From 27 WOs with expense data
Total Expenses
$9,018
Labor - Travel
$5,758
Mileage
$495
Lodging
$1,888
Airfare
$0
Car Rental
$49
Per Diem
$475
Meals
$0
Other
$353

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)
$9,018
27 WOs with expenses
Billed to Client
$6,500
72.1% recovery rate
Margin Gap (Unbilled)
$2,518
Cost absorbed internally
Avg Expense / WO
$334
Avg billed: $241
Internal Cost
$9,018
Billed
$6,500

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) 24 11 $5,758 $5,008 $750 87%
Lodging 13 9 $1,888 $1,449 $439 76.7%
Mileage 5 3 $495 $0 $495 0%
Per Diem 11 9 $475 $0 $475 0%
Other Expenses 32 19 $353 $43 $310 12.3%
Car Rental 1 1 $49 $0 $49 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 5 $4,778 $4,186 $593 87.6%
FCO 15 $1,795 $1,123 $672 62.6%
EMS 6 $1,749 $966 $784 55.2%
Animal Health 1 $435 $225 $210 51.7%
Kiosk 1 $259 $0 $259 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Delivery 4 $3,912 $3,324 $588 85%
Repair 3 $1,689 $1,191 $499 70.5%
FCO 14 $1,593 $1,015 $578 63.7%
Installation 2 $1,068 $969 $99 90.7%
Preventive Maintenance 5 $755 $0 $755 0%

Monthly Expense Trend — Internal Cost vs Billed