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 | Mike Huffman | 51 | 2,486 | $1,666 | 48.7 mi | 7.3 mi | 373 | $250 | 48.7 |
15% excess
|
| 2 | Vincent Nyathi | 41 | 1,968 | $1,319 | 48 mi | 13.7 mi | 563 | $377 | 48 |
29% excess
|
| 3 | Ronnie Salone | 78 | 1,781 | $1,193 | 22.8 mi | 0.6 mi | 49 | $33 | 22.8 |
3% excess
|
| 4 | Jordan Moceri | 26 | 1,426 | $955 | 54.8 mi | 30.6 mi | 796 | $533 | 54.8 |
56% excess
|
| 5 | Jon Kuehl | 17 | 1,394 | $934 | 82 mi | 39.4 mi | 669 | $448 | 82 |
48% excess
|
| 6 | Brandon Green | 16 | 826 | $553 | 51.6 mi | 33.7 mi | 539 | $361 | 51.6 |
65% excess
|
| 7 | Chris Galasso | 1 | 679 | $455 | 679.2 mi | 660.6 mi | 661 | $443 | 679 |
97% excess
|
| 8 | Dustin Antolin | 13 | 582 | $390 | 44.7 mi | 11.6 mi | 151 | $101 | 44.8 |
26% excess
|
| 9 | Franco Jackson | 16 | 532 | $356 | 33.2 mi | 15.2 mi | 243 | $163 | 33.3 |
46% excess
|
| 10 | Kevin Cox | 2 | 222 | $149 | 110.8 mi | 0 mi | 0 | $0 | 111 |
0% excess
|
| 11 | Scott R Roberts | 4 | 42 | $28 | 10.4 mi | 0 mi | 0 | $0 | 10.5 |
0% excess
|