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 | Scott A Berry | 5 | 2,229 | $1,493 | 445.8 mi | 428.2 mi | 2,141 | $1,434 | 445.8 |
96% excess
|
| 2 | Christopher Carroll | 4 | 1,323 | $886 | 330.7 mi | 272.5 mi | 1,090 | $730 | 330.8 |
82% excess
|
| 3 | Christopher Morning | 16 | 918 | $615 | 57.4 mi | 37.7 mi | 603 | $404 | 57.4 |
66% excess
|
| 4 | Andrew Przybyla | 4 | 859 | $576 | 214.8 mi | 173.8 mi | 695 | $466 | 214.8 |
81% excess
|
| 5 | Arturo Diaz | 5 | 827 | $554 | 165.4 mi | 125.5 mi | 628 | $421 | 165.4 |
76% excess
|
| 6 | Eric Colon | 8 | 799 | $535 | 99.9 mi | 53.5 mi | 428 | $287 | 99.9 |
54% excess
|
| 7 | Anthony Wright | 9 | 677 | $454 | 75.2 mi | 32.5 mi | 292 | $196 | 75.2 |
43% excess
|
| 8 | Michael Harris | 11 | 663 | $444 | 60.3 mi | 43.1 mi | 474 | $318 | 60.3 |
71% excess
|
| 9 | Jordan Moceri | 5 | 661 | $443 | 132.1 mi | 115.7 mi | 578 | $387 | 132.2 |
87% excess
|
| 10 | Michah Brackett | 4 | 629 | $421 | 157.2 mi | 122.4 mi | 490 | $328 | 157.3 |
78% excess
|
| 11 | David Cavaco | 9 | 623 | $417 | 69.2 mi | 34.8 mi | 314 | $210 | 69.2 |
50% excess
|
| 12 | Yves Dessin | 5 | 527 | $353 | 105.5 mi | 78.9 mi | 395 | $265 | 105.4 |
75% excess
|
| 13 | Michael Swingle | 10 | 503 | $337 | 50.3 mi | 14.8 mi | 148 | $99 | 50.3 |
29% excess
|
| 14 | Jon Kuehl | 4 | 469 | $314 | 117.3 mi | 70.2 mi | 281 | $188 | 117.3 |
60% excess
|
| 15 | Mohamed Shareed | 8 | 444 | $297 | 55.4 mi | 42.4 mi | 339 | $227 | 55.5 |
76% excess
|
| 16 | Philip Krogstad | 7 | 427 | $286 | 61.1 mi | 36.2 mi | 253 | $170 | 61 |
59% excess
|
| 17 | Mike Huffman | 9 | 393 | $263 | 43.7 mi | 22.7 mi | 204 | $137 | 43.7 |
52% excess
|
| 18 | Zachary Stieben | 12 | 391 | $262 | 32.6 mi | 3.8 mi | 46 | $31 | 32.6 |
12% excess
|
| 19 | Luis Torres | 7 | 332 | $222 | 47.4 mi | 26.7 mi | 187 | $125 | 47.4 |
56% excess
|
| 20 | Angel Rios | 9 | 320 | $214 | 35.6 mi | 10.6 mi | 96 | $64 | 35.6 |
30% excess
|
| 21 | Anthony Wirth | 5 | 320 | $214 | 64 mi | 33.8 mi | 169 | $113 | 64 |
53% excess
|
| 22 | Dylan Ingraham | 5 | 318 | $213 | 63.7 mi | 14.7 mi | 74 | $50 | 63.6 |
23% excess
|
| 23 | Kwame Cobb | 7 | 304 | $204 | 43.5 mi | 19.3 mi | 135 | $90 | 43.4 |
44% excess
|
| 24 | Edward Arias | 6 | 284 | $190 | 47.3 mi | 30.5 mi | 183 | $123 | 47.3 |
64% excess
|
| 25 | Torre Gifford | 3 | 274 | $184 | 91.2 mi | 25.5 mi | 76 | $51 | 91.3 |
28% excess
|
| 26 | Dustin Antolin | 4 | 219 | $147 | 54.8 mi | 11.4 mi | 46 | $31 | 54.8 |
21% excess
|
| 27 | Cynthia G Deville | 1 | 211 | $141 | 211.3 mi | 132.4 mi | 132 | $88 | 211 |
63% excess
|
| 28 | Omar Serrano | 6 | 198 | $133 | 33 mi | 10.3 mi | 62 | $42 | 33 |
31% excess
|
| 29 | Nick O'Neill | 4 | 176 | $118 | 44 mi | 36.6 mi | 146 | $98 | 44 |
83% excess
|
| 30 | Chane Lacy | 4 | 153 | $103 | 38.2 mi | 22.9 mi | 91 | $61 | 38.3 |
59% excess
|