Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
42
Total Travel Cost
$11,449
17,088 miles
Avoidable Cost
$8,725
13,022 excess miles
Optimal Cost
$2,724
If closest tech always used
Avg Excess / WO
310.1 mi
$207.74 per WO
Median Excess
266.8 mi
Outlier Rate (>50mi)
97.6%
41 WOs

Actual Travel Expenses

From 10 WOs with expense data
Total Expenses
$1,914
Labor - Travel
$1,170
Mileage
$0
Lodging
$260
Airfare
$0
Car Rental
$234
Per Diem
$125
Meals
$0
Other
$125

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)
$1,914
10 WOs with expenses
Billed to Client
$820
42.8% recovery rate
Margin Gap (Unbilled)
$1,095
Cost absorbed internally
Avg Expense / WO
$191
Avg billed: $82
Internal Cost
$1,914
Billed
$820

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
Labor - Travel (Hours) 52 35 $1,170 $260 $910 22.2%
Lodging 1 1 $260 $260 $0 ✓ 100%
Car Rental 4 1 $234 $234 $0 ✓ 100%
Other Expenses 14 10 $125 $66 $60 52.3%
Per Diem 3 1 $125 $0 $125 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Lab/Power 1 $1,554 $494 $1,060 31.8%
EMS 6 $335 $326 $10 97.1%
Kiosk 31 $25 $0 $25 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
PQ Only 1 $1,554 $494 $1,060 31.8%
Repair 6 $335 $326 $10 97.1%
Preventive Maintenance 31 $25 $0 $25 0%

Monthly Expense Trend — Internal Cost vs Billed