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 | Konstantin Barskiy | 20 | 18,664 | $12,505 | 933.2 mi | 925.2 mi | 18,504 | $12,398 | 933.2 |
99% excess
|
| 2 | Luis Iser | 10 | 2,268 | $1,520 | 226.8 mi | 220.3 mi | 2,203 | $1,476 | 226.8 |
97% excess
|
| 3 | Raymond Ebanks | 8 | 1,357 | $909 | 169.6 mi | 162.7 mi | 1,301 | $872 | 169.6 |
96% excess
|
| 4 | Ryan Lewis | 1 | 437 | $293 | 436.8 mi | 431.0 mi | 431 | $289 | 437 |
99% excess
|
| 5 | Horace Barnes | 4 | 271 | $182 | 67.8 mi | 59.9 mi | 240 | $161 | 67.8 |
89% excess
|
| 6 | Robert Lewis | 11 | 122 | $82 | 11.1 mi | 3.0 mi | 33 | $22 | 11.1 |
27% excess
|
| 7 | Derick Velazquez | 19 | 109 | $73 | 5.7 mi | 0.0 mi | 0 | $0 | 5.7 |
0% excess
|