Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
282
Total Travel Cost
$27,487
41,025 miles
Avoidable Cost
$19,387
28,935 excess miles
Optimal Cost
$8,100
If closest tech always used
Avg Excess / WO
102.6 mi
$68.75 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
39.4%
111 WOs

Actual Travel Expenses

From 42 WOs with expense data
Total Expenses
$14,019
Labor - Travel
$8,398
Mileage
$943
Lodging
$1,819
Airfare
$785
Car Rental
$0
Per Diem
$800
Meals
$0
Other
$1,273

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)
$14,019
42 WOs with expenses
Billed to Client
$6,007
42.9% recovery rate
Margin Gap (Unbilled)
$8,012
Cost absorbed internally
Avg Expense / WO
$334
Avg billed: $143
Internal Cost
$14,019
Billed
$6,007

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) 142 96 $8,398 $5,386 $3,012 64.1%
Lodging 9 9 $1,819 $437 $1,382 24%
Other Expenses 53 28 $1,273 $184 $1,089 14.5%
Mileage 8 4 $943 $0 $943 0%
Per Diem 21 16 $800 $0 $800 0%
Airfare 1 1 $785 $0 $785 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 18 $7,622 $3,214 $4,409 42.2%
Healthcare Provider 10 $3,686 $2,793 $893 75.8%
Bed Services 47 $1,879 $0 $1,879 0%
Kiosk 30 $832 $0 $832 0%
Training/Other 2 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 19 $7,445 $4,031 $3,414 54.1%
Preventive Maintenance 76 $3,440 $0 $3,440 0%
Delivery 1 $1,310 $1,305 $5 99.6%
Installation 3 $1,032 $314 $718 30.5%
Misc. Inspection 2 $397 $357 $40 89.9%
Inspection 2 $208 $0 $208 0%
Repair/PM 2 $186 $0 $186 0%
Cross-Training 1 $0 $0 $0 0%
New Hire Training 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed