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 | Darrell Hendrix | 107 | 5,508 | $3,690 | 51.5 mi | 1.1 mi | 121 | $81 | 51.5 |
2% excess
|
| 2 | Maria Davis | 17 | 3,748 | $2,511 | 220.5 mi | 203.6 mi | 3,462 | $2,320 | 220.5 |
92% excess
|
| 3 | Israel Martell | 2 | 2,692 | $1,804 | 1345.9 mi | 1291.6 mi | 2,583 | $1,731 | 1346 |
96% excess
|
| 4 | Fady Messak | 2 | 2,491 | $1,669 | 1245.6 mi | 1185.4 mi | 2,371 | $1,589 | 1245.5 |
95% excess
|
| 5 | Zachary Stieben | 10 | 1,983 | $1,329 | 198.3 mi | 136.7 mi | 1,367 | $916 | 198.3 |
69% excess
|
| 6 | Emmanuel Morales | 1 | 1,274 | $854 | 1274.2 mi | 1154.2 mi | 1,154 | $773 | 1274 |
91% excess
|
| 7 | Christopher Womack | 3 | 562 | $377 | 187.4 mi | 115.0 mi | 345 | $231 | 187.3 |
61% excess
|
| 8 | Natosha Beierschmitt | 2 | 252 | $169 | 126.0 mi | 28.4 mi | 57 | $38 | 126 |
23% excess
|