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 | Phillip Castillo | 2 | 3,438 | $2,303 | 1718.8 mi | 1694.9 mi | 3,390 | $2,271 | 1719 |
99% excess
|
| 2 | Andrew Przybyla | 2 | 2,838 | $1,901 | 1419 mi | 1384.3 mi | 2,769 | $1,855 | 1419 |
98% excess
|
| 3 | Praelow Cameron | 28 | 2,313 | $1,550 | 82.6 mi | 26.5 mi | 741 | $496 | 82.6 |
32% excess
|
| 4 | Vincent Nyathi | 26 | 1,484 | $994 | 57.1 mi | 13.7 mi | 356 | $239 | 57.1 |
24% excess
|
| 5 | Maximilian Tucker | 23 | 1,369 | $917 | 59.5 mi | 25.1 mi | 578 | $387 | 59.5 |
42% excess
|
| 6 | Jason Cunningham | 10 | 1,075 | $720 | 107.5 mi | 18.3 mi | 183 | $123 | 107.5 |
17% excess
|
| 7 | Mike Huffman | 21 | 844 | $565 | 40.2 mi | 0 mi | 0 | $0 | 40.2 |
0% excess
|
| 8 | Robert Rivera | 24 | 542 | $363 | 22.6 mi | 0 mi | 0 | $0 | 22.6 |
0% excess
|
| 9 | Jordan Moceri | 6 | 508 | $340 | 84.6 mi | 68.6 mi | 412 | $276 | 84.7 |
81% excess
|
| 10 | Cynthia G Deville | 5 | 489 | $328 | 97.8 mi | 53.9 mi | 269 | $180 | 97.8 |
55% excess
|
| 11 | Ronnie Salone | 19 | 373 | $250 | 19.6 mi | 0 mi | 0 | $0 | 19.6 |
0% excess
|
| 12 | Christopher Womack | 9 | 299 | $200 | 33.3 mi | 16.2 mi | 146 | $98 | 33.2 |
49% excess
|
| 13 | Joseph Anderson | 5 | 263 | $176 | 52.5 mi | 9 mi | 45 | $30 | 52.6 |
17% excess
|
| 14 | Michael Russell | 2 | 231 | $155 | 115.5 mi | 115.5 mi | 231 | $155 | 115.5 |
100% excess
|
| 15 | Jon Kuehl | 1 | 210 | $141 | 210.2 mi | 126.7 mi | 127 | $85 | 210 |
60% excess
|
| 16 | Torre Gifford | 7 | 204 | $137 | 29.1 mi | 1 mi | 7 | $5 | 29.1 |
3% excess
|
| 17 | Craig Walker | 5 | 156 | $105 | 31.1 mi | 0 mi | 0 | $0 | 31.2 |
0% excess
|
| 18 | Michael Swingle | 4 | 152 | $102 | 37.9 mi | 0 mi | 0 | $0 | 38 |
0% excess
|
| 19 | Omar Serrano | 5 | 150 | $101 | 30 mi | 3.8 mi | 19 | $13 | 30 |
13% excess
|
| 20 | Franco Jackson | 2 | 144 | $96 | 71.8 mi | 42.7 mi | 85 | $57 | 72 |
59% excess
|
| 21 | Kevin Cox | 1 | 138 | $92 | 138 mi | 0 mi | 0 | $0 | 138 |
0% excess
|
| 22 | Brandon Green | 2 | 133 | $89 | 66.4 mi | 36.9 mi | 74 | $50 | 66.5 |
56% excess
|
| 23 | Luis Torres | 8 | 108 | $72 | 13.5 mi | 0 mi | 0 | $0 | 13.5 |
0% excess
|
| 24 | Justin Armas | 1 | 94 | $63 | 94.3 mi | 9.8 mi | 10 | $7 | 94 |
11% excess
|
| 25 | Philip Krogstad | 3 | 90 | $60 | 29.9 mi | 0 mi | 0 | $0 | 30 |
0% excess
|
| 26 | Anthony Wirth | 1 | 83 | $56 | 83.4 mi | 0 mi | 0 | $0 | 83 |
0% excess
|
| 27 | Christopher Carroll | 2 | 26 | $17 | 13 mi | 0 mi | 0 | $0 | 13 |
0% excess
|
| 28 | Curtis Allen | 1 | 13 | $9 | 13 mi | 0 mi | 0 | $0 | 13 |
0% excess
|
| 29 | David Trost | 1 | 13 | $9 | 12.9 mi | 0.1 mi | 0 | $0 | 13 |
0% excess
|
| 30 | Dustin Antolin | 2 | 8 | $5 | 4.1 mi | 0 mi | 0 | $0 | 4 |
0% excess
|