Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
19
Total Travel Cost
$17,414
25,991 miles
Avoidable Cost
$17,177
25,637 excess miles
Optimal Cost
$238
If closest tech always used
Avg Excess / WO
1,349.3 mi
$904.03 per WO
Median Excess
1,718.1 mi
Outlier Rate (>50mi)
94.7%
18 WOs

Actual Travel Expenses

From 7 WOs with expense data
Total Expenses
$7,686
Labor - Travel
$0
Mileage
$0
Lodging
$1,653
Airfare
$3,250
Car Rental
$953
Per Diem
$725
Meals
$0
Other
$1,105

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 Shawn Kelley 6 10,463 $7,010 1743.9 mi 1725.0 mi 10,350 $6,935 1743.8
99% excess
2 Minh Huynh 4 7,042 $4,718 1760.5 mi 1749.8 mi 6,999 $4,689 1760.5
99% excess
3 Curtis Sprague 7 6,694 $4,485 956.3 mi 934.0 mi 6,538 $4,380 956.3
98% excess
4 VPD Bench 1 1,766 $1,183 1765.8 mi 1749.3 mi 1,749 $1,172 1766
99% excess
5 Ben Heinz 1 26 $17 26.1 mi 0.0 mi 0 $0 26
0% excess