Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
40
Total Travel Cost
$1,761
2,629 miles
Avoidable Cost
$1,552
2,317 excess miles
Optimal Cost
$209
If closest tech always used
Avg Excess / WO
57.9 mi
$38.80 per WO
Median Excess
9.6 mi
Outlier Rate (>50mi)
15%
6 WOs

Actual Travel Expenses

From 19 WOs with expense data
Total Expenses
$7,744
Labor - Travel
$2,349
Mileage
$0
Lodging
$2,193
Airfare
$586
Car Rental
$1,846
Per Diem
$200
Meals
$0
Other
$569

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)
$7,744
19 WOs with expenses
Billed to Client
$1,191
15.4% recovery rate
Margin Gap (Unbilled)
$6,553
Cost absorbed internally
Avg Expense / WO
$408
Avg billed: $63
Internal Cost
$7,744
Billed
$1,191

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) 38 19 $2,349 $1,056 $1,294 44.9%
Lodging 3 3 $2,193 $0 $2,193 0%
Car Rental 5 4 $1,846 $0 $1,846 0%
Airfare 1 1 $586 $0 $586 0%
Other Expenses 13 10 $569 $136 $433 23.8%
Per Diem 5 4 $200 $0 $200 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 14 $6,043 $949 $5,094 15.7%
EMS 5 $1,701 $243 $1,458 14.3%
Kiosk 4 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Inspection 4 $3,798 $0 $3,798 0%
Repair 10 $1,918 $875 $1,043 45.6%
Cross-Training 1 $1,469 $0 $1,469 0%
Evaluation 3 $417 $174 $243 41.7%
Misc. Inspection 1 $143 $143 $0 100%
Preventive Maintenance 4 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed