Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
1,383
Total Travel Cost
$68,191
101,778 miles
Avoidable Cost
$40,719
60,775 excess miles
Optimal Cost
$27,472
If closest tech always used
Avg Excess / WO
43.9 mi
$29.44 per WO
Median Excess
11.0 mi
Outlier Rate (>50mi)
8.8%
122 WOs

Actual Travel Expenses

From 783 WOs with expense data
Total Expenses
$271,109
Labor - Travel
$199,913
Mileage
$0
Lodging
$28,629
Airfare
$6,746
Car Rental
$7,789
Per Diem
$11,525
Meals
$0
Other
$16,507

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)
$271,109
783 WOs with expenses
Billed to Client
$125,199
46.2% recovery rate
Margin Gap (Unbilled)
$145,910
Cost absorbed internally
Avg Expense / WO
$346
Avg billed: $160
Internal Cost
$271,109
Billed
$125,199

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) 1,377 881 $199,913 $117,995 $81,918 59%
Lodging 171 70 $28,629 $5,442 $23,187 19%
Other Expenses 957 511 $16,507 $1,687 $14,820 10.2%
Per Diem 279 134 $11,525 $0 $11,525 0%
Car Rental 33 25 $7,789 $25 $7,764 0.3%
Airfare 14 9 $6,746 $50 $6,696 0.7%
Meals 7 1 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 1,040 $271,109 $125,199 $145,910 46.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 284 $185,755 $79,449 $106,307 42.8%
Preventive Maintenance 502 $42,188 $21,545 $20,643 51.1%
Repair 118 $31,509 $17,043 $14,466 54.1%
Installation 40 $7,430 $4,993 $2,437 67.2%
PM 96 $4,227 $2,170 $2,057 51.3%

Monthly Expense Trend — Internal Cost vs Billed