Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
89
Total Travel Cost
$10,730
16,015 miles
Avoidable Cost
$9,800
14,627 excess miles
Optimal Cost
$930
If closest tech always used
Avg Excess / WO
164.3 mi
$110.11 per WO
Median Excess
6.8 mi
Outlier Rate (>50mi)
33.7%
30 WOs

Actual Travel Expenses

From 25 WOs with expense data
Total Expenses
$5,408
Labor - Travel
$1,041
Mileage
$0
Lodging
$930
Airfare
$590
Car Rental
$500
Per Diem
$0
Meals
$0
Other
$2,347

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,408
25 WOs with expenses
Billed to Client
$555
10.3% recovery rate
Margin Gap (Unbilled)
$4,853
Cost absorbed internally
Avg Expense / WO
$216
Avg billed: $22
Internal Cost
$5,408
Billed
$555

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
Other Expenses 27 27 $2,347 $19 $2,328 0.8%
Labor - Travel (Hours) 43 23 $1,041 $536 $506 51.4%
Lodging 1 1 $930 $0 $930 0%
Airfare 1 1 $590 $0 $590 0%
Car Rental 2 1 $500 $0 $500 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Bed Services 41 $4,349 $0 $4,349 0%
Healthcare Provider 1 $1,041 $536 $506 51.4%
EMS 1 $18 $19 $2 110%
Training/Other 2 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 24 $4,064 $0 $4,064 0%
Repair 19 $1,344 $555 $789 41.3%
Cross-Training 1 $0 $0 $0 0%
New Hire Training 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed