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 | Andrew Przybyla | 41 | 15,265 | $10,228 | 372.3 mi | 335.2 mi | 13,744 | $9,208 | 372.3 |
90% excess
|
| 2 | Arturo Diaz | 55 | 6,682 | $4,477 | 121.5 mi | 81.5 mi | 4,482 | $3,003 | 121.5 |
67% excess
|
| 3 | Zachary Stieben | 85 | 4,458 | $2,987 | 52.4 mi | 15.2 mi | 1,295 | $868 | 52.4 |
29% excess
|
| 4 | Darrell Hendrix | 24 | 3,669 | $2,458 | 152.9 mi | 89.4 mi | 2,146 | $1,438 | 152.9 |
58% excess
|
| 5 | Anthony Wirth | 50 | 3,555 | $2,382 | 71.1 mi | 43.8 mi | 2,192 | $1,469 | 71.1 |
62% excess
|
| 6 | Tyler Bollman | 40 | 3,287 | $2,202 | 82.2 mi | 47 mi | 1,880 | $1,260 | 82.2 |
57% excess
|
| 7 | Chane Lacy | 49 | 3,089 | $2,070 | 63 mi | 33.7 mi | 1,653 | $1,108 | 63 |
54% excess
|
| 8 | Thomas J Langenberg Jr | 38 | 2,538 | $1,700 | 66.8 mi | 19.4 mi | 737 | $494 | 66.8 |
29% excess
|
| 9 | Blake Ward | 32 | 2,509 | $1,681 | 78.4 mi | 34.7 mi | 1,112 | $745 | 78.4 |
44% excess
|
| 10 | Jason Morris | 2 | 2,004 | $1,343 | 1002 mi | 999.1 mi | 1,998 | $1,339 | 1002 |
100% excess
|
| 11 | Christopher Womack | 36 | 1,976 | $1,324 | 54.9 mi | 17.4 mi | 626 | $419 | 54.9 |
32% excess
|
| 12 | Curtis Sprague | 14 | 1,514 | $1,014 | 108.1 mi | 77.4 mi | 1,084 | $726 | 108.1 |
72% excess
|
| 13 | Brandon Rodriguez | 4 | 1,185 | $794 | 296.2 mi | 296.2 mi | 1,185 | $794 | 296.3 |
100% excess
|
| 14 | Kevin Cox | 19 | 514 | $344 | 27.1 mi | 3.7 mi | 70 | $47 | 27.1 |
14% excess
|
| 15 | Franco Jackson | 1 | 267 | $179 | 267.4 mi | 105.2 mi | 105 | $70 | 267 |
39% excess
|
| 16 | Ronnie Salone | 1 | 94 | $63 | 94 mi | 0 mi | 0 | $0 | 94 |
0% excess
|