Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
30
Total Travel Cost
$18,733
27,960 miles
Avoidable Cost
$14,333
21,392 excess miles
Optimal Cost
$4,401
If closest tech always used
Avg Excess / WO
713.1 mi
$477.76 per WO
Median Excess
789.0 mi
Outlier Rate (>50mi)
100%
30 WOs

Actual Travel Expenses

From 13 WOs with expense data
Total Expenses
$24,104
Labor - Travel
$14,304
Mileage
$0
Lodging
$2,683
Airfare
$3,041
Car Rental
$1,697
Per Diem
$925
Meals
$0
Other
$1,455

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)
$24,104
13 WOs with expenses
Billed to Client
$9,125
37.9% recovery rate
Margin Gap (Unbilled)
$14,979
Cost absorbed internally
Avg Expense / WO
$1,854
Avg billed: $702
Internal Cost
$24,104
Billed
$9,125

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) 47 12 $14,304 $5,236 $9,068 36.6%
Airfare 5 4 $3,041 $2,394 $647 78.7%
Lodging 16 5 $2,683 $820 $1,863 30.6%
Car Rental 12 4 $1,697 $339 $1,358 20%
Other Expenses 19 5 $1,455 $337 $1,118 23.1%
Per Diem 21 6 $925 $0 $925 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 13 $24,104 $9,125 $14,979 37.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 5 $19,281 $4,434 $14,847 23%
Preventive Maintenance 4 $4,443 $4,311 $131 97%
Repair 4 $380 $380 $0 100%

Monthly Expense Trend — Internal Cost vs Billed