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 | 81 | 1,460 | $978 | 18 mi | 2.8 mi | 229 | $153 | 18 |
16% excess
|
| 2 | David Trost | 33 | 1,111 | $744 | 33.7 mi | 15.6 mi | 515 | $345 | 33.7 |
46% excess
|
| 3 | Pete Ramos | 41 | 823 | $551 | 20.1 mi | 2.5 mi | 102 | $68 | 20.1 |
12% excess
|
| 4 | Darrell Hope | 21 | 524 | $351 | 24.9 mi | 13.1 mi | 275 | $184 | 25 |
52% excess
|
| 5 | Edward Arias | 14 | 313 | $210 | 22.4 mi | 15.3 mi | 214 | $143 | 22.4 |
68% excess
|
| 6 | Mohamed Shareed | 6 | 206 | $138 | 34.3 mi | 29 mi | 174 | $117 | 34.3 |
84% excess
|