Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
567
Total Travel Cost
$26,812
40,018 miles
Avoidable Cost
$14,353
21,422 excess miles
Optimal Cost
$12,459
If closest tech always used
Avg Excess / WO
37.8 mi
$25.31 per WO
Median Excess
4.8 mi
Outlier Rate (>50mi)
15.3%
87 WOs

Actual Travel Expenses

From 394 WOs with expense data
Total Expenses
$175,157
Labor - Travel
$129,420
Mileage
$1,280
Lodging
$15,039
Airfare
$6,788
Car Rental
$7,362
Per Diem
$5,300
Meals
$0
Other
$9,968

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)
$175,157
394 WOs with expenses
Billed to Client
$52,346
29.9% recovery rate
Margin Gap (Unbilled)
$122,810
Cost absorbed internally
Avg Expense / WO
$445
Avg billed: $133
Internal Cost
$175,157
Billed
$52,346

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) 887 407 $129,420 $25,406 $104,014 19.6%
Lodging 38 35 $15,039 $8,271 $6,768 55%
Other Expenses 235 152 $9,968 $4,931 $5,037 49.5%
Car Rental 75 32 $7,362 $4,516 $2,846 61.3%
Airfare 16 13 $6,788 $2,550 $4,238 37.6%
Per Diem 131 68 $5,300 $1,750 $3,550 33%
Mileage 38 16 $1,280 $4,923 $3,643 ✓ 384.7%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 289 $109,527 $18,138 $91,389 16.6%
Lab/Power 32 $32,838 $20,315 $12,522 61.9%
EMS 55 $15,599 $12,131 $3,467 77.8%
Animal Health 26 $11,534 $1,762 $9,772 15.3%
Training/Other 5 $4,394 $0 $4,394 0%
Kiosk 33 $1,242 $0 $1,242 0%
FCO 1 $24 $0 $24 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 272 $106,329 $22,678 $83,651 21.3%
Preventive Maintenance 80 $14,961 $11,891 $3,071 79.5%
IOQ 10 $14,891 $3,182 $11,710 21.4%
Repair/PM 11 $7,472 $7,145 $327 95.6%
Inspection 17 $7,043 $19 $7,024 0.3%
Installation 11 $6,055 $0 $6,055 0%
Cross-Training 6 $5,406 $0 $5,406 0%
Delivery 13 $5,347 $890 $4,457 16.6%
Overhaul 6 $4,440 $4,440 $0 100%
Evaluation 5 $2,177 $1,447 $729 66.5%
Misc. Inspection 3 $655 $655 $0 100%
Support 6 $286 $0 $286 0%
Connectivity 1 $94 $0 $94 0%

Monthly Expense Trend — Internal Cost vs Billed