Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,904
Total Travel Cost
$296,093
441,930 miles
Avoidable Cost
$276,486
412,666 excess miles
Optimal Cost
$19,607
If closest tech always used
Avg Excess / WO
216.7 mi
$145.21 per WO
Median Excess
66.7 mi
Outlier Rate (>50mi)
56.9%
1,083 WOs

Actual Travel Expenses

From 168 WOs with expense data
Total Expenses
$36,715
Labor - Travel
$11,046
Mileage
$0
Lodging
$13,852
Airfare
$2,766
Car Rental
$2,114
Per Diem
$5,425
Meals
$0
Other
$1,512

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)
$36,715
168 WOs with expenses
Billed to Client
$25,129
68.4% recovery rate
Margin Gap (Unbilled)
$11,587
Cost absorbed internally
Avg Expense / WO
$219
Avg billed: $150
Internal Cost
$36,715
Billed
$25,129

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 63 55 $13,852 $6,533 $7,319 47.2%
Labor - Travel (Hours) 367 330 $11,046 $8,740 $2,306 79.1%
Per Diem 125 92 $5,425 $1,820 $3,605 33.5%
Airfare 6 4 $2,766 $3,872 $1,106 ✓ 140%
Car Rental 6 4 $2,114 $2,960 $846 ✓ 140%
Other Expenses 85 60 $1,512 $1,203 $309 79.6%
Meals 1 1 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Project 356 $36,715 $25,129 $11,587 68.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 31 $23,033 $25,129 $2,096 109.1%
Upgrade 325 $13,683 $0 $13,683 0%

Monthly Expense Trend — Internal Cost vs Billed