Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
32
Total Travel Cost
$7,839
11,701 miles
Avoidable Cost
$2,919
4,357 excess miles
Optimal Cost
$4,921
If closest tech always used
Avg Excess / WO
136.1 mi
$91.21 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
31.3%
10 WOs

Actual Travel Expenses

From 18 WOs with expense data
Total Expenses
$10,599
Labor - Travel
$438
Mileage
$0
Lodging
$1,980
Airfare
$5,448
Car Rental
$1,171
Per Diem
$950
Meals
$0
Other
$612

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)
$10,599
18 WOs with expenses
Billed to Client
$5,350
50.5% recovery rate
Margin Gap (Unbilled)
$5,249
Cost absorbed internally
Avg Expense / WO
$589
Avg billed: $297
Internal Cost
$10,599
Billed
$5,350

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
Airfare 8 7 $5,448 $2,472 $2,976 45.4%
Lodging 8 8 $1,980 $1,344 $636 67.9%
Car Rental 13 7 $1,171 $719 $452 61.4%
Per Diem 23 14 $950 $675 $275 71.1%
Other Expenses 20 10 $612 $139 $473 22.7%
Labor - Travel (Hours) 61 31 $438 $0 $438 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Lab/Power 32 $10,599 $5,350 $5,249 50.5%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 14 $7,080 $2,243 $4,837 31.7%
Repair/PM 11 $2,736 $2,736 $0 100%
Repair 3 $438 $0 $438 0%
Overhaul 4 $346 $371 $25 107.2%

Monthly Expense Trend — Internal Cost vs Billed