Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
116
Total Travel Cost
$6,454
9,632 miles
Avoidable Cost
$2,935
4,380 excess miles
Optimal Cost
$3,519
If closest tech always used
Avg Excess / WO
37.8 mi
$25.30 per WO
Median Excess
16.7 mi
Outlier Rate (>50mi)
19%
22 WOs

Actual Travel Expenses

From 62 WOs with expense data
Total Expenses
$30,996
Labor - Travel
$23,072
Mileage
$322
Lodging
$3,766
Airfare
$1,101
Car Rental
$799
Per Diem
$1,275
Meals
$0
Other
$659

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)
$30,996
62 WOs with expenses
Billed to Client
$14,598
47.1% recovery rate
Margin Gap (Unbilled)
$16,397
Cost absorbed internally
Avg Expense / WO
$500
Avg billed: $235
Internal Cost
$30,996
Billed
$14,598

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) 158 77 $23,072 $12,445 $10,628 53.9%
Lodging 11 11 $3,766 $932 $2,834 24.8%
Per Diem 30 16 $1,275 $0 $1,275 0%
Airfare 2 2 $1,101 $0 $1,101 0%
Car Rental 7 2 $799 $0 $799 0%
Other Expenses 30 18 $659 $116 $543 17.6%
Mileage 2 1 $322 $1,105 $783 ✓ 342.9%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 53 $22,763 $10,815 $11,948 47.5%
EMS 6 $6,130 $3,367 $2,763 54.9%
Bed Services 1 $1,272 $0 $1,272 0%
Animal Health 1 $417 $417 $0 100%
Kiosk 23 $414 $0 $414 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 33 $12,790 $5,346 $7,444 41.8%
Delivery 8 $8,210 $6,355 $1,855 77.4%
Cross-Training 2 $3,519 $0 $3,519 0%
Misc. Inspection 5 $2,304 $1,191 $1,113 51.7%
Inspection 6 $1,834 $0 $1,834 0%
Preventive Maintenance 26 $1,300 $1,105 $195 85%
Evaluation 3 $679 $410 $269 60.4%
Calibration 1 $359 $191 $168 53.2%

Monthly Expense Trend — Internal Cost vs Billed