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 | Bruce Ballard | 13 | 1,922 | $1,288 | 147.9 mi | 29.9 mi | 388 | $260 | 147.8 |
20% excess
|
| 2 | Joseph Nuovo | 7 | 432 | $289 | 61.7 mi | 0 mi | 0 | $0 | 61.7 |
0% excess
|
| 3 | Marvin Rivas | 6 | 323 | $216 | 53.8 mi | 0 mi | 0 | $0 | 53.8 |
0% excess
|
| 4 | Davon Cox | 5 | 257 | $172 | 51.4 mi | 15 mi | 75 | $50 | 51.4 |
29% excess
|
| 5 | Alberto Galan | 4 | 249 | $167 | 62.3 mi | 26 mi | 104 | $70 | 62.3 |
42% excess
|
| 6 | April Nuovo | 3 | 236 | $158 | 78.6 mi | 0 mi | 0 | $0 | 78.7 |
0% excess
|
| 7 | Shady Messak | 1 | 156 | $105 | 155.7 mi | 90.6 mi | 91 | $61 | 156 |
58% excess
|