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 | 13 | 12,093 | $8,102 | 930.2 mi | 924.6 mi | 12,019 | $8,053 | 930.2 |
99% excess
|
| 2 | Luis Iser | 26 | 5,362 | $3,593 | 206.2 mi | 185.7 mi | 4,828 | $3,235 | 206.2 |
90% excess
|
| 3 | Raymond Ebanks | 22 | 3,837 | $2,571 | 174.4 mi | 168.7 mi | 3,712 | $2,487 | 174.4 |
97% excess
|
| 4 | Horace Barnes | 16 | 1,154 | $773 | 72.1 mi | 66.2 mi | 1,059 | $710 | 72.1 |
92% excess
|
| 5 | Derick Velazquez | 32 | 800 | $536 | 25 mi | 9.2 mi | 294 | $197 | 25 |
37% excess
|
| 6 | Robert Lewis | 13 | 94 | $63 | 7.2 mi | 1.6 mi | 20 | $13 | 7.2 |
21% excess
|