Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
105
Total Travel Cost
$6,734
10,050 miles
Avoidable Cost
$2,091
3,122 excess miles
Optimal Cost
$4,642
If closest tech always used
Avg Excess / WO
29.7 mi
$19.92 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
25.7%
27 WOs

Actual Travel Expenses

From 48 WOs with expense data
Total Expenses
$16,074
Labor - Travel
$8,099
Mileage
$5,034
Lodging
$2,534
Airfare
$0
Car Rental
$0
Per Diem
$75
Meals
$0
Other
$332

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)
$16,074
48 WOs with expenses
Billed to Client
$4,694
29.2% recovery rate
Margin Gap (Unbilled)
$11,380
Cost absorbed internally
Avg Expense / WO
$335
Avg billed: $98
Internal Cost
$16,074
Billed
$4,694

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) 74 42 $8,099 $3,320 $4,779 41%
Mileage 88 20 $5,034 $1,325 $3,709 26.3%
Lodging 8 7 $2,534 $0 $2,534 0%
Other Expenses 25 22 $332 $49 $284 14.7%
Per Diem 2 2 $75 $0 $75 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 44 $9,916 $3,045 $6,871 30.7%
Healthcare Provider 15 $6,124 $1,649 $4,475 26.9%
Kiosk 6 $33 $0 $33 0%
Training/Other 1 $0 $0 $0 0%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 26 $7,560 $1,423 $6,138 18.8%
Repair 28 $6,478 $1,456 $5,022 22.5%
Misc. Inspection 2 $893 $893 $0 100%
Inspection 4 $785 $565 $220 72%
Evaluation 5 $358 $358 $0 100%
Cross-Training 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed