Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
115
Total Travel Cost
$12,188
18,191 miles
Avoidable Cost
$10,613
15,840 excess miles
Optimal Cost
$1,575
If closest tech always used
Avg Excess / WO
137.7 mi
$92.29 per WO
Median Excess
31.4 mi
Outlier Rate (>50mi)
28.7%
33 WOs

Actual Travel Expenses

From 59 WOs with expense data
Total Expenses
$12,108
Labor - Travel
$10,695
Mileage
$0
Lodging
$0
Airfare
$0
Car Rental
$740
Per Diem
$275
Meals
$0
Other
$398

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)
$12,108
59 WOs with expenses
Billed to Client
$7,750
64% recovery rate
Margin Gap (Unbilled)
$4,358
Cost absorbed internally
Avg Expense / WO
$205
Avg billed: $131
Internal Cost
$12,108
Billed
$7,750

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) 111 87 $10,695 $7,750 $2,945 72.5%
Car Rental 3 2 $740 $0 $740 0%
Other Expenses 45 23 $398 $0 $398 0%
Per Diem 8 8 $275 $0 $275 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 94 $12,108 $7,750 $4,358 64%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 30 $8,599 $5,890 $2,709 68.5%
Preventive Maintenance 42 $2,435 $1,240 $1,195 50.9%
Repair 5 $930 $620 $310 66.7%
Installation 5 $119 $0 $119 0%
PM 12 $25 $0 $25 0%

Monthly Expense Trend — Internal Cost vs Billed