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 | 72 | 6,592 | $4,417 | 91.6 mi | 67.7 mi | 4,872 | $3,264 | 91.6 |
74% excess
|
| 2 | Mike Huffman | 34 | 2,234 | $1,497 | 65.7 mi | 39.7 mi | 1,348 | $903 | 65.7 |
60% excess
|
| 3 | Ben McClerklin | 2 | 256 | $172 | 128.0 mi | 128.0 mi | 256 | $172 | 128 |
100% excess
|
| 4 | Lawrence Yoder | 6 | 178 | $119 | 29.7 mi | 0.0 mi | 0 | $0 | 29.7 |
0% excess
|