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 | Fernando Lemos | 17 | 31,326 | $20,988 | 1842.7 mi | 1836.7 mi | 31,224 | $20,920 | 1842.7 |
100% excess
|
| 2 | Side Kick Technician | 27 | 10,652 | $7,137 | 394.5 mi | 387.1 mi | 10,452 | $7,003 | 394.5 |
98% excess
|
| 3 | Christopher Carroll | 16 | 10,495 | $7,032 | 656 mi | 598.3 mi | 9,573 | $6,414 | 655.9 |
91% excess
|
| 4 | Rozier Cole | 14 | 4,266 | $2,858 | 304.7 mi | 262.5 mi | 3,675 | $2,462 | 304.7 |
86% excess
|
| 5 | Todd Fogiel | 11 | 2,067 | $1,385 | 187.9 mi | 71.7 mi | 788 | $528 | 187.9 |
38% excess
|
| 6 | Yves Dessin | 3 | 2,017 | $1,351 | 672.2 mi | 663.5 mi | 1,990 | $1,333 | 672.3 |
99% excess
|
| 7 | Allan Klus | 15 | 1,114 | $746 | 74.3 mi | 52.4 mi | 785 | $526 | 74.3 |
70% excess
|
| 8 | Kenneth Lancara | 2 | 1,091 | $731 | 545.3 mi | 539.3 mi | 1,079 | $723 | 545.5 |
99% excess
|
| 9 | Carlos Robles | 71 | 635 | $425 | 8.9 mi | 6.7 mi | 476 | $319 | 8.9 |
75% excess
|
| 10 | Patricia Gordon | 5 | 592 | $397 | 118.4 mi | 11.8 mi | 59 | $40 | 118.4 |
10% excess
|
| 11 | Praelow Cameron | 3 | 529 | $354 | 176.5 mi | 85.1 mi | 255 | $171 | 176.3 |
48% excess
|
| 12 | Jon Sanchez | 44 | 513 | $344 | 11.7 mi | 0 mi | 2 | $1 | 11.7 |
0% excess
|
| 13 | David Hernandez | 35 | 496 | $332 | 14.2 mi | 0 mi | 0 | $0 | 14.2 |
0% excess
|
| 14 | Fady Messak | 2 | 450 | $302 | 225.2 mi | 189.5 mi | 379 | $254 | 225 |
84% excess
|
| 15 | Xiraiyah Coston | 16 | 402 | $269 | 25.1 mi | 0 mi | 0 | $0 | 25.1 |
0% excess
|
| 16 | Christopher Morning | 3 | 383 | $257 | 127.6 mi | 119 mi | 357 | $239 | 127.7 |
93% excess
|
| 17 | Michael Harris | 2 | 345 | $231 | 172.3 mi | 164.2 mi | 328 | $220 | 172.5 |
95% excess
|
| 18 | Joe Hudson | 2 | 184 | $123 | 91.9 mi | 73.3 mi | 147 | $98 | 92 |
80% excess
|
| 19 | Solomon Young | 6 | 135 | $90 | 22.5 mi | 7.1 mi | 43 | $29 | 22.5 |
32% excess
|