Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
180
Total Travel Cost
$7,158
10,683 miles
Avoidable Cost
$3,468
5,176 excess miles
Optimal Cost
$3,690
If closest tech always used
Avg Excess / WO
28.8 mi
$19.27 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
12.2%
22 WOs

Actual Travel Expenses

From 149 WOs with expense data
Total Expenses
$22,449
Labor - Travel
$2,331
Mileage
$95
Lodging
$1,657
Airfare
$0
Car Rental
$27
Per Diem
$350
Meals
$0
Other
$17,989

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)
$22,449
149 WOs with expenses
Billed to Client
$1,654
7.4% recovery rate
Margin Gap (Unbilled)
$20,795
Cost absorbed internally
Avg Expense / WO
$151
Avg billed: $11
Internal Cost
$22,449
Billed
$1,654

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 214 148 $17,989 $0 $17,989 0%
Labor - Travel (Hours) 269 175 $2,331 $1,379 $952 59.2%
Lodging 10 9 $1,657 $0 $1,657 0%
Per Diem 10 5 $350 $275 $75 78.6%
Mileage 2 1 $95 $0 $95 0%
Car Rental 2 2 $27 $0 $27 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 177 $22,449 $1,654 $20,795 7.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 53 $7,733 $0 $7,733 0%
Preventive Maintenance 82 $5,714 $70 $5,644 1.2%
Repair/PM 24 $4,425 $0 $4,425 0%
Removal 2 $2,711 $1,584 $1,127 58.4%
Connectivity 8 $840 $0 $840 0%
Installation 5 $521 $0 $521 0%
Support 1 $243 $0 $243 0%
COMPLAINT 1 $181 $0 $181 0%
Cross-Training 1 $80 $0 $80 0%

Monthly Expense Trend — Internal Cost vs Billed