Quantify excess travel cost and identify optimization opportunities across your field service operation
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.
| # | Technician | WOs | Total Miles | Total Travel Cost | Avg Actual Dist | Avg Excess | Total Excess Miles | Avoidable Cost | Miles/WO Ratio | Travel Load |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Pete Ramos | 60 | 1,308 | $876 | 21.8 mi | 4.8 mi | 288 | $193 | 21.8 |
22% excess
|
| 2 | David Trost | 22 | 746 | $500 | 33.9 mi | 19.3 mi | 425 | $285 | 33.9 |
57% excess
|
| 3 | Edward Arias | 18 | 553 | $371 | 30.7 mi | 26.3 mi | 473 | $317 | 30.7 |
86% excess
|
| 4 | Chris Galasso | 27 | 455 | $305 | 16.9 mi | 0.0 mi | 0 | $0 | 16.9 |
0% excess
|
| 5 | Darrell Hope | 7 | 212 | $142 | 30.2 mi | 19.4 mi | 136 | $91 | 30.3 |
64% excess
|
| 6 | Mohamed Shareed | 7 | 201 | $135 | 28.7 mi | 23.3 mi | 163 | $109 | 28.7 |
81% excess
|
| 7 | Michael Harris | 3 | 197 | $132 | 65.7 mi | 30.6 mi | 92 | $62 | 65.7 |
47% excess
|
| 8 | Philip Krogstad | 3 | 190 | $127 | 63.5 mi | 56.2 mi | 168 | $113 | 63.3 |
88% excess
|
| 9 | Curtis Allen | 5 | 101 | $68 | 20.3 mi | 8.0 mi | 40 | $27 | 20.2 |
40% excess
|