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 Womack | 68 | 3,144 | $2,106 | 46.2 mi | 13.2 mi | 901 | $604 | 46.2 |
29% excess
|
| 2 | Emmanuel Morales | 2 | 2,429 | $1,627 | 1214.5 mi | 1198.8 mi | 2,398 | $1,607 | 1214.5 |
99% excess
|
| 3 | Curtis Sprague | 11 | 1,308 | $876 | 118.9 mi | 39.1 mi | 430 | $288 | 118.9 |
33% excess
|
| 4 | Chane Lacy | 33 | 1,156 | $775 | 35.0 mi | 13.8 mi | 454 | $304 | 35 |
39% excess
|
| 5 | Nicole Floyd | 1 | 1,078 | $722 | 1077.9 mi | 1074.8 mi | 1,075 | $720 | 1078 |
100% excess
|
| 6 | Darrell Hendrix | 6 | 1,050 | $704 | 175.0 mi | 0.0 mi | 0 | $0 | 175 |
0% excess
|
| 7 | Anthony Wirth | 7 | 478 | $320 | 68.2 mi | 1.3 mi | 9 | $6 | 68.3 |
2% excess
|
| 8 | Zachary Stieben | 15 | 433 | $290 | 28.9 mi | 1.7 mi | 25 | $17 | 28.9 |
6% excess
|
| 9 | Saul Morales | 1 | 183 | $123 | 182.6 mi | 175.9 mi | 176 | $118 | 183 |
96% excess
|
| 10 | Robert Butler | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|