Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
234
Total Travel Cost
$16,492
24,615 miles
Avoidable Cost
$9,148
13,653 excess miles
Optimal Cost
$7,344
If closest tech always used
Avg Excess / WO
58.3 mi
$39.09 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
29.1%
68 WOs

Actual Travel Expenses

From 58 WOs with expense data
Total Expenses
$5,807
Labor - Travel
$341
Mileage
$0
Lodging
$950
Airfare
$0
Car Rental
$437
Per Diem
$125
Meals
$0
Other
$3,953

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)
$5,807
58 WOs with expenses
Billed to Client
$341
5.9% recovery rate
Margin Gap (Unbilled)
$5,466
Cost absorbed internally
Avg Expense / WO
$100
Avg billed: $6
Internal Cost
$5,807
Billed
$341

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 62 54 $3,953 $0 $3,953 0%
Lodging 4 4 $950 $0 $950 0%
Car Rental 5 2 $437 $0 $437 0%
Labor - Travel (Hours) 306 225 $341 $341 $0 ✓ 100%
Per Diem 4 4 $125 $0 $125 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 226 $5,807 $341 $5,466 5.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 200 $3,681 $0 $3,681 0%
Repair 15 $965 $0 $965 0%
Removal 1 $460 $0 $460 0%
COMPLAINT 1 $341 $341 $0 100%
Connectivity 3 $282 $0 $282 0%
Repair/PM 3 $77 $0 $77 0%
Installation 3 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed