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 | Jim Kingery | 83 | 20,259 | $13,574 | 244.1 mi | 165.7 mi | 13,752 | $9,214 | 244.1 |
68% excess
|
| 2 | Scott R Roberts | 26 | 3,846 | $2,577 | 147.9 mi | 71.6 mi | 1,862 | $1,248 | 147.9 |
48% excess
|
| 3 | Phillip Castillo | 2 | 3,438 | $2,303 | 1718.8 mi | 1694.9 mi | 3,390 | $2,271 | 1719 |
99% excess
|
| 4 | Vincent Nyathi | 82 | 2,529 | $1,694 | 30.8 mi | 7.5 mi | 614 | $411 | 30.8 |
24% excess
|
| 5 | Jackson Reeves | 52 | 1,985 | $1,330 | 38.2 mi | 0 mi | 0 | $0 | 38.2 |
0% excess
|
| 6 | Tyler Bollman | 1 | 1,469 | $984 | 1468.5 mi | 1339 mi | 1,339 | $897 | 1469 |
91% excess
|
| 7 | Dustin Antolin | 2 | 653 | $438 | 326.2 mi | 0 mi | 0 | $0 | 326.5 |
0% excess
|
| 8 | Bennet O Dartey | 4 | 499 | $334 | 124.7 mi | 86.2 mi | 345 | $231 | 124.8 |
69% excess
|
| 9 | Jon Kuehl | 5 | 493 | $330 | 98.7 mi | 26.2 mi | 131 | $88 | 98.6 |
27% excess
|
| 10 | Mike Huffman | 1 | 265 | $178 | 265.1 mi | 139.1 mi | 139 | $93 | 265 |
52% excess
|