Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
322
Total Travel Cost
$25,301
37,763 miles
Avoidable Cost
$21,735
32,440 excess miles
Optimal Cost
$3,567
If closest tech always used
Avg Excess / WO
100.7 mi
$67.50 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
15.5%
50 WOs

Actual Travel Expenses

From 40 WOs with expense data
Total Expenses
$33,274
Labor - Travel
$7,086
Mileage
$0
Lodging
$10,181
Airfare
$3,014
Car Rental
$5,638
Per Diem
$2,775
Meals
$0
Other
$4,580

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)
$33,274
40 WOs with expenses
Billed to Client
$20,315
61.1% recovery rate
Margin Gap (Unbilled)
$12,959
Cost absorbed internally
Avg Expense / WO
$832
Avg billed: $508
Internal Cost
$33,274
Billed
$20,315

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 22 19 $10,181 $7,663 $2,519 75.3%
Labor - Travel (Hours) 617 282 $7,086 $0 $7,086 0%
Car Rental 52 17 $5,638 $4,516 $1,123 80.1%
Other Expenses 74 28 $4,580 $3,862 $718 84.3%
Airfare 9 8 $3,014 $2,550 $464 84.6%
Per Diem 65 27 $2,775 $1,725 $1,050 62.2%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Lab/Power 282 $33,274 $20,315 $12,959 61.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
IOQ 10 $14,891 $3,182 $11,710 21.4%
Repair/PM 5 $7,145 $7,145 $0 100%
Preventive Maintenance 193 $5,844 $5,549 $295 94.9%
Overhaul 7 $4,440 $4,440 $0 100%
Repair 22 $813 $0 $813 0%
EOQ 39 $141 $0 $141 0%
Calibration 6 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed