Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
440
Total Travel Cost
$25,552
38,138 miles
Avoidable Cost
$9,344
13,946 excess miles
Optimal Cost
$16,208
If closest tech always used
Avg Excess / WO
31.7 mi
$21.24 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
19.5%
86 WOs

Actual Travel Expenses

From 250 WOs with expense data
Total Expenses
$30,034
Labor - Travel
$222
Mileage
$95
Lodging
$6,301
Airfare
$0
Car Rental
$1,053
Per Diem
$1,525
Meals
$0
Other
$20,839

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)
$30,034
250 WOs with expenses
Billed to Client
$222
0.7% recovery rate
Margin Gap (Unbilled)
$29,813
Cost absorbed internally
Avg Expense / WO
$120
Avg billed: $1
Internal Cost
$30,034
Billed
$222

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 338 251 $20,839 $0 $20,839 0%
Lodging 29 27 $6,301 $0 $6,301 0%
Per Diem 40 22 $1,525 $0 $1,525 0%
Car Rental 6 5 $1,053 $0 $1,053 0%
Labor - Travel (Hours) 642 434 $222 $222 $0 ✓ 100%
Mileage 2 1 $95 $0 $95 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 435 $30,034 $222 $29,813 0.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 153 $12,033 $151 $11,882 1.3%
Preventive Maintenance 201 $8,120 $70 $8,050 0.9%
Repair/PM 45 $5,280 $0 $5,280 0%
Installation 20 $2,604 $0 $2,604 0%
Connectivity 13 $1,721 $0 $1,721 0%
COMPLAINT 1 $181 $0 $181 0%
Cross-Training 1 $80 $0 $80 0%
Removal 1 $15 $0 $15 0%

Monthly Expense Trend — Internal Cost vs Billed