Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
285
Total Travel Cost
$22,914
34,200 miles
Avoidable Cost
$13,344
19,916 excess miles
Optimal Cost
$9,571
If closest tech always used
Avg Excess / WO
69.9 mi
$46.82 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
8.8%
25 WOs

Actual Travel Expenses

From 91 WOs with expense data
Total Expenses
$20,141
Labor - Travel
$273
Mileage
$0
Lodging
$5,323
Airfare
$0
Car Rental
$31
Per Diem
$2,925
Meals
$0
Other
$11,588

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)
$20,141
91 WOs with expenses
Billed to Client
$578
2.9% recovery rate
Margin Gap (Unbilled)
$19,563
Cost absorbed internally
Avg Expense / WO
$221
Avg billed: $6
Internal Cost
$20,141
Billed
$578

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
Other Expenses 144 85 $11,588 $305 $11,283 2.6%
Lodging 14 1 $5,323 $0 $5,323 0%
Per Diem 68 11 $2,925 $0 $2,925 0%
Labor - Travel (Hours) 565 283 $273 $273 $0 ✓ 100%
Car Rental 1 1 $31 $0 $31 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 283 $20,141 $578 $19,563 2.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Installation 9 $11,761 $0 $11,761 0%
Repair 60 $4,959 $273 $4,686 5.5%
Repair/PM 22 $1,961 $0 $1,961 0%
Connectivity 9 $428 $0 $428 0%
Removal 4 $424 $305 $119 71.9%
Relocation 1 $311 $0 $311 0%
Preventive Maintenance 178 $296 $0 $296 0%

Monthly Expense Trend — Internal Cost vs Billed