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 | Arturo Diaz | 57 | 6,698 | $4,488 | 117.5 mi | 78.8 mi | 4,491 | $3,009 | 117.5 |
67% excess
|
| 2 | Zachary Stieben | 82 | 3,807 | $2,551 | 46.4 mi | 11.9 mi | 976 | $654 | 46.4 |
26% excess
|
| 3 | Anthony Wirth | 50 | 3,555 | $2,382 | 71.1 mi | 43.8 mi | 2,192 | $1,469 | 71.1 |
62% excess
|
| 4 | Chane Lacy | 49 | 3,089 | $2,070 | 63 mi | 33.7 mi | 1,653 | $1,108 | 63 |
54% excess
|
| 5 | Christopher Womack | 35 | 1,646 | $1,103 | 47 mi | 16.4 mi | 575 | $385 | 47 |
35% excess
|
| 6 | Curtis Sprague | 14 | 1,514 | $1,014 | 108.1 mi | 77.4 mi | 1,084 | $726 | 108.1 |
72% excess
|
| 7 | Christopher Carroll | 2 | 542 | $363 | 270.9 mi | 270.9 mi | 542 | $363 | 271 |
100% excess
|
| 8 | Darrell Hendrix | 2 | 474 | $318 | 236.9 mi | 0 mi | 0 | $0 | 237 |
0% excess
|
| 9 | Andrew Przybyla | 1 | 314 | $210 | 314.1 mi | 0 mi | 0 | $0 | 314 |
0% excess
|