Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,031
Total Travel Cost
$73,960
110,388 miles
Avoidable Cost
$61,886
92,368 excess miles
Optimal Cost
$12,073
If closest tech always used
Avg Excess / WO
89.6 mi
$60.03 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
32.5%
335 WOs

Actual Travel Expenses

From 87 WOs with expense data
Total Expenses
$27,974
Labor - Travel
$1,235
Mileage
$33
Lodging
$9,998
Airfare
$3,176
Car Rental
$2,708
Per Diem
$3,275
Meals
$0
Other
$7,549

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)
$27,974
87 WOs with expenses
Billed to Client
$3,513
12.6% recovery rate
Margin Gap (Unbilled)
$24,461
Cost absorbed internally
Avg Expense / WO
$322
Avg billed: $40
Internal Cost
$27,974
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 14 12 $9,998 $493 $9,505 4.9%
Other Expenses 125 86 $7,549 $444 $7,105 5.9%
Per Diem 72 45 $3,275 $175 $3,100 5.3%
Airfare 4 4 $3,176 $989 $2,187 31.1%
Car Rental 17 8 $2,708 $177 $2,531 6.5%
Labor - Travel (Hours) 504 428 $1,235 $1,235 $0 ✓ 100%
Mileage 2 2 $33 $0 $33 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Bed Services 455 $27,974 $3,513 $24,461 12.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 269 $13,384 $3,513 $9,872 26.2%
Preventive Maintenance 183 $10,520 $0 $10,520 0%
Cross-Training 2 $2,251 $0 $2,251 0%
Support 1 $1,818 $0 $1,818 0%

Monthly Expense Trend — Internal Cost vs Billed