Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
15
Total Travel Cost
$5,607
8,369 miles
Avoidable Cost
$3,733
5,572 excess miles
Optimal Cost
$1,874
If closest tech always used
Avg Excess / WO
371.5 mi
$248.90 per WO
Median Excess
158.6 mi
Outlier Rate (>50mi)
80%
12 WOs

Actual Travel Expenses

From 10 WOs with expense data
Total Expenses
$5,455
Labor - Travel
$1,472
Mileage
$1,725
Lodging
$262
Airfare
$834
Car Rental
$504
Per Diem
$525
Meals
$0
Other
$134

Technician Travel Utilization

Top 30 techs by total miles driven. High total miles + high avg excess = overloaded tech being dispatched far. Low WO count + high miles = potential territory misalignment.

#TechnicianWOs Total MilesTotal Travel Cost Avg Actual DistAvg Excess Total Excess MilesAvoidable Cost Miles/WO Ratio Travel Load
1 Michah Brackett 3 3,959 $2,653 1319.8 mi 1060.7 mi 3,182 $2,132 1319.7
80% excess
2 Andrew Przybyla 1 1,459 $978 1458.9 mi 1151.7 mi 1,152 $772 1459
79% excess
3 Ronnie Salone 5 1,439 $964 287.7 mi 101.6 mi 508 $340 287.8
35% excess
4 Mike Huffman 3 845 $566 281.6 mi 158.5 mi 476 $319 281.7
56% excess
5 Dustin Antolin 1 414 $277 414.2 mi 132.8 mi 133 $89 414
32% excess
6 Jon Kuehl 2 254 $170 126.8 mi 61.2 mi 122 $82 127
48% excess