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 | Luis Iser | 26 | 4,062 | $2,722 | 156.2 mi | 95.5 mi | 2,482 | $1,663 | 156.2 |
61% excess
|
| 2 | Derick Velazquez | 30 | 3,217 | $2,155 | 107.2 mi | 47.6 mi | 1,428 | $957 | 107.2 |
44% excess
|
| 3 | Konstantin Barskiy | 2 | 1,860 | $1,246 | 930.2 mi | 924.5 mi | 1,849 | $1,239 | 930 |
99% excess
|
| 4 | Raymond Ebanks | 3 | 522 | $350 | 173.9 mi | 168.2 mi | 505 | $338 | 174 |
97% excess
|
| 5 | Horace Barnes | 2 | 144 | $96 | 72.2 mi | 66.4 mi | 133 | $89 | 72 |
92% excess
|
| 6 | Robert Lewis | 4 | 27 | $18 | 6.9 mi | 1.1 mi | 5 | $3 | 6.8 |
19% excess
|