Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
30
Total Travel Cost
$10,289
15,357 miles
Avoidable Cost
$9,560
14,269 excess miles
Optimal Cost
$729
If closest tech always used
Avg Excess / WO
475.6 mi
$318.67 per WO
Median Excess
177.5 mi
Outlier Rate (>50mi)
80%
24 WOs

Actual Travel Expenses

From 21 WOs with expense data
Total Expenses
$10,365
Labor - Travel
$8,089
Mileage
$0
Lodging
$537
Airfare
$0
Car Rental
$238
Per Diem
$1,000
Meals
$0
Other
$502

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)
$10,365
21 WOs with expenses
Billed to Client
$2,753
26.6% recovery rate
Margin Gap (Unbilled)
$7,612
Cost absorbed internally
Avg Expense / WO
$494
Avg billed: $131
Internal Cost
$10,365
Billed
$2,753

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) 23 12 $8,089 $2,753 $5,336 34%
Per Diem 21 13 $1,000 $0 $1,000 0%
Lodging 2 2 $537 $0 $537 0%
Other Expenses 10 5 $502 $0 $502 0%
Car Rental 6 6 $238 $0 $238 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 22 $10,365 $2,753 $7,612 26.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Inspection 11 $5,019 $0 $5,019 0%
Repair 6 $3,972 $1,710 $2,262 43.1%
Misc. Inspection 4 $1,143 $1,043 $100 91.3%
Warranty 1 $232 $0 $232 0%

Monthly Expense Trend — Internal Cost vs Billed