Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
108
Total Travel Cost
$8,653
12,914 miles
Avoidable Cost
$3,923
5,855 excess miles
Optimal Cost
$4,730
If closest tech always used
Avg Excess / WO
54.2 mi
$36.32 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
27.8%
30 WOs

Actual Travel Expenses

From 70 WOs with expense data
Total Expenses
$13,005
Labor - Travel
$4,738
Mileage
$4,619
Lodging
$1,406
Airfare
$0
Car Rental
$245
Per Diem
$1,175
Meals
$0
Other
$822

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)
$13,005
70 WOs with expenses
Billed to Client
$4,759
36.6% recovery rate
Margin Gap (Unbilled)
$8,246
Cost absorbed internally
Avg Expense / WO
$186
Avg billed: $68
Internal Cost
$13,005
Billed
$4,759

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) 73 43 $4,738 $3,438 $1,300 72.6%
Mileage 57 29 $4,619 $975 $3,644 21.1%
Lodging 6 6 $1,406 $0 $1,406 0%
Per Diem 29 16 $1,175 $0 $1,175 0%
Other Expenses 42 35 $822 $346 $476 42.1%
Car Rental 2 2 $245 $0 $245 0%
Airfare 2 2 $0 $0 $0 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 81 $13,005 $4,759 $8,246 36.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 41 $5,368 $3,394 $1,974 63.2%
Preventive Maintenance 34 $5,363 $975 $4,388 18.2%
Cross-Training 3 $1,793 $0 $1,793 0%
Evaluation 3 $481 $390 $91 81.1%

Monthly Expense Trend — Internal Cost vs Billed