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 | Andrew Przybyla | 8 | 11,337 | $7,596 | 1417.2 mi | 1304.5 mi | 10,436 | $6,992 | 1417.1 |
92% excess
|
| 2 | Mike Huffman | 33 | 9,588 | $6,424 | 290.6 mi | 149.2 mi | 4,923 | $3,298 | 290.5 |
51% excess
|
| 3 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 4 | Franco Jackson | 17 | 4,262 | $2,856 | 250.7 mi | 129.2 mi | 2,197 | $1,472 | 250.7 |
52% excess
|
| 5 | Jon Kuehl | 22 | 3,006 | $2,014 | 136.7 mi | 41.8 mi | 919 | $616 | 136.6 |
31% excess
|
| 6 | Vincent Nyathi | 15 | 2,429 | $1,627 | 161.9 mi | 91.8 mi | 1,377 | $923 | 161.9 |
57% excess
|
| 7 | Blake Ward | 17 | 1,220 | $817 | 71.8 mi | 18.1 mi | 308 | $206 | 71.8 |
25% excess
|
| 8 | Brandon Green | 1 | 390 | $261 | 390.0 mi | 379.6 mi | 380 | $255 | 390 |
97% excess
|
| 9 | Kevin Cox | 6 | 275 | $184 | 45.8 mi | 0.0 mi | 0 | $0 | 45.8 |
0% excess
|
| 10 | Mark Stelter | 1 | 124 | $83 | 124.3 mi | 13.7 mi | 14 | $9 | 124 |
11% excess
|