Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
32
Total Travel Cost
$4,265
6,365 miles
Avoidable Cost
$2,996
4,472 excess miles
Optimal Cost
$1,268
If closest tech always used
Avg Excess / WO
139.7 mi
$93.63 per WO
Median Excess
93.4 mi
Outlier Rate (>50mi)
62.5%
20 WOs

Actual Travel Expenses

From 30 WOs with expense data
Total Expenses
$13,459
Labor - Travel
$7,531
Mileage
$0
Lodging
$2,705
Airfare
$910
Car Rental
$316
Per Diem
$800
Meals
$0
Other
$1,197

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)
$13,459
30 WOs with expenses
Billed to Client
$1,521
11.3% recovery rate
Margin Gap (Unbilled)
$11,939
Cost absorbed internally
Avg Expense / WO
$449
Avg billed: $51
Internal Cost
$13,459
Billed
$1,521

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) 36 16 $7,531 $1,503 $6,028 20%
Lodging 8 6 $2,705 $0 $2,705 0%
Other Expenses 18 11 $1,197 $17 $1,179 1.5%
Airfare 1 1 $910 $0 $910 0%
Per Diem 19 12 $800 $0 $800 0%
Car Rental 4 4 $316 $0 $316 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 30 $13,459 $1,521 $11,939 11.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Inspection 18 $7,998 $595 $7,403 7.4%
Repair 11 $5,277 $926 $4,352 17.5%
Preventive Maintenance 1 $183 $0 $183 0%

Monthly Expense Trend — Internal Cost vs Billed