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 | Ryan Lewis | 34 | 9,752 | $6,534 | 286.8 mi | 129.3 mi | 4,398 | $2,947 | 286.8 |
45% excess
|
| 2 | Patricia Gordon | 17 | 6,005 | $4,023 | 353.2 mi | 335.2 mi | 5,699 | $3,818 | 353.2 |
95% excess
|
| 3 | Bryan Rodriguez | 8 | 5,973 | $4,002 | 746.6 mi | 579.3 mi | 4,634 | $3,105 | 746.6 |
78% excess
|
| 4 | Paul Mccormish | 16 | 5,831 | $3,907 | 364.5 mi | 346.5 mi | 5,543 | $3,714 | 364.4 |
95% excess
|
| 5 | Davon Cox | 7 | 5,305 | $3,554 | 757.8 mi | 590.5 mi | 4,133 | $2,769 | 757.9 |
78% excess
|
| 6 | Bruce Ballard | 35 | 5,300 | $3,551 | 151.4 mi | 24.1 mi | 843 | $565 | 151.4 |
16% excess
|
| 7 | Philmon Mehari | 6 | 4,483 | $3,004 | 747.2 mi | 579.9 mi | 3,479 | $2,331 | 747.2 |
78% excess
|
| 8 | Samuel Biddie | 21 | 3,770 | $2,526 | 179.5 mi | 21.5 mi | 452 | $303 | 179.5 |
12% excess
|
| 9 | Vivian Hyde | 3 | 2,101 | $1,408 | 700.4 mi | 580.1 mi | 1,740 | $1,166 | 700.3 |
83% excess
|
| 10 | Andre Samuda | 2 | 1,469 | $984 | 734.5 mi | 648.6 mi | 1,297 | $869 | 734.5 |
88% excess
|
| 11 | Rodney Charles | 2 | 1,318 | $883 | 658.9 mi | 491.1 mi | 982 | $658 | 659 |
75% excess
|
| 12 | Fady Messak | 2 | 1,313 | $880 | 656.7 mi | 512.1 mi | 1,024 | $686 | 656.5 |
78% excess
|