Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
320
Total Travel Cost
$35,882
53,555 miles
Avoidable Cost
$21,849
32,611 excess miles
Optimal Cost
$14,033
If closest tech always used
Avg Excess / WO
101.9 mi
$68.28 per WO
Median Excess
24.1 mi
Outlier Rate (>50mi)
18.8%
60 WOs

Actual Travel Expenses

From 179 WOs with expense data
Total Expenses
$48,387
Labor - Travel
$25,426
Mileage
$234
Lodging
$6,462
Airfare
$3,521
Car Rental
$1,086
Per Diem
$2,600
Meals
$0
Other
$9,058

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)
$48,387
179 WOs with expenses
Billed to Client
$13,935
28.8% recovery rate
Margin Gap (Unbilled)
$34,452
Cost absorbed internally
Avg Expense / WO
$270
Avg billed: $78
Internal Cost
$48,387
Billed
$13,935

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) 276 169 $25,426 $10,068 $15,358 39.6%
Other Expenses 178 124 $9,058 $324 $8,734 3.6%
Lodging 28 22 $6,462 $466 $5,996 7.2%
Airfare 5 5 $3,521 $2,200 $1,321 62.5%
Per Diem 62 36 $2,600 $375 $2,225 14.4%
Car Rental 11 9 $1,086 $502 $584 46.2%
Mileage 13 1 $234 $0 $234 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 71 $19,459 $7,285 $12,174 37.4%
Healthcare Provider 30 $13,459 $1,521 $11,939 11.3%
Kiosk 76 $7,472 $0 $7,472 0%
Lab/Power 4 $3,629 $3,629 $0 100%
EMS 23 $3,280 $1,261 $2,020 38.4%
Bed Services 15 $578 $0 $578 0%
Animal Health 1 $510 $240 $270 47.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 75 $15,019 $3,255 $11,764 21.7%
Repair 65 $13,361 $4,608 $8,752 34.5%
Inspection 18 $7,998 $595 $7,403 7.4%
FCO 42 $6,334 $1,860 $4,474 29.4%
Repair/PM 15 $4,355 $2,658 $1,697 61%
Overhaul 1 $959 $959 $0 100%
Connectivity 4 $360 $0 $360 0%

Monthly Expense Trend — Internal Cost vs Billed