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 | Joe Evans | 42 | 7,277 | $4,876 | 173.3 mi | 164.3 mi | 6,902 | $4,624 | 173.3 |
95% excess
|
| 2 | Kevin Cogdill | 16 | 4,768 | $3,195 | 298.0 mi | 289.5 mi | 4,631 | $3,103 | 298 |
97% excess
|
| 3 | Praelow Cameron | 40 | 4,419 | $2,961 | 110.5 mi | 33.7 mi | 1,349 | $904 | 110.5 |
31% excess
|
| 4 | Eric Colon | 50 | 3,281 | $2,198 | 65.6 mi | 24.4 mi | 1,218 | $816 | 65.6 |
37% excess
|
| 5 | Ronnie Salone | 2 | 1,793 | $1,201 | 896.3 mi | 0.0 mi | 0 | $0 | 896.5 |
0% excess
|
| 6 | Christopher Morning | 7 | 1,120 | $750 | 160.0 mi | 153.5 mi | 1,074 | $720 | 160 |
96% excess
|
| 7 | Rozier Cole | 20 | 921 | $617 | 46.0 mi | 11.0 mi | 220 | $147 | 46.1 |
24% excess
|
| 8 | Xiraiyah Coston | 1 | 377 | $253 | 377.2 mi | 364.9 mi | 365 | $245 | 377 |
97% excess
|
| 9 | Yves Dessin | 1 | 351 | $235 | 351.5 mi | 347.2 mi | 347 | $232 | 351 |
99% excess
|
| 10 | Todd Fogiel | 2 | 325 | $218 | 162.5 mi | 162.5 mi | 325 | $218 | 162.5 |
100% excess
|
| 11 | Matthew Sebzda | 4 | 237 | $159 | 59.2 mi | 49.4 mi | 198 | $133 | 59.3 |
84% excess
|