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 | Michael Swingle | 90 | 5,502 | $3,686 | 61.1 mi | 24.4 mi | 2,198 | $1,473 | 61.1 |
40% excess
|
| 6 | Davon Cox | 7 | 5,305 | $3,554 | 757.8 mi | 590.5 mi | 4,133 | $2,769 | 757.9 |
78% excess
|
| 7 | Bruce Ballard | 35 | 5,300 | $3,551 | 151.4 mi | 24.1 mi | 843 | $565 | 151.4 |
16% excess
|
| 8 | Philmon Mehari | 6 | 4,483 | $3,004 | 747.2 mi | 579.9 mi | 3,479 | $2,331 | 747.2 |
78% excess
|
| 9 | Samuel Biddie | 21 | 3,770 | $2,526 | 179.5 mi | 21.5 mi | 452 | $303 | 179.5 |
12% excess
|
| 10 | Vivian Hyde | 3 | 2,101 | $1,408 | 700.4 mi | 580.1 mi | 1,740 | $1,166 | 700.3 |
83% excess
|
| 11 | Praelow Cameron | 10 | 1,783 | $1,195 | 178.3 mi | 52.8 mi | 528 | $354 | 178.3 |
30% excess
|
| 12 | James Duff | 37 | 1,692 | $1,134 | 45.7 mi | 14.5 mi | 538 | $360 | 45.7 |
32% excess
|
| 13 | Christopher Carroll | 5 | 1,643 | $1,101 | 328.7 mi | 301.9 mi | 1,510 | $1,012 | 328.6 |
92% excess
|
| 14 | Andre Samuda | 2 | 1,469 | $984 | 734.5 mi | 648.6 mi | 1,297 | $869 | 734.5 |
88% excess
|
| 15 | Rodney Charles | 2 | 1,318 | $883 | 658.9 mi | 491.1 mi | 982 | $658 | 659 |
75% excess
|
| 16 | Fady Messak | 2 | 1,313 | $880 | 656.7 mi | 512.1 mi | 1,024 | $686 | 656.5 |
78% excess
|
| 17 | Todd Fogiel | 5 | 735 | $492 | 147.1 mi | 11.3 mi | 56 | $38 | 147 |
8% excess
|
| 18 | Rozier Cole | 1 | 340 | $228 | 339.6 mi | 129.4 mi | 129 | $86 | 340 |
38% excess
|
| 19 | Henry Holmes | 1 | 91 | $61 | 90.8 mi | 4.8 mi | 5 | $3 | 91 |
5% excess
|