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 | 19 | 17,725 | $11,876 | 932.9 mi | 924.7 mi | 17,570 | $11,772 | 932.9 |
99% excess
|
| 2 | Luis Iser | 9 | 2,052 | $1,375 | 228.0 mi | 222.3 mi | 2,001 | $1,341 | 228 |
98% 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
|