Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
38
Total Travel Cost
$687
1,025 miles
Avoidable Cost
$255
380 excess miles
Optimal Cost
$432
If closest tech always used
Avg Excess / WO
10.0 mi
$6.70 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
13.2%
5 WOs

Actual Travel Expenses

From 29 WOs with expense data
Total Expenses
$5,124
Labor - Travel
$4,610
Mileage
$134
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$0
Meals
$0
Other
$381

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,124
29 WOs with expenses
Billed to Client
$1,376
26.8% recovery rate
Margin Gap (Unbilled)
$3,749
Cost absorbed internally
Avg Expense / WO
$177
Avg billed: $47
Internal Cost
$5,124
Billed
$1,376

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) 45 23 $4,610 $1,276 $3,334 27.7%
Other Expenses 24 19 $381 $100 $281 26.1%
Mileage 2 1 $134 $0 $134 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 12 $3,340 $246 $3,094 7.4%
EMS 18 $1,785 $1,130 $655 63.3%
Kiosk 2 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 25 $4,719 $1,227 $3,492 26%
Preventive Maintenance 5 $245 $0 $245 0%
Misc. Inspection 1 $149 $149 $0 100%
Evaluation 1 $11 $0 $11 0%

Monthly Expense Trend — Internal Cost vs Billed