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 | Kevin Cogdill | 198 | 57,800 | $38,726 | 291.9 mi | 279.8 mi | 55,402 | $37,119 | 291.9 |
96% excess
|
| 2 | Joe Evans | 202 | 35,285 | $23,641 | 174.7 mi | 163.6 mi | 33,057 | $22,148 | 174.7 |
94% excess
|
| 3 | Yves Dessin | 73 | 28,045 | $18,790 | 384.2 mi | 375.4 mi | 27,401 | $18,359 | 384.2 |
98% excess
|
| 4 | Ray-Anthony Alston | 317 | 5,634 | $3,775 | 17.8 mi | 2.8 mi | 896 | $600 | 17.8 |
16% excess
|
| 5 | Matthew Sebzda | 90 | 2,140 | $1,434 | 23.8 mi | 12.5 mi | 1,121 | $751 | 23.8 |
52% excess
|
| 6 | Kenneth Lancara | 7 | 2,015 | $1,350 | 287.9 mi | 277.8 mi | 1,945 | $1,303 | 287.9 |
97% excess
|
| 7 | Cynthia G Deville | 1 | 119 | $80 | 118.7 mi | 36.1 mi | 36 | $24 | 119 |
30% excess
|