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 | 284 | 265,301 | $177,752 | 934.2 mi | 925.7 mi | 262,905 | $176,146 | 934.2 |
99% excess
|
| 2 | Luis Iser | 275 | 58,183 | $38,983 | 211.6 mi | 194.1 mi | 53,376 | $35,762 | 211.6 |
92% excess
|
| 3 | Raymond Ebanks | 240 | 40,754 | $27,305 | 169.8 mi | 159.5 mi | 38,269 | $25,640 | 169.8 |
94% excess
|
| 4 | Ryan Lewis | 26 | 11,413 | $7,647 | 439.0 mi | 433.1 mi | 11,260 | $7,544 | 439 |
99% excess
|
| 5 | Horace Barnes | 164 | 11,357 | $7,609 | 69.3 mi | 61.2 mi | 10,044 | $6,729 | 69.3 |
88% excess
|
| 6 | Derick Velazquez | 512 | 10,837 | $7,261 | 21.2 mi | 7.5 mi | 3,833 | $2,568 | 21.2 |
35% excess
|
| 7 | Robert Lewis | 315 | 2,672 | $1,790 | 8.5 mi | 2.1 mi | 652 | $437 | 8.5 |
24% excess
|
| 8 | Elkin Barahona | 1 | 26 | $17 | 26.4 mi | 0.0 mi | 0 | $0 | 26 |
0% excess
|