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 | 133 | 33,310 | $22,318 | 250.5 mi | 221.7 mi | 29,487 | $19,756 | 250.5 |
89% excess
|
| 2 | Ben Heinz | 83 | 26,528 | $17,774 | 319.6 mi | 305.2 mi | 25,334 | $16,974 | 319.6 |
95% excess
|
| 3 | Tyler Bollman | 196 | 23,167 | $15,522 | 118.2 mi | 11.6 mi | 2,276 | $1,525 | 118.2 |
10% excess
|
| 4 | Chane Lacy | 188 | 15,940 | $10,680 | 84.8 mi | 49.3 mi | 9,277 | $6,216 | 84.8 |
58% excess
|
| 5 | Jason Morris | 15 | 14,868 | $9,962 | 991.2 mi | 941.7 mi | 14,126 | $9,464 | 991.2 |
95% excess
|
| 6 | Christopher Womack | 179 | 13,195 | $8,841 | 73.7 mi | 23.9 mi | 4,272 | $2,862 | 73.7 |
32% excess
|
| 7 | Curtis Sprague | 47 | 12,678 | $8,494 | 269.7 mi | 183.1 mi | 8,606 | $5,766 | 269.7 |
68% excess
|
| 8 | Darrell Hendrix | 110 | 10,397 | $6,966 | 94.5 mi | 24.4 mi | 2,684 | $1,798 | 94.5 |
26% excess
|
| 9 | Anthony Wirth | 135 | 9,282 | $6,219 | 68.8 mi | 34.5 mi | 4,661 | $3,123 | 68.8 |
50% excess
|
| 10 | Zachary Stieben | 160 | 8,607 | $5,767 | 53.8 mi | 20.2 mi | 3,237 | $2,169 | 53.8 |
38% excess
|
| 11 | Arturo Diaz | 90 | 8,240 | $5,521 | 91.6 mi | 61.9 mi | 5,572 | $3,733 | 91.6 |
68% excess
|
| 12 | Kevin Cox | 93 | 6,948 | $4,655 | 74.7 mi | 12.7 mi | 1,179 | $790 | 74.7 |
17% excess
|
| 13 | Blake Ward | 80 | 6,518 | $4,367 | 81.5 mi | 35.9 mi | 2,875 | $1,926 | 81.5 |
44% excess
|
| 14 | Thomas J Langenberg Jr | 106 | 6,506 | $4,359 | 61.4 mi | 15.2 mi | 1,610 | $1,079 | 61.4 |
25% excess
|
| 15 | Brandon Rodriguez | 8 | 4,088 | $2,739 | 511.0 mi | 510.7 mi | 4,086 | $2,738 | 511 |
100% excess
|
| 16 | Michah Brackett | 4 | 2,375 | $1,591 | 593.8 mi | 554.7 mi | 2,219 | $1,487 | 593.8 |
93% excess
|
| 17 | Jeffrey Pastor | 1 | 826 | $553 | 825.9 mi | 820.2 mi | 820 | $549 | 826 |
99% excess
|
| 18 | Maria Davis | 3 | 467 | $313 | 155.7 mi | 121.1 mi | 363 | $243 | 155.7 |
78% excess
|
| 19 | Jason Cunningham | 1 | 278 | $186 | 277.5 mi | 267.2 mi | 267 | $179 | 278 |
96% excess
|
| 20 | Franco Jackson | 1 | 267 | $179 | 267.4 mi | 105.2 mi | 105 | $70 | 267 |
39% excess
|
| 21 | Christopher Carroll | 1 | 266 | $178 | 266.1 mi | 266.1 mi | 266 | $178 | 266 |
100% excess
|
| 22 | Saul Morales | 2 | 252 | $169 | 126.0 mi | 116.6 mi | 233 | $156 | 126 |
92% excess
|
| 23 | Robert Lewis | 3 | 235 | $157 | 78.4 mi | 0.0 mi | 0 | $0 | 78.3 |
0% excess
|
| 24 | Ronnie Salone | 2 | 159 | $107 | 79.6 mi | 0.0 mi | 0 | $0 | 79.5 |
0% excess
|
| 25 | Jon Kuehl | 1 | 135 | $90 | 134.8 mi | 125.6 mi | 126 | $84 | 135 |
93% excess
|
| 26 | Vincent Nyathi | 2 | 100 | $67 | 50.1 mi | 0.0 mi | 0 | $0 | 50 |
0% excess
|
| 27 | Scott E Yelverton | 1 | 6 | $4 | 5.5 mi | 0.0 mi | 0 | $0 | 6 |
0% excess
|