Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
131
Total Travel Cost
$8,028
11,982 miles
Avoidable Cost
$2,786
4,159 excess miles
Optimal Cost
$5,241
If closest tech always used
Avg Excess / WO
31.7 mi
$21.27 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
14.5%
19 WOs

Actual Travel Expenses

From 81 WOs with expense data
Total Expenses
$25,432
Labor - Travel
$17,697
Mileage
$4,713
Lodging
$1,737
Airfare
$0
Car Rental
$181
Per Diem
$725
Meals
$0
Other
$380

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)
$25,432
81 WOs with expenses
Billed to Client
$22,861
89.9% recovery rate
Margin Gap (Unbilled)
$2,572
Cost absorbed internally
Avg Expense / WO
$314
Avg billed: $282
Internal Cost
$25,432
Billed
$22,861

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) 88 45 $17,697 $12,880 $4,817 72.8%
Mileage 102 36 $4,713 $9,593 $4,879 ✓ 203.5%
Lodging 8 8 $1,737 $275 $1,462 15.8%
Per Diem 17 8 $725 $0 $725 0%
Other Expenses 28 20 $380 $113 $267 29.8%
Car Rental 1 1 $181 $0 $181 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 88 $25,432 $22,861 $2,572 89.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 45 $17,436 $11,566 $5,870 66.3%
Preventive Maintenance 37 $5,947 $9,593 $3,645 161.3%
Evaluation 6 $2,049 $1,703 $347 83.1%

Monthly Expense Trend — Internal Cost vs Billed