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 | Praelow Cameron | 271 | 60,354 | $40,437 | 222.7 mi | 166.1 mi | 45,016 | $30,161 | 222.7 |
75% excess
|
| 2 | Christopher Carroll | 59 | 20,051 | $13,434 | 339.9 mi | 298.0 mi | 17,580 | $11,779 | 339.8 |
88% excess
|
| 3 | Rozier Cole | 94 | 19,221 | $12,878 | 204.5 mi | 123.9 mi | 11,646 | $7,803 | 204.5 |
61% excess
|
| 4 | Michael Swingle | 100 | 18,774 | $12,579 | 187.7 mi | 150.2 mi | 15,021 | $10,064 | 187.7 |
80% excess
|
| 5 | Todd Fogiel | 155 | 15,846 | $10,617 | 102.2 mi | 28.7 mi | 4,447 | $2,979 | 102.2 |
28% excess
|
| 6 | Mark Stelter | 19 | 15,151 | $10,151 | 797.4 mi | 745.7 mi | 14,169 | $9,493 | 797.4 |
94% excess
|
| 7 | Christopher Morning | 148 | 11,398 | $7,637 | 77.0 mi | 47.7 mi | 7,066 | $4,734 | 77 |
62% excess
|
| 8 | Eric Colon | 103 | 8,729 | $5,848 | 84.7 mi | 41.2 mi | 4,247 | $2,845 | 84.7 |
49% excess
|
| 9 | Joe Evans | 42 | 7,277 | $4,876 | 173.3 mi | 164.3 mi | 6,902 | $4,624 | 173.3 |
95% excess
|
| 10 | Philip Krogstad | 176 | 7,105 | $4,760 | 40.4 mi | 21.4 mi | 3,774 | $2,529 | 40.4 |
53% excess
|
| 11 | Michael Harris | 113 | 6,804 | $4,559 | 60.2 mi | 25.0 mi | 2,820 | $1,889 | 60.2 |
41% excess
|
| 12 | Chris Galasso | 174 | 6,771 | $4,537 | 38.9 mi | 7.3 mi | 1,265 | $848 | 38.9 |
19% excess
|
| 13 | Kevin Cogdill | 16 | 4,768 | $3,195 | 298.0 mi | 289.5 mi | 4,631 | $3,103 | 298 |
97% excess
|
| 14 | Ronnie Salone | 5 | 4,487 | $3,006 | 897.3 mi | 0.0 mi | 0 | $0 | 897.4 |
0% excess
|
| 15 | Xiraiyah Coston | 147 | 4,368 | $2,927 | 29.7 mi | 2.5 mi | 365 | $245 | 29.7 |
8% excess
|
| 16 | Maximilian Tucker | 72 | 3,616 | $2,423 | 50.2 mi | 19.9 mi | 1,435 | $961 | 50.2 |
40% excess
|
| 17 | James Duff | 36 | 2,924 | $1,959 | 81.2 mi | 46.9 mi | 1,687 | $1,130 | 81.2 |
58% excess
|
| 18 | Side Kick Technician | 6 | 2,666 | $1,786 | 444.4 mi | 433.6 mi | 2,601 | $1,743 | 444.3 |
98% excess
|
| 19 | Pero Popovic | 46 | 2,410 | $1,615 | 52.4 mi | 38.6 mi | 1,775 | $1,189 | 52.4 |
74% excess
|
| 20 | Yves Dessin | 3 | 1,611 | $1,079 | 537.1 mi | 513.7 mi | 1,541 | $1,032 | 537 |
96% excess
|
| 21 | Brandon Green | 31 | 1,368 | $917 | 44.1 mi | 2.8 mi | 87 | $58 | 44.1 |
6% excess
|
| 22 | David Hernandez | 3 | 1,213 | $813 | 404.4 mi | 401.1 mi | 1,203 | $806 | 404.3 |
99% excess
|
| 23 | Pete Ramos | 4 | 934 | $626 | 233.6 mi | 112.8 mi | 451 | $302 | 233.5 |
48% excess
|
| 24 | Dustin Antolin | 5 | 472 | $316 | 94.4 mi | 26.7 mi | 133 | $89 | 94.4 |
28% excess
|
| 25 | Angel Rios | 1 | 393 | $263 | 393.0 mi | 373.7 mi | 374 | $251 | 393 |
95% excess
|
| 26 | Darrell Hope | 4 | 360 | $241 | 89.9 mi | 54.9 mi | 220 | $147 | 90 |
61% excess
|
| 27 | Curtis Allen | 8 | 343 | $230 | 42.8 mi | 7.3 mi | 58 | $39 | 42.9 |
17% excess
|
| 28 | Christopher Womack | 1 | 327 | $219 | 327.2 mi | 260.5 mi | 260 | $174 | 327 |
80% excess
|
| 29 | Matthew Sebzda | 4 | 237 | $159 | 59.2 mi | 49.4 mi | 198 | $133 | 59.3 |
84% excess
|
| 30 | David Trost | 1 | 161 | $108 | 161.5 mi | 57.4 mi | 57 | $38 | 161 |
35% excess
|