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 | Christopher Carroll | 23 | 15,766 | $10,563 | 685.5 mi | 640.3 mi | 14,726 | $9,866 | 685.5 |
93% excess
|
| 2 | Mark Stelter | 19 | 15,151 | $10,151 | 797.4 mi | 745.7 mi | 14,169 | $9,493 | 797.4 |
94% excess
|
| 3 | Michael Swingle | 23 | 13,218 | $8,856 | 574.7 mi | 543.7 mi | 12,505 | $8,378 | 574.7 |
95% excess
|
| 4 | Joe Evans | 42 | 7,277 | $4,876 | 173.3 mi | 164.3 mi | 6,902 | $4,624 | 173.3 |
95% excess
|
| 5 | Rozier Cole | 21 | 5,112 | $3,425 | 243.4 mi | 199.5 mi | 4,190 | $2,807 | 243.4 |
82% excess
|
| 6 | Kevin Cogdill | 16 | 4,768 | $3,195 | 298.0 mi | 289.5 mi | 4,631 | $3,103 | 298 |
97% excess
|
| 7 | Xiraiyah Coston | 146 | 4,368 | $2,927 | 29.9 mi | 2.5 mi | 365 | $245 | 29.9 |
8% excess
|
| 8 | Side Kick Technician | 6 | 2,666 | $1,786 | 444.4 mi | 433.6 mi | 2,601 | $1,743 | 444.3 |
98% excess
|
| 9 | Yves Dessin | 3 | 1,611 | $1,079 | 537.1 mi | 513.7 mi | 1,541 | $1,032 | 537 |
96% excess
|
| 10 | David Hernandez | 2 | 1,213 | $813 | 606.6 mi | 601.6 mi | 1,203 | $806 | 606.5 |
99% excess
|
| 11 | Michael Harris | 10 | 423 | $283 | 42.3 mi | 0.0 mi | 0 | $0 | 42.3 |
0% excess
|
| 12 | Matthew Sebzda | 2 | 199 | $133 | 99.3 mi | 90.2 mi | 180 | $121 | 99.5 |
90% excess
|
| 13 | Carlos Robles | 7 | 63 | $42 | 9.0 mi | 6.8 mi | 48 | $32 | 9 |
76% excess
|
| 14 | Todd Fogiel | 1 | 52 | $35 | 51.7 mi | 0.0 mi | 0 | $0 | 52 |
0% excess
|
| 15 | Torre Gifford | 1 | 21 | $14 | 21.3 mi | 0.0 mi | 0 | $0 | 21 |
0% excess
|
| 16 | Kenneth Lancara | 1 | 11 | $7 | 10.7 mi | 0.0 mi | 0 | $0 | 11 |
0% excess
|
| 17 | Jon Sanchez | 1 | 7 | $5 | 6.7 mi | 0.0 mi | 0 | $0 | 7 |
0% excess
|
| 18 | James Duff | 2 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|