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 | 26 | 22,573 | $15,124 | 868.2 mi | 807.4 mi | 20,992 | $14,065 | 868.2 |
93% excess
|
| 2 | Derick Velazquez | 22 | 3,965 | $2,657 | 180.2 mi | 153.9 mi | 3,385 | $2,268 | 180.2 |
85% excess
|
| 3 | Luis Iser | 35 | 2,316 | $1,552 | 66.2 mi | 39.1 mi | 1,370 | $918 | 66.2 |
59% excess
|
| 4 | Philmon Mehari | 2 | 1,928 | $1,292 | 964.1 mi | 922 mi | 1,844 | $1,235 | 964 |
96% excess
|
| 5 | Jared Heisler | 16 | 1,855 | $1,243 | 115.9 mi | 71.9 mi | 1,150 | $771 | 115.9 |
62% excess
|
| 6 | Raymond Ebanks | 31 | 1,804 | $1,209 | 58.2 mi | 28 mi | 869 | $582 | 58.2 |
48% excess
|
| 7 | Horace Barnes | 15 | 623 | $417 | 41.6 mi | 17.5 mi | 262 | $176 | 41.5 |
42% excess
|