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 | Jim Kingery | 100 | 21,005 | $14,073 | 210.1 mi | 145.6 mi | 14,565 | $9,759 | 210.1 |
69% excess
|
| 2 | Scott R Roberts | 140 | 11,592 | $7,767 | 82.8 mi | 19.7 mi | 2,751 | $1,843 | 82.8 |
24% excess
|
| 3 | Jon Kuehl | 84 | 10,173 | $6,816 | 121.1 mi | 62.2 mi | 5,224 | $3,500 | 121.1 |
51% excess
|
| 4 | Mike Huffman | 93 | 9,962 | $6,675 | 107.1 mi | 49.7 mi | 4,622 | $3,097 | 107.1 |
46% excess
|
| 5 | Mark Stelter | 113 | 9,458 | $6,337 | 83.7 mi | 19.6 mi | 2,218 | $1,486 | 83.7 |
23% excess
|
| 6 | Franco Jackson | 198 | 7,335 | $4,914 | 37 mi | 13.5 mi | 2,680 | $1,796 | 37 |
37% excess
|
| 7 | Andrew Przybyla | 5 | 7,081 | $4,744 | 1416.3 mi | 1269.6 mi | 6,348 | $4,253 | 1416.2 |
90% excess
|
| 8 | Brandon Green | 81 | 6,564 | $4,398 | 81 mi | 31.3 mi | 2,536 | $1,699 | 81 |
39% excess
|
| 9 | Dustin Antolin | 74 | 6,492 | $4,350 | 87.7 mi | 15.3 mi | 1,136 | $761 | 87.7 |
17% excess
|
| 10 | Vincent Nyathi | 107 | 6,464 | $4,331 | 60.4 mi | 30.2 mi | 3,229 | $2,163 | 60.4 |
50% excess
|
| 11 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 12 | Michah Brackett | 4 | 5,394 | $3,614 | 1348.5 mi | 1096.4 mi | 4,385 | $2,938 | 1348.5 |
81% excess
|
| 13 | Jordan Moceri | 71 | 4,813 | $3,225 | 67.8 mi | 44.4 mi | 3,153 | $2,113 | 67.8 |
66% excess
|
| 14 | Ronnie Salone | 87 | 3,421 | $2,292 | 39.3 mi | 7.6 mi | 663 | $444 | 39.3 |
19% excess
|
| 15 | Chris Galasso | 4 | 2,780 | $1,863 | 695 mi | 507.5 mi | 2,030 | $1,360 | 695 |
73% excess
|
| 16 | Teddie Bracken | 62 | 1,996 | $1,337 | 32.2 mi | 9.3 mi | 579 | $388 | 32.2 |
29% excess
|
| 17 | Kevin Cox | 5 | 528 | $354 | 105.6 mi | 19.1 mi | 96 | $64 | 105.6 |
18% excess
|
| 18 | Ben McClerklin | 5 | 392 | $263 | 78.4 mi | 78.1 mi | 390 | $261 | 78.4 |
99% excess
|
| 19 | Lawrence Yoder | 2 | 228 | $153 | 114.1 mi | 0 mi | 0 | $0 | 114 |
0% excess
|