Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
19
Total Travel Cost
$2,570
3,836 miles
Avoidable Cost
$597
891 excess miles
Optimal Cost
$1,973
If closest tech always used
Avg Excess / WO
46.9 mi
$31.43 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
42.1%
8 WOs

Actual Travel Expenses

From 11 WOs with expense data
Total Expenses
$6,578
Labor - Travel
$4,345
Mileage
$407
Lodging
$780
Airfare
$0
Car Rental
$0
Per Diem
$450
Meals
$0
Other
$596

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)
$6,578
11 WOs with expenses
Billed to Client
$4,327
65.8% recovery rate
Margin Gap (Unbilled)
$2,252
Cost absorbed internally
Avg Expense / WO
$598
Avg billed: $393
Internal Cost
$6,578
Billed
$4,327

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) 27 14 $4,345 $3,565 $780 82%
Lodging 5 3 $780 $275 $505 35.2%
Other Expenses 11 6 $596 $487 $109 81.7%
Per Diem 12 10 $450 $0 $450 0%
Mileage 4 1 $407 $0 $407 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 14 $6,028 $3,777 $2,252 62.6%
Healthcare Provider 1 $550 $550 $0 100%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Installation 4 $4,768 $3,777 $991 79.2%
Repair 9 $1,050 $550 $500 52.4%
Preventive Maintenance 1 $736 $0 $736 0%
Evaluation 1 $25 $0 $25 0%

Monthly Expense Trend — Internal Cost vs Billed