Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
77
Total Travel Cost
$4,963
7,407 miles
Avoidable Cost
$1,701
2,539 excess miles
Optimal Cost
$3,262
If closest tech always used
Avg Excess / WO
33.0 mi
$22.10 per WO
Median Excess
26.4 mi
Outlier Rate (>50mi)
28.6%
22 WOs

Actual Travel Expenses

From 29 WOs with expense data
Total Expenses
$3,095
Labor - Travel
$290
Mileage
$0
Lodging
$442
Airfare
$0
Car Rental
$0
Per Diem
$250
Meals
$0
Other
$2,113

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)
$3,095
29 WOs with expenses
Billed to Client
$723
23.4% recovery rate
Margin Gap (Unbilled)
$2,372
Cost absorbed internally
Avg Expense / WO
$107
Avg billed: $25
Internal Cost
$3,095
Billed
$723

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 23 22 $2,113 $467 $1,646 22.1%
Lodging 3 3 $442 $0 $442 0%
Labor - Travel (Hours) 107 74 $290 $256 $34 88.2%
Per Diem 7 7 $250 $0 $250 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Kiosk 74 $3,095 $723 $2,372 23.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 13 $1,375 $256 $1,119 18.6%
Preventive Maintenance 49 $707 $0 $707 0%
Repair/PM 6 $589 $0 $589 0%
Installation 4 $425 $467 $42 110%
COMPLAINT 1 $0 $0 $0 0%
Connectivity 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed