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 | Paul Bonang Jr | 137 | 6,475 | $4,338 | 47.3 mi | 6.8 mi | 930 | $623 | 47.3 |
14% excess
|
| 2 | James Duff | 7 | 6,347 | $4,252 | 906.8 mi | 890.7 mi | 6,235 | $4,177 | 906.7 |
98% excess
|
| 3 | Luis Torres | 69 | 5,468 | $3,664 | 79.3 mi | 37.0 mi | 2,551 | $1,709 | 79.2 |
47% excess
|
| 4 | David Cavaco | 132 | 5,267 | $3,529 | 39.9 mi | 27.6 mi | 3,639 | $2,438 | 39.9 |
69% excess
|
| 5 | David Trost | 26 | 4,811 | $3,223 | 185.0 mi | 133.7 mi | 3,475 | $2,328 | 185 |
72% excess
|
| 6 | Yves Dessin | 4 | 4,521 | $3,029 | 1130.2 mi | 1125.7 mi | 4,503 | $3,017 | 1130.3 |
100% excess
|
| 7 | Nick O'Neill | 94 | 4,278 | $2,866 | 45.5 mi | 37.1 mi | 3,484 | $2,334 | 45.5 |
81% excess
|
| 8 | Jason Cunningham | 2 | 2,819 | $1,889 | 1409.4 mi | 1398.5 mi | 2,797 | $1,874 | 1409.5 |
99% excess
|
| 9 | Christopher Carroll | 2 | 2,514 | $1,684 | 1256.9 mi | 1152.3 mi | 2,305 | $1,544 | 1257 |
92% excess
|
| 10 | Joseph Anderson | 2 | 2,479 | $1,661 | 1239.7 mi | 1204.3 mi | 2,409 | $1,614 | 1239.5 |
97% excess
|
| 11 | Arturo Diaz | 1 | 1,594 | $1,068 | 1593.7 mi | 1586.3 mi | 1,586 | $1,063 | 1594 |
99% excess
|
| 12 | Mohamed Shareed | 5 | 877 | $588 | 175.4 mi | 165.6 mi | 828 | $555 | 175.4 |
94% excess
|
| 13 | Pete Ramos | 1 | 218 | $146 | 217.6 mi | 207.9 mi | 208 | $139 | 218 |
95% excess
|
| 14 | Minh Huynh | 1 | 52 | $35 | 51.9 mi | 43.6 mi | 44 | $29 | 52 |
85% excess
|
| 15 | Kaylee Tran | 2 | 14 | $9 | 7.2 mi | 2.0 mi | 4 | $3 | 7 |
29% excess
|