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 | Jordan Moceri | 5 | 661 | $443 | 132.1 mi | 115.7 mi | 578 | $387 | 132.2 |
87% excess
|
| 2 | Jon Kuehl | 4 | 469 | $314 | 117.3 mi | 70.2 mi | 281 | $188 | 117.3 |
60% excess
|
| 3 | Mike Huffman | 5 | 221 | $148 | 44.3 mi | 20.7 mi | 104 | $70 | 44.2 |
47% excess
|
| 4 | Ben McClerklin | 1 | 128 | $86 | 128 mi | 128 mi | 128 | $86 | 128 |
100% excess
|
| 5 | Dustin Antolin | 3 | 124 | $83 | 41.3 mi | 3.6 mi | 11 | $7 | 41.3 |
9% excess
|
| 6 | Brandon Green | 3 | 112 | $75 | 37.4 mi | 0 mi | 0 | $0 | 37.3 |
0% excess
|
| 7 | Franco Jackson | 5 | 78 | $52 | 15.5 mi | 0 mi | 0 | $0 | 15.6 |
0% excess
|
| 8 | Vincent Nyathi | 1 | 13 | $9 | 12.9 mi | 4.7 mi | 5 | $3 | 13 |
38% excess
|