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 | Jason Morris | 10 | 10,011 | $6,707 | 1001.1 mi | 950.2 mi | 9,502 | $6,366 | 1001.1 |
95% excess
|
| 2 | Andrew Przybyla | 10 | 7,971 | $5,341 | 797.1 mi | 764.1 mi | 7,641 | $5,119 | 797.1 |
96% excess
|
| 3 | Kevin Cox | 33 | 3,398 | $2,277 | 103.0 mi | 7.2 mi | 238 | $159 | 103 |
7% excess
|
| 4 | Darrell Hendrix | 48 | 3,116 | $2,088 | 64.9 mi | 0.3 mi | 15 | $10 | 64.9 |
0% excess
|
| 5 | Christopher Womack | 67 | 3,109 | $2,083 | 46.4 mi | 13.4 mi | 897 | $601 | 46.4 |
29% excess
|
| 6 | Curtis Sprague | 11 | 1,308 | $876 | 118.9 mi | 39.1 mi | 430 | $288 | 118.9 |
33% excess
|
| 7 | Blake Ward | 14 | 1,177 | $789 | 84.1 mi | 18.0 mi | 251 | $168 | 84.1 |
21% excess
|
| 8 | Chane Lacy | 33 | 1,156 | $775 | 35.0 mi | 13.8 mi | 454 | $304 | 35 |
39% excess
|
| 9 | Thomas J Langenberg Jr | 14 | 871 | $584 | 62.2 mi | 10.9 mi | 153 | $103 | 62.2 |
18% excess
|
| 10 | Anthony Wirth | 7 | 478 | $320 | 68.2 mi | 1.3 mi | 9 | $6 | 68.3 |
2% excess
|
| 11 | Zachary Stieben | 15 | 433 | $290 | 28.9 mi | 1.7 mi | 25 | $17 | 28.9 |
6% excess
|
| 12 | Ben Heinz | 9 | 394 | $264 | 43.8 mi | 0.0 mi | 0 | $0 | 43.8 |
0% excess
|
| 13 | Robert Lewis | 3 | 235 | $157 | 78.4 mi | 0.0 mi | 0 | $0 | 78.3 |
0% excess
|
| 14 | Saul Morales | 1 | 183 | $123 | 182.6 mi | 175.9 mi | 176 | $118 | 183 |
96% excess
|
| 15 | Jon Kuehl | 1 | 135 | $90 | 134.8 mi | 125.6 mi | 126 | $84 | 135 |
93% excess
|
| 16 | Vincent Nyathi | 2 | 100 | $67 | 50.1 mi | 0.0 mi | 0 | $0 | 50 |
0% excess
|
| 17 | Ronnie Salone | 1 | 65 | $44 | 65.2 mi | 0.0 mi | 0 | $0 | 65 |
0% excess
|
| 18 | Tyler Bollman | 6 | 62 | $42 | 10.3 mi | 0.0 mi | 0 | $0 | 10.3 |
0% excess
|