Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
114
Total Travel Cost
$6,205
9,260 miles
Avoidable Cost
$4,339
6,477 excess miles
Optimal Cost
$1,865
If closest tech always used
Avg Excess / WO
56.8 mi
$38.06 per WO
Median Excess
37.1 mi
Outlier Rate (>50mi)
45.6%
52 WOs

Actual Travel Expenses

From 85 WOs with expense data
Total Expenses
$37,675
Labor - Travel
$36,964
Mileage
$0
Lodging
$297
Airfare
$0
Car Rental
$0
Per Diem
$150
Meals
$0
Other
$264

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)
$37,675
85 WOs with expenses
Billed to Client
$5,627
14.9% recovery rate
Margin Gap (Unbilled)
$32,049
Cost absorbed internally
Avg Expense / WO
$443
Avg billed: $66
Internal Cost
$37,675
Billed
$5,627

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) 186 83 $36,964 $5,590 $31,375 15.1%
Lodging 2 1 $297 $0 $297 0%
Other Expenses 14 8 $264 $37 $227 14.1%
Per Diem 6 5 $150 $0 $150 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 87 $37,675 $5,627 $32,049 14.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 63 $27,785 $4,573 $23,213 16.5%
Cross-Training 2 $4,253 $0 $4,253 0%
Preventive Maintenance 10 $2,963 $0 $2,963 0%
Delivery 5 $1,373 $303 $1,071 22%
Evaluation 2 $744 $629 $115 84.5%
Misc. Inspection 1 $456 $123 $333 26.9%
Inspection 4 $100 $0 $100 0%

Monthly Expense Trend — Internal Cost vs Billed