Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
79
Total Travel Cost
$4,008
5,982 miles
Avoidable Cost
$1,385
2,067 excess miles
Optimal Cost
$2,623
If closest tech always used
Avg Excess / WO
26.2 mi
$17.53 per WO
Median Excess
19.3 mi
Outlier Rate (>50mi)
17.7%
14 WOs

Actual Travel Expenses

From 43 WOs with expense data
Total Expenses
$10,189
Labor - Travel
$8,874
Mileage
$488
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$0
Meals
$0
Other
$827

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)
$10,189
43 WOs with expenses
Billed to Client
$2,799
27.5% recovery rate
Margin Gap (Unbilled)
$7,391
Cost absorbed internally
Avg Expense / WO
$237
Avg billed: $65
Internal Cost
$10,189
Billed
$2,799

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) 69 37 $8,874 $2,711 $6,163 30.5%
Other Expenses 97 39 $827 $88 $739 10.6%
Mileage 2 1 $488 $0 $488 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 28 $6,783 $1,866 $4,918 27.5%
EMS 10 $2,792 $933 $1,859 33.4%
Bed Services 3 $501 $0 $501 0%
Kiosk 8 $113 $0 $113 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 26 $7,807 $1,858 $5,949 23.8%
Preventive Maintenance 10 $850 $0 $850 0%
Evaluation 2 $793 $390 $403 49.2%
Misc. Inspection 1 $387 $373 $14 96.4%
Inspection 9 $323 $179 $144 55.3%
Cross-Training 1 $31 $0 $31 0%

Monthly Expense Trend — Internal Cost vs Billed