Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,881
Total Travel Cost
$130,189
194,311 miles
Avoidable Cost
$108,004
161,200 excess miles
Optimal Cost
$22,184
If closest tech always used
Avg Excess / WO
85.7 mi
$57.42 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
32.1%
603 WOs

Actual Travel Expenses

From 193 WOs with expense data
Total Expenses
$46,786
Labor - Travel
$1,235
Mileage
$41
Lodging
$18,676
Airfare
$5,155
Car Rental
$3,936
Per Diem
$6,550
Meals
$0
Other
$11,194

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)
$46,786
193 WOs with expenses
Billed to Client
$3,513
7.5% recovery rate
Margin Gap (Unbilled)
$43,274
Cost absorbed internally
Avg Expense / WO
$242
Avg billed: $18
Internal Cost
$46,786
Billed
$3,513

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
Lodging 27 24 $18,676 $493 $18,183 2.6%
Other Expenses 221 158 $11,194 $444 $10,750 4%
Per Diem 144 95 $6,550 $175 $6,375 2.7%
Airfare 7 7 $5,155 $989 $4,166 19.2%
Car Rental 26 14 $3,936 $177 $3,759 4.5%
Labor - Travel (Hours) 980 833 $1,235 $1,235 $0 ✓ 100%
Mileage 2 2 $41 $0 $41 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Bed Services 881 $46,786 $3,513 $43,274 7.5%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 506 $20,660 $3,513 $17,148 17%
Preventive Maintenance 371 $20,006 $0 $20,006 0%
Cross-Training 3 $4,302 $0 $4,302 0%
Support 1 $1,818 $0 $1,818 0%

Monthly Expense Trend — Internal Cost vs Billed