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 | Curtis Allen | 35 | 1,334 | $894 | 38.1 mi | 21.0 mi | 736 | $493 | 38.1 |
55% excess
|
| 2 | Pete Ramos | 29 | 636 | $426 | 21.9 mi | 3.3 mi | 97 | $65 | 21.9 |
15% excess
|
| 3 | Chris Galasso | 13 | 194 | $130 | 14.9 mi | 0.2 mi | 2 | $1 | 14.9 |
1% excess
|
| 4 | David Trost | 5 | 187 | $125 | 37.3 mi | 13.7 mi | 69 | $46 | 37.4 |
37% excess
|
| 5 | Maximilian Tucker | 8 | 153 | $103 | 19.1 mi | 5.8 mi | 46 | $31 | 19.1 |
30% excess
|
| 6 | Edward Arias | 5 | 85 | $57 | 17.1 mi | 6.6 mi | 33 | $22 | 17 |
39% excess
|
| 7 | Philip Krogstad | 1 | 71 | $48 | 70.6 mi | 62.2 mi | 62 | $42 | 71 |
87% excess
|
| 8 | Mohamed Shareed | 2 | 66 | $44 | 32.9 mi | 21.2 mi | 42 | $28 | 33 |
64% excess
|