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 | Mohamed Shareed | 47 | 3,292 | $2,206 | 70 mi | 53.7 mi | 2,526 | $1,692 | 70 |
77% excess
|
| 2 | Edward Arias | 27 | 1,849 | $1,239 | 68.5 mi | 53.4 mi | 1,442 | $966 | 68.5 |
78% excess
|
| 3 | Luis Torres | 76 | 1,544 | $1,034 | 20.3 mi | 2.2 mi | 165 | $111 | 20.3 |
11% excess
|
| 4 | Pete Ramos | 5 | 414 | $277 | 82.8 mi | 41.3 mi | 206 | $138 | 82.8 |
50% excess
|
| 5 | Curtis Allen | 5 | 412 | $276 | 82.5 mi | 68.2 mi | 341 | $228 | 82.4 |
83% excess
|
| 6 | Darrell Hope | 5 | 320 | $214 | 64.1 mi | 43 mi | 215 | $144 | 64 |
67% excess
|
| 7 | David Cavaco | 3 | 203 | $136 | 67.6 mi | 46.9 mi | 141 | $94 | 67.7 |
69% excess
|
| 8 | Nick O'Neill | 1 | 96 | $64 | 96.1 mi | 82.8 mi | 83 | $56 | 96 |
86% excess
|