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 | 16 | 2,366 | $1,585 | 147.9 mi | 29.9 mi | 478 | $320 | 147.9 |
20% excess
|
| 2 | Joseph Nuovo | 13 | 822 | $551 | 63.3 mi | 0.0 mi | 0 | $0 | 63.2 |
0% excess
|
| 3 | Marvin Rivas | 14 | 585 | $392 | 41.8 mi | 0.0 mi | 0 | $0 | 41.8 |
0% excess
|
| 4 | Davon Cox | 5 | 257 | $172 | 51.4 mi | 15.0 mi | 75 | $50 | 51.4 |
29% excess
|
| 5 | Alberto Galan | 4 | 249 | $167 | 62.3 mi | 26.0 mi | 104 | $70 | 62.3 |
42% excess
|
| 6 | April Nuovo | 3 | 236 | $158 | 78.6 mi | 0.0 mi | 0 | $0 | 78.7 |
0% excess
|