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 | Andrew Przybyla | 85 | 21,345 | $14,301 | 251.1 mi | 218.1 mi | 18,537 | $12,420 | 251.1 |
87% excess
|
| 2 | Zachary Stieben | 140 | 8,129 | $5,446 | 58.1 mi | 22.8 mi | 3,189 | $2,137 | 58.1 |
39% excess
|
| 3 | Arturo Diaz | 87 | 8,013 | $5,369 | 92.1 mi | 61.6 mi | 5,357 | $3,589 | 92.1 |
67% excess
|
| 4 | Chane Lacy | 96 | 7,579 | $5,078 | 78.9 mi | 48.7 mi | 4,671 | $3,130 | 78.9 |
62% excess
|
| 5 | Anthony Wirth | 100 | 7,183 | $4,813 | 71.8 mi | 45.0 mi | 4,500 | $3,015 | 71.8 |
63% excess
|
| 6 | Darrell Hendrix | 39 | 4,930 | $3,303 | 126.4 mi | 60.2 mi | 2,347 | $1,572 | 126.4 |
48% excess
|
| 7 | Jason Morris | 5 | 4,857 | $3,254 | 971.5 mi | 924.9 mi | 4,625 | $3,099 | 971.4 |
95% excess
|
| 8 | Tyler Bollman | 80 | 4,572 | $3,063 | 57.1 mi | 27.7 mi | 2,216 | $1,485 | 57.2 |
48% excess
|
| 9 | Thomas J Langenberg Jr | 79 | 4,565 | $3,059 | 57.8 mi | 13.2 mi | 1,042 | $698 | 57.8 |
23% excess
|
| 10 | Blake Ward | 58 | 4,410 | $2,955 | 76.0 mi | 40.9 mi | 2,374 | $1,591 | 76 |
54% excess
|
| 11 | Christopher Womack | 64 | 3,826 | $2,563 | 59.8 mi | 19.9 mi | 1,274 | $854 | 59.8 |
33% excess
|
| 12 | Curtis Sprague | 22 | 2,708 | $1,814 | 123.1 mi | 90.7 mi | 1,996 | $1,337 | 123.1 |
74% excess
|
| 13 | Michah Brackett | 4 | 2,375 | $1,591 | 593.8 mi | 554.7 mi | 2,219 | $1,487 | 593.8 |
93% excess
|
| 14 | Brandon Rodriguez | 5 | 1,777 | $1,191 | 355.5 mi | 355.5 mi | 1,777 | $1,191 | 355.4 |
100% excess
|
| 15 | Kevin Cox | 29 | 1,112 | $745 | 38.4 mi | 12.0 mi | 349 | $234 | 38.3 |
31% excess
|
| 16 | Jason Cunningham | 1 | 278 | $186 | 277.5 mi | 267.2 mi | 267 | $179 | 278 |
96% excess
|
| 17 | Franco Jackson | 1 | 267 | $179 | 267.4 mi | 105.2 mi | 105 | $70 | 267 |
39% excess
|
| 18 | Ronnie Salone | 1 | 94 | $63 | 94.0 mi | 0.0 mi | 0 | $0 | 94 |
0% excess
|