Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
2,621
Total Travel Cost
$271,662
405,466 miles
Avoidable Cost
$228,604
341,201 excess miles
Optimal Cost
$43,057
If closest tech always used
Avg Excess / WO
130.2 mi
$87.22 per WO
Median Excess
6.1 mi
Outlier Rate (>50mi)
34%
891 WOs

Actual Travel Expenses

From 227 WOs with expense data
Total Expenses
$68,803
Labor - Travel
$2,815
Mileage
$49
Lodging
$27,904
Airfare
$8,330
Car Rental
$6,966
Per Diem
$8,425
Meals
$0
Other
$14,314

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)
$68,803
227 WOs with expenses
Billed to Client
$4,454
6.5% recovery rate
Margin Gap (Unbilled)
$64,349
Cost absorbed internally
Avg Expense / WO
$303
Avg billed: $20
Internal Cost
$68,803
Billed
$4,454

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 41 37 $27,904 $493 $27,411 1.8%
Other Expenses 293 208 $14,314 $600 $13,714 4.2%
Per Diem 181 100 $8,425 $375 $8,050 4.5%
Airfare 13 12 $8,330 $989 $7,341 11.9%
Car Rental 36 21 $6,966 $177 $6,789 2.5%
Labor - Travel (Hours) 1,089 860 $2,815 $1,820 $995 64.7%
Mileage 3 3 $49 $0 $49 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Bed Services 939 $68,803 $4,454 $64,349 6.5%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 454 $35,965 $200 $35,765 0.6%
Repair 476 $19,549 $4,254 $15,295 21.8%
Cross-Training 6 $11,471 $0 $11,471 0%
Support 1 $1,818 $0 $1,818 0%
Evaluation 2 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed