Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
2,293
Total Travel Cost
$114,493
170,885 miles
Avoidable Cost
$74,174
110,707 excess miles
Optimal Cost
$40,336
If closest tech always used
Avg Excess / WO
48.3 mi
$32.34 per WO
Median Excess
8.6 mi
Outlier Rate (>50mi)
17.4%
400 WOs

Actual Travel Expenses

From 1,364 WOs with expense data
Total Expenses
$333,164
Labor - Travel
$251,802
Mileage
$13,545
Lodging
$23,255
Airfare
$6,972
Car Rental
$9,529
Per Diem
$7,050
Meals
$0
Other
$21,010

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)
$333,164
1,364 WOs with expenses
Billed to Client
$110,124
33.1% recovery rate
Margin Gap (Unbilled)
$223,039
Cost absorbed internally
Avg Expense / WO
$244
Avg billed: $81
Internal Cost
$333,164
Billed
$110,124

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) 2,281 1,371 $251,802 $84,008 $167,794 33.4%
Lodging 46 44 $23,255 $973 $22,282 4.2%
Other Expenses 937 689 $21,010 $3,545 $17,465 16.9%
Mileage 353 152 $13,545 $21,598 $8,053 ✓ 159.5%
Car Rental 61 37 $9,529 $0 $9,529 0%
Per Diem 153 72 $7,050 $0 $7,050 0%
Airfare 12 11 $6,972 $0 $6,972 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 866 $261,778 $62,235 $199,543 23.8%
EMS 388 $49,602 $45,177 $4,425 91.1%
Kiosk 327 $8,104 $193 $7,911 2.4%
Animal Health 17 $5,864 $2,017 $3,847 34.4%
Bed Services 67 $3,832 $0 $3,832 0%
Training/Other 5 $2,894 $0 $2,894 0%
Lab/Power 17 $770 $503 $268 65.3%
Project 3 $319 $0 $319 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 782 $186,712 $44,987 $141,725 24.1%
Inspection 148 $43,155 $4,344 $38,811 10.1%
Preventive Maintenance 453 $23,858 $24,712 $854 103.6%
Misc. Inspection 111 $23,840 $20,726 $3,114 86.9%
Cross-Training 17 $16,500 $0 $16,500 0%
Evaluation 73 $13,912 $8,551 $5,361 61.5%
Delivery 24 $9,246 $3,602 $5,644 39%
Repair/PM 40 $3,155 $0 $3,155 0%
Installation 11 $3,072 $2,236 $836 72.8%
COMPLAINT 1 $2,597 $0 $2,597 0%
Training 1 $2,565 $0 $2,565 0%
Calibration 14 $2,296 $841 $1,455 36.6%
Asset Tagging 3 $817 $0 $817 0%
New Hire Training 1 $651 $0 $651 0%
Connectivity 6 $246 $0 $246 0%
Warranty 1 $232 $0 $232 0%
Upgrade 2 $194 $0 $194 0%
Removal 2 $114 $125 $11 110%

Monthly Expense Trend — Internal Cost vs Billed