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 | Konstantin Barskiy | 39 | 36,953 | $24,759 | 947.5 mi | 929.7 mi | 36,259 | $24,294 | 947.5 |
98% excess
|
| 2 | Philmon Mehari | 23 | 32,986 | $22,101 | 1434.2 mi | 1303.5 mi | 29,981 | $20,087 | 1434.2 |
91% excess
|
| 3 | Fernando Lemos | 20 | 31,385 | $21,028 | 1569.2 mi | 1561.2 mi | 31,224 | $20,920 | 1569.3 |
99% excess
|
| 4 | Eric Mancerella | 32 | 27,396 | $18,355 | 856.1 mi | 698.2 mi | 22,344 | $14,970 | 856.1 |
82% excess
|
| 5 | Ben Heinz | 72 | 25,728 | $17,238 | 357.3 mi | 351.9 mi | 25,334 | $16,974 | 357.3 |
98% excess
|
| 6 | Davon Cox | 20 | 22,308 | $14,946 | 1115.4 mi | 1078.1 mi | 21,562 | $14,447 | 1115.4 |
97% excess
|
| 7 | Fady Messak | 37 | 14,016 | $9,391 | 378.8 mi | 295.8 mi | 10,944 | $7,332 | 378.8 |
78% excess
|
| 8 | Christopher Carroll | 23 | 11,844 | $7,935 | 515 mi | 463.6 mi | 10,663 | $7,144 | 515 |
90% excess
|
| 9 | Side Kick Technician | 27 | 10,652 | $7,137 | 394.5 mi | 387.1 mi | 10,452 | $7,003 | 394.5 |
98% excess
|
| 10 | Raymond Ebanks | 39 | 6,272 | $4,202 | 160.8 mi | 150 mi | 5,848 | $3,918 | 160.8 |
93% excess
|
| 11 | Ryan Lewis | 27 | 5,573 | $3,734 | 206.4 mi | 69.3 mi | 1,871 | $1,254 | 206.4 |
34% excess
|
| 12 | Bennet O Dartey | 12 | 5,271 | $3,532 | 439.3 mi | 268.3 mi | 3,220 | $2,157 | 439.3 |
61% excess
|
| 13 | Rozier Cole | 16 | 4,528 | $3,034 | 283 mi | 229.7 mi | 3,675 | $2,462 | 283 |
81% excess
|
| 14 | Jared Heisler | 11 | 4,464 | $2,991 | 405.8 mi | 339.2 mi | 3,731 | $2,500 | 405.8 |
84% excess
|
| 15 | Kevin Cogdill | 19 | 4,406 | $2,952 | 231.9 mi | 217.5 mi | 4,132 | $2,768 | 231.9 |
94% excess
|
| 16 | Shawn Kelley | 2 | 4,300 | $2,881 | 2149.9 mi | 2138.4 mi | 4,277 | $2,866 | 2150 |
99% excess
|
| 17 | Joseph Nuovo | 26 | 4,288 | $2,873 | 164.9 mi | 45.1 mi | 1,173 | $786 | 164.9 |
27% excess
|
| 18 | Andrew Przybyla | 6 | 3,697 | $2,477 | 616.2 mi | 577.3 mi | 3,464 | $2,321 | 616.2 |
94% excess
|
| 19 | Phillip Castillo | 2 | 3,438 | $2,303 | 1718.8 mi | 1694.9 mi | 3,390 | $2,271 | 1719 |
99% excess
|
| 20 | Fady Khouzam | 9 | 3,389 | $2,271 | 376.6 mi | 327.6 mi | 2,948 | $1,975 | 376.6 |
87% excess
|
| 21 | Jennifer Johnson | 3 | 3,281 | $2,198 | 1093.8 mi | 1077.3 mi | 3,232 | $2,165 | 1093.7 |
99% excess
|
| 22 | Kenneth Lancara | 33 | 3,274 | $2,194 | 99.2 mi | 66 mi | 2,179 | $1,460 | 99.2 |
67% excess
|
| 23 | Marvin Rivas | 26 | 2,803 | $1,878 | 107.8 mi | 1.5 mi | 38 | $25 | 107.8 |
1% excess
|
| 24 | Yves Dessin | 8 | 2,544 | $1,704 | 318 mi | 298.1 mi | 2,385 | $1,598 | 318 |
94% excess
|
| 25 | Praelow Cameron | 28 | 2,313 | $1,550 | 82.6 mi | 26.5 mi | 741 | $496 | 82.6 |
32% excess
|
| 26 | Scott A Berry | 5 | 2,229 | $1,493 | 445.8 mi | 428.2 mi | 2,141 | $1,434 | 445.8 |
96% excess
|
| 27 | Jackson Reeves | 15 | 2,172 | $1,455 | 144.8 mi | 35.2 mi | 528 | $354 | 144.8 |
24% excess
|
| 28 | Todd Fogiel | 11 | 2,067 | $1,385 | 187.9 mi | 71.7 mi | 788 | $528 | 187.9 |
38% excess
|
| 29 | Horace Barnes | 28 | 2,046 | $1,371 | 73.1 mi | 67.3 mi | 1,886 | $1,264 | 73.1 |
92% excess
|
| 30 | Scott R Roberts | 20 | 2,043 | $1,369 | 102.1 mi | 8.5 mi | 169 | $113 | 102.2 |
8% excess
|