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 | Jon Kuehl | 120 | 14,102 | $9,448 | 117.5 mi | 64.0 mi | 7,678 | $5,144 | 117.5 |
54% excess
|
| 2 | Mike Huffman | 69 | 12,831 | $8,597 | 186.0 mi | 98.9 mi | 6,823 | $4,571 | 186 |
53% excess
|
| 3 | Andrew Przybyla | 5 | 7,081 | $4,744 | 1416.3 mi | 1269.6 mi | 6,348 | $4,253 | 1416.2 |
90% excess
|
| 4 | Vincent Nyathi | 104 | 6,696 | $4,486 | 64.4 mi | 35.6 mi | 3,707 | $2,484 | 64.4 |
55% excess
|
| 5 | Jordan Moceri | 70 | 5,968 | $3,999 | 85.3 mi | 62.1 mi | 4,346 | $2,912 | 85.3 |
73% excess
|
| 6 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 7 | Franco Jackson | 75 | 5,757 | $3,857 | 76.8 mi | 36.6 mi | 2,745 | $1,839 | 76.8 |
48% excess
|
| 8 | Brandon Green | 36 | 2,276 | $1,525 | 63.2 mi | 29.7 mi | 1,069 | $716 | 63.2 |
47% excess
|
| 9 | Ronnie Salone | 11 | 1,456 | $976 | 132.4 mi | 55.8 mi | 614 | $411 | 132.4 |
42% excess
|
| 10 | Dustin Antolin | 31 | 986 | $661 | 31.8 mi | 4.6 mi | 141 | $94 | 31.8 |
14% excess
|
| 11 | Ben McClerklin | 2 | 256 | $172 | 128.0 mi | 128.0 mi | 256 | $172 | 128 |
100% excess
|
| 12 | Thomas J Langenberg Jr | 1 | 146 | $98 | 145.7 mi | 19.3 mi | 19 | $13 | 146 |
13% excess
|
| 13 | Blake Ward | 2 | 129 | $86 | 64.5 mi | 26.9 mi | 54 | $36 | 64.5 |
42% excess
|
| 14 | Mark Stelter | 1 | 124 | $83 | 124.3 mi | 13.7 mi | 14 | $9 | 124 |
11% excess
|
| 15 | Scott R Roberts | 2 | 99 | $66 | 49.3 mi | 44.6 mi | 89 | $60 | 49.5 |
90% excess
|
| 16 | Lawrence Yoder | 3 | 69 | $46 | 23.0 mi | 0.0 mi | 0 | $0 | 23 |
0% excess
|
| 17 | Kevin Cox | 2 | 61 | $41 | 30.4 mi | 0.0 mi | 0 | $0 | 30.5 |
0% excess
|