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 | Scott R Roberts | 19 | 1,882 | $1,261 | 99.1 mi | 8.2 mi | 156 | $105 | 99.1 |
8% excess
|
| 2 | Vincent Nyathi | 27 | 1,497 | $1,003 | 55.5 mi | 13.4 mi | 360 | $241 | 55.4 |
24% excess
|
| 3 | Jordan Moceri | 11 | 1,168 | $783 | 106.2 mi | 90 mi | 990 | $663 | 106.2 |
85% excess
|
| 4 | Mike Huffman | 26 | 1,066 | $714 | 41 mi | 4 mi | 104 | $70 | 41 |
10% excess
|
| 5 | Jon Kuehl | 5 | 679 | $455 | 135.9 mi | 81.5 mi | 407 | $273 | 135.8 |
60% excess
|
| 6 | Franco Jackson | 27 | 520 | $348 | 19.3 mi | 4.7 mi | 126 | $84 | 19.3 |
24% excess
|
| 7 | Dustin Antolin | 12 | 472 | $316 | 39.3 mi | 2.7 mi | 32 | $21 | 39.3 |
7% excess
|
| 8 | Brandon Green | 7 | 417 | $279 | 59.6 mi | 12.5 mi | 87 | $58 | 59.6 |
21% excess
|
| 9 | Mark Stelter | 11 | 414 | $277 | 37.6 mi | 0 mi | 0 | $0 | 37.6 |
0% excess
|
| 10 | Ben McClerklin | 4 | 392 | $263 | 98.1 mi | 97.6 mi | 390 | $261 | 98 |
99% excess
|
| 11 | Ronnie Salone | 19 | 360 | $241 | 19 mi | 0 mi | 0 | $0 | 18.9 |
0% excess
|
| 12 | Teddie Bracken | 3 | 97 | $65 | 32.5 mi | 8.3 mi | 25 | $17 | 32.3 |
26% excess
|
| 13 | Jim Kingery | 1 | 55 | $37 | 55 mi | 54.4 mi | 54 | $36 | 55 |
98% excess
|