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 | 137 | 33,440 | $22,405 | 244.1 mi | 165.7 mi | 22,700 | $15,209 | 244.1 |
68% excess
|
| 2 | Scott R Roberts | 33 | 4,382 | $2,936 | 132.8 mi | 56.4 mi | 1,862 | $1,248 | 132.8 |
42% excess
|
| 3 | Vincent Nyathi | 141 | 4,304 | $2,884 | 30.5 mi | 7.1 mi | 1,002 | $671 | 30.5 |
23% excess
|
| 4 | Jon Kuehl | 27 | 2,431 | $1,629 | 90.0 mi | 12.8 mi | 345 | $231 | 90 |
14% excess
|
| 5 | Dustin Antolin | 2 | 653 | $438 | 326.3 mi | 0.0 mi | 0 | $0 | 326.5 |
0% excess
|
| 6 | Mike Huffman | 1 | 265 | $178 | 265.1 mi | 139.1 mi | 139 | $93 | 265 |
52% excess
|
| 7 | Franco Jackson | 1 | 84 | $56 | 83.6 mi | 62.0 mi | 62 | $42 | 84 |
74% excess
|