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 | Ben Heinz | 82 | 26,149 | $17,520 | 318.9 mi | 309 mi | 25,334 | $16,974 | 318.9 |
97% excess
|
| 2 | Andrew Przybyla | 55 | 19,894 | $13,329 | 361.7 mi | 330.3 mi | 18,166 | $12,171 | 361.7 |
91% excess
|
| 3 | Tyler Bollman | 92 | 12,187 | $8,165 | 132.5 mi | 20.8 mi | 1,917 | $1,284 | 132.5 |
16% excess
|
| 4 | Jason Morris | 12 | 12,014 | $8,049 | 1001.2 mi | 958.3 mi | 11,500 | $7,705 | 1001.2 |
96% excess
|
| 5 | Chane Lacy | 116 | 9,503 | $6,367 | 81.9 mi | 44.4 mi | 5,154 | $3,453 | 81.9 |
54% excess
|
| 6 | Darrell Hendrix | 84 | 7,653 | $5,128 | 91.1 mi | 26.7 mi | 2,247 | $1,505 | 91.1 |
29% excess
|
| 7 | Christopher Womack | 109 | 7,205 | $4,827 | 66.1 mi | 21.5 mi | 2,339 | $1,567 | 66.1 |
32% excess
|
| 8 | Arturo Diaz | 56 | 6,696 | $4,486 | 119.6 mi | 80.2 mi | 4,489 | $3,008 | 119.6 |
67% excess
|
| 9 | Curtis Sprague | 29 | 5,160 | $3,457 | 177.9 mi | 97.6 mi | 2,830 | $1,896 | 177.9 |
55% excess
|
| 10 | Zachary Stieben | 97 | 4,658 | $3,121 | 48 mi | 13.5 mi | 1,312 | $879 | 48 |
28% excess
|
| 11 | Anthony Wirth | 66 | 4,316 | $2,892 | 65.4 mi | 35.6 mi | 2,348 | $1,573 | 65.4 |
54% excess
|
| 12 | Blake Ward | 48 | 3,948 | $2,645 | 82.3 mi | 29.3 mi | 1,404 | $941 | 82.3 |
36% excess
|
| 13 | Thomas J Langenberg Jr | 50 | 3,800 | $2,546 | 76 mi | 26.1 mi | 1,305 | $874 | 76 |
34% excess
|
| 14 | Kevin Cox | 56 | 3,670 | $2,459 | 65.5 mi | 4.1 mi | 228 | $153 | 65.5 |
6% excess
|
| 15 | Brandon Rodriguez | 7 | 3,495 | $2,342 | 499.3 mi | 499 mi | 3,493 | $2,340 | 499.3 |
100% excess
|
| 16 | Franco Jackson | 1 | 267 | $179 | 267.4 mi | 105.2 mi | 105 | $70 | 267 |
39% excess
|
| 17 | Christopher Carroll | 1 | 266 | $178 | 266.1 mi | 266.1 mi | 266 | $178 | 266 |
100% excess
|
| 18 | Maria Davis | 2 | 238 | $159 | 118.9 mi | 104.8 mi | 210 | $141 | 119 |
88% excess
|
| 19 | Jon Kuehl | 1 | 135 | $90 | 134.8 mi | 125.6 mi | 126 | $84 | 135 |
93% excess
|
| 20 | Ronnie Salone | 1 | 94 | $63 | 94 mi | 0 mi | 0 | $0 | 94 |
0% excess
|