Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
424
Total Travel Cost
$21,838
32,594 miles
Avoidable Cost
$10,735
16,022 excess miles
Optimal Cost
$11,103
If closest tech always used
Avg Excess / WO
37.8 mi
$25.32 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
13.4%
57 WOs

Actual Travel Expenses

From 141 WOs with expense data
Total Expenses
$9,801
Labor - Travel
$0
Mileage
$0
Lodging
$339
Airfare
$0
Car Rental
$204
Per Diem
$475
Meals
$0
Other
$8,783

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)
$9,801
141 WOs with expenses
Billed to Client
$1,259
12.8% recovery rate
Margin Gap (Unbilled)
$8,542
Cost absorbed internally
Avg Expense / WO
$70
Avg billed: $9
Internal Cost
$9,801
Billed
$1,259

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 145 134 $8,783 $1,259 $7,525 14.3%
Per Diem 13 13 $475 $0 $475 0%
Lodging 2 2 $339 $0 $339 0%
Car Rental 4 1 $204 $0 $204 0%
Labor - Travel (Hours) 590 420 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 420 $9,801 $1,259 $8,542 12.8%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 74 $4,324 $0 $4,324 0%
Repair/PM 42 $3,058 $0 $3,058 0%
Removal 18 $1,183 $1,259 $76 106.4%
Preventive Maintenance 255 $696 $0 $696 0%
Connectivity 12 $450 $0 $450 0%
Installation 18 $91 $0 $91 0%
Relocation 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed