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 | Mike Huffman | 40 | 12,453 | $8,344 | 311.3 mi | 248.2 mi | 9,930 | $6,653 | 311.3 |
80% excess
|
| 2 | Robert Rivera | 47 | 4,129 | $2,766 | 87.8 mi | 50.3 mi | 2,364 | $1,584 | 87.9 |
57% excess
|
| 3 | Ronnie Salone | 43 | 2,542 | $1,703 | 59.1 mi | 1.3 mi | 55 | $37 | 59.1 |
2% excess
|
| 4 | Praelow Cameron | 6 | 911 | $610 | 151.9 mi | 69.6 mi | 418 | $280 | 151.8 |
46% excess
|
| 5 | Vincent Nyathi | 10 | 836 | $560 | 83.6 mi | 26.3 mi | 263 | $176 | 83.6 |
31% excess
|
| 6 | Jason Cunningham | 11 | 646 | $433 | 58.7 mi | 0.0 mi | 0 | $0 | 58.7 |
0% excess
|
| 7 | Cynthia G Deville | 29 | 632 | $423 | 21.8 mi | 2.5 mi | 72 | $48 | 21.8 |
11% excess
|
| 8 | Michael Swingle | 5 | 487 | $326 | 97.4 mi | 10.2 mi | 51 | $34 | 97.4 |
10% excess
|
| 9 | Robert Lewis | 8 | 423 | $283 | 52.9 mi | 0.0 mi | 0 | $0 | 52.9 |
0% excess
|
| 10 | Joseph Anderson | 8 | 350 | $235 | 43.8 mi | 0.0 mi | 0 | $0 | 43.8 |
0% excess
|
| 11 | Craig Walker | 10 | 252 | $169 | 25.2 mi | 0.0 mi | 0 | $0 | 25.2 |
0% excess
|
| 12 | Omar Serrano | 1 | 222 | $149 | 222.0 mi | 210.3 mi | 210 | $141 | 222 |
95% excess
|
| 13 | Maximilian Tucker | 3 | 187 | $125 | 62.4 mi | 28.8 mi | 86 | $58 | 62.3 |
46% excess
|
| 14 | Philip Krogstad | 5 | 178 | $119 | 35.6 mi | 16.2 mi | 81 | $54 | 35.6 |
46% excess
|
| 15 | Jordan Moceri | 3 | 134 | $90 | 44.8 mi | 0.0 mi | 0 | $0 | 44.7 |
0% excess
|
| 16 | Rozier Cole | 1 | 89 | $60 | 89.1 mi | 84.5 mi | 85 | $57 | 89 |
96% excess
|
| 17 | Pete Ramos | 1 | 80 | $54 | 79.7 mi | 38.3 mi | 38 | $25 | 80 |
48% excess
|
| 18 | Brandon Green | 2 | 62 | $42 | 30.9 mi | 0.0 mi | 0 | $0 | 31 |
0% excess
|
| 19 | Christopher Carroll | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|