Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
51
Total Travel Cost
$3,462
5,167 miles
Avoidable Cost
$1,895
2,828 excess miles
Optimal Cost
$1,567
If closest tech always used
Avg Excess / WO
55.5 mi
$37.16 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
13.7%
7 WOs

Actual Travel Expenses

From 9 WOs with expense data
Total Expenses
$5,171
Labor - Travel
$2,695
Mileage
$0
Lodging
$962
Airfare
$796
Car Rental
$84
Per Diem
$350
Meals
$0
Other
$284

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)
$5,171
9 WOs with expenses
Billed to Client
$780
15.1% recovery rate
Margin Gap (Unbilled)
$4,391
Cost absorbed internally
Avg Expense / WO
$575
Avg billed: $87
Internal Cost
$5,171
Billed
$780

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) 17 13 $2,695 $605 $2,090 22.4%
Lodging 7 5 $962 $175 $787 18.2%
Airfare 1 1 $796 $0 $796 0%
Per Diem 9 5 $350 $0 $350 0%
Other Expenses 8 5 $284 $0 $284 0%
Car Rental 1 1 $84 $0 $84 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 4 $3,590 $780 $2,810 21.7%
Bed Services 14 $1,580 $0 $1,580 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Delivery 1 $3,077 $780 $2,297 25.3%
Preventive Maintenance 10 $1,271 $0 $1,271 0%
Inspection 2 $458 $0 $458 0%
Repair 5 $364 $0 $364 0%

Monthly Expense Trend — Internal Cost vs Billed