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 | 96 | 7,328 | $4,910 | 76.3 mi | 51.9 mi | 4,980 | $3,337 | 76.3 |
68% excess
|
| 2 | Mark Stelter | 13 | 5,694 | $3,815 | 438.0 mi | 170.6 mi | 2,218 | $1,486 | 438 |
39% excess
|
| 3 | Mike Huffman | 98 | 5,636 | $3,776 | 57.5 mi | 20.3 mi | 1,985 | $1,330 | 57.5 |
35% excess
|
| 4 | Lawrence Yoder | 7 | 324 | $217 | 46.3 mi | 0.0 mi | 0 | $0 | 46.3 |
0% excess
|
| 5 | Ben McClerklin | 2 | 256 | $172 | 128.0 mi | 128.0 mi | 256 | $172 | 128 |
100% excess
|
| 6 | Brandon Green | 1 | 165 | $111 | 164.6 mi | 148.7 mi | 149 | $100 | 165 |
90% excess
|