Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
37
Total Travel Cost
$5,770
8,611 miles
Avoidable Cost
$2,354
3,513 excess miles
Optimal Cost
$3,416
If closest tech always used
Avg Excess / WO
94.9 mi
$63.61 per WO
Median Excess
14.6 mi
Outlier Rate (>50mi)
29.7%
11 WOs

Actual Travel Expenses

From 19 WOs with expense data
Total Expenses
$10,915
Labor - Travel
$7,324
Mileage
$0
Lodging
$2,021
Airfare
$515
Car Rental
$30
Per Diem
$775
Meals
$0
Other
$251

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,915
19 WOs with expenses
Billed to Client
$2,620
24% recovery rate
Margin Gap (Unbilled)
$8,295
Cost absorbed internally
Avg Expense / WO
$574
Avg billed: $138
Internal Cost
$10,915
Billed
$2,620

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) 47 29 $7,324 $2,480 $4,844 33.9%
Lodging 13 9 $2,021 $140 $1,881 6.9%
Per Diem 18 10 $775 $0 $775 0%
Airfare 2 2 $515 $0 $515 0%
Other Expenses 17 7 $251 $0 $251 0%
Car Rental 1 1 $30 $0 $30 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 30 $10,915 $2,620 $8,295 24%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 12 $8,141 $2,310 $5,832 28.4%
Repair 4 $1,544 $310 $1,234 20.1%
Preventive Maintenance 12 $1,229 $0 $1,229 0%
PM 2 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed