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 | Fanfan Siku | 50 | 6,727 | $4,507 | 134.5 mi | 26.5 mi | 1,325 | $888 | 134.5 |
20% excess
|
| 2 | Eric Mancerella | 36 | 3,484 | $2,334 | 96.8 mi | 6.6 mi | 238 | $159 | 96.8 |
7% excess
|
| 3 | Jackson Reeves | 3 | 821 | $550 | 273.7 mi | 126.9 mi | 381 | $255 | 273.7 |
46% excess
|
| 4 | Bennet O Dartey | 2 | 789 | $529 | 394.5 mi | 247.7 mi | 495 | $332 | 394.5 |
63% excess
|
| 5 | Fady Messak | 2 | 645 | $432 | 322.5 mi | 241.2 mi | 482 | $323 | 322.5 |
75% excess
|
| 6 | Paul Mccormish | 1 | 239 | $160 | 238.8 mi | 148.6 mi | 149 | $100 | 239 |
62% excess
|