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 | Samuel Biddie | 54 | 21,138 | $14,162 | 391.5 mi | 271.4 mi | 14,653 | $9,818 | 391.4 |
69% excess
|
| 2 | Scott R Roberts | 74 | 6,585 | $4,412 | 89.0 mi | 7.7 mi | 566 | $379 | 89 |
9% excess
|
| 3 | Jackson Reeves | 34 | 6,122 | $4,102 | 180.1 mi | 47.1 mi | 1,601 | $1,073 | 180.1 |
26% excess
|
| 4 | Natosha Beierschmitt | 5 | 3,879 | $2,599 | 775.8 mi | 680.2 mi | 3,401 | $2,279 | 775.8 |
88% excess
|
| 5 | Vincent Nyathi | 18 | 2,382 | $1,596 | 132.4 mi | 99.5 mi | 1,791 | $1,200 | 132.3 |
75% excess
|
| 6 | Paul Mccormish | 7 | 1,276 | $855 | 182.3 mi | 135.3 mi | 947 | $634 | 182.3 |
74% excess
|
| 7 | Jordan Moceri | 6 | 797 | $534 | 132.9 mi | 94.1 mi | 565 | $379 | 132.8 |
71% excess
|
| 8 | Shawn Kelley | 1 | 749 | $502 | 749.2 mi | 693.3 mi | 693 | $464 | 749 |
93% excess
|
| 9 | Shady Messak | 1 | 744 | $498 | 744.4 mi | 542.6 mi | 543 | $364 | 744 |
73% excess
|
| 10 | Fady Messak | 1 | 656 | $440 | 656.3 mi | 426.9 mi | 427 | $286 | 656 |
65% excess
|
| 11 | Franco Jackson | 12 | 569 | $381 | 47.4 mi | 18.5 mi | 222 | $149 | 47.4 |
39% excess
|
| 12 | Rodney Charles | 1 | 474 | $318 | 473.8 mi | 469.3 mi | 469 | $314 | 474 |
99% excess
|
| 13 | Blake Ward | 2 | 452 | $303 | 225.8 mi | 149.3 mi | 299 | $200 | 226 |
66% excess
|