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 | Chane Lacy | 38 | 5,011 | $3,357 | 131.9 mi | 69.8 mi | 2,654 | $1,778 | 131.9 |
53% excess
|
| 2 | Christopher Womack | 28 | 3,412 | $2,286 | 121.9 mi | 42.3 mi | 1,184 | $793 | 121.9 |
35% excess
|
| 3 | Kevin Cox | 17 | 1,264 | $847 | 74.3 mi | 7.6 mi | 130 | $87 | 74.4 |
10% excess
|
| 4 | Brandon Rodriguez | 2 | 1,185 | $794 | 592.4 mi | 592.4 mi | 1,185 | $794 | 592.5 |
100% excess
|
| 5 | Darrell Hendrix | 12 | 939 | $629 | 78.3 mi | 7.1 mi | 85 | $57 | 78.3 |
9% excess
|
| 6 | Thomas J Langenberg Jr | 4 | 569 | $381 | 142.3 mi | 88.1 mi | 352 | $236 | 142.3 |
62% excess
|
| 7 | Anthony Wirth | 6 | 269 | $180 | 44.8 mi | 0 mi | 0 | $0 | 44.8 |
0% excess
|
| 8 | Christopher Carroll | 1 | 266 | $178 | 266.1 mi | 266.1 mi | 266 | $178 | 266 |
100% excess
|