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 | 13 | 3,945 | $2,643 | 303.4 mi | 267.2 mi | 3,474 | $2,328 | 303.5 |
88% excess
|
| 5 | Yves Dessin | 3 | 2,017 | $1,351 | 672.2 mi | 663.5 mi | 1,990 | $1,333 | 672.3 |
99% excess
|
| 6 | Kenneth Lancara | 2 | 1,091 | $731 | 545.3 mi | 539.3 mi | 1,079 | $723 | 545.5 |
99% excess
|
| 7 | Carlos Robles | 71 | 635 | $425 | 8.9 mi | 6.7 mi | 476 | $319 | 8.9 |
75% excess
|
| 8 | Jon Sanchez | 44 | 513 | $344 | 11.7 mi | 0 mi | 2 | $1 | 11.7 |
0% excess
|
| 9 | David Hernandez | 35 | 496 | $332 | 14.2 mi | 0 mi | 0 | $0 | 14.2 |
0% excess
|
| 10 | Xiraiyah Coston | 16 | 402 | $269 | 25.1 mi | 0 mi | 0 | $0 | 25.1 |
0% excess
|