Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
731
Total Travel Cost
$127,230
189,896 miles
Avoidable Cost
$110,650
165,149 excess miles
Optimal Cost
$16,581
If closest tech always used
Avg Excess / WO
225.9 mi
$151.37 per WO
Median Excess
50.7 mi
Outlier Rate (>50mi)
50.5%
369 WOs

Actual Travel Expenses

From 355 WOs with expense data
Total Expenses
$163,497
Labor - Travel
$133,540
Mileage
$0
Lodging
$10,900
Airfare
$5,755
Car Rental
$2,486
Per Diem
$4,825
Meals
$132
Other
$5,859

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)
$163,497
355 WOs with expenses
Billed to Client
$76,970
47.1% recovery rate
Margin Gap (Unbilled)
$86,527
Cost absorbed internally
Avg Expense / WO
$461
Avg billed: $217
Internal Cost
$163,497
Billed
$76,970

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
Labor - Travel (Hours) 767 408 $133,540 $74,935 $58,605 56.1%
Lodging 75 51 $10,900 $1,540 $9,360 14.1%
Other Expenses 145 110 $5,859 $80 $5,779 1.4%
Airfare 16 11 $5,755 $415 $5,340 7.2%
Per Diem 117 67 $4,825 $0 $4,825 0%
Car Rental 24 15 $2,486 $0 $2,486 0%
Meals 1 1 $132 $0 $132 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 471 $163,497 $76,970 $86,527 47.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 278 $130,791 $62,368 $68,423 47.7%
Preventive Maintenance 145 $18,556 $7,130 $11,426 38.4%
Repair 46 $12,668 $6,045 $6,623 47.7%
Installation 2 $1,481 $1,426 $55 96.3%

Monthly Expense Trend — Internal Cost vs Billed