Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
60
Total Travel Cost
$5,950
8,880 miles
Avoidable Cost
$3,313
4,945 excess miles
Optimal Cost
$2,637
If closest tech always used
Avg Excess / WO
82.4 mi
$55.22 per WO
Median Excess
68.7 mi
Outlier Rate (>50mi)
90%
54 WOs

Actual Travel Expenses

From 28 WOs with expense data
Total Expenses
$8,783
Labor - Travel
$5,692
Mileage
$2
Lodging
$2,037
Airfare
$0
Car Rental
$0
Per Diem
$950
Meals
$0
Other
$103

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)
$8,783
28 WOs with expenses
Billed to Client
$4,670
53.2% recovery rate
Margin Gap (Unbilled)
$4,114
Cost absorbed internally
Avg Expense / WO
$314
Avg billed: $167
Internal Cost
$8,783
Billed
$4,670

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) 39 21 $5,692 $3,978 $1,714 69.9%
Lodging 8 7 $2,037 $506 $1,530 24.9%
Per Diem 22 10 $950 $175 $775 18.4%
Other Expenses 15 11 $103 $10 $93 9.7%
Mileage 1 1 $2 $0 $2 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 21 $7,221 $3,978 $3,243 55.1%
EMS 5 $818 $0 $818 0%
Lab/Power 1 $691 $691 $0 100%
Kiosk 4 $53 $0 $53 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Misc. Inspection 11 $4,917 $3,651 $1,267 74.2%
Inspection 10 $2,670 $298 $2,372 11.2%
Overhaul 1 $691 $691 $0 100%
Repair 5 $449 $30 $420 6.6%
Repair/PM 1 $48 $0 $48 0%
Preventive Maintenance 3 $7 $0 $7 0%

Monthly Expense Trend — Internal Cost vs Billed