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 | 43 | 40,674 | $27,252 | 945.9 mi | 929.2 mi | 39,957 | $26,771 | 945.9 |
98% excess
|
| 2 | Fernando Lemos | 25 | 40,599 | $27,201 | 1623.9 mi | 1616.3 mi | 40,408 | $27,073 | 1624 |
100% excess
|
| 3 | Philmon Mehari | 33 | 33,492 | $22,440 | 1014.9 mi | 916 mi | 30,227 | $20,252 | 1014.9 |
90% 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 | 43 | 17,043 | $11,419 | 396.4 mi | 310.7 mi | 13,360 | $8,951 | 396.3 |
78% excess
|
| 8 | Side Kick Technician | 43 | 16,591 | $11,116 | 385.8 mi | 378.4 mi | 16,271 | $10,902 | 385.8 |
98% excess
|
| 9 | Christopher Carroll | 23 | 11,844 | $7,935 | 515 mi | 463.6 mi | 10,663 | $7,144 | 515 |
90% excess
|
| 10 | Bennet O Dartey | 22 | 9,584 | $6,421 | 435.6 mi | 220.7 mi | 4,856 | $3,254 | 435.6 |
51% excess
|
| 11 | Raymond Ebanks | 53 | 8,776 | $5,880 | 165.6 mi | 156.1 mi | 8,272 | $5,542 | 165.6 |
94% excess
|
| 12 | Yves Dessin | 17 | 8,675 | $5,812 | 510.3 mi | 496.7 mi | 8,445 | $5,658 | 510.3 |
97% excess
|
| 13 | Ryan Lewis | 27 | 5,573 | $3,734 | 206.4 mi | 69.3 mi | 1,871 | $1,254 | 206.4 |
34% excess
|
| 14 | Jared Heisler | 12 | 5,509 | $3,691 | 459.1 mi | 395 mi | 4,740 | $3,176 | 459.1 |
86% excess
|
| 15 | Fady Khouzam | 12 | 5,061 | $3,391 | 421.8 mi | 379.4 mi | 4,553 | $3,051 | 421.8 |
90% excess
|
| 16 | Rozier Cole | 16 | 4,528 | $3,034 | 283 mi | 229.7 mi | 3,675 | $2,462 | 283 |
81% excess
|
| 17 | Kevin Cogdill | 19 | 4,406 | $2,952 | 231.9 mi | 217.5 mi | 4,132 | $2,768 | 231.9 |
94% excess
|
| 18 | Joseph Nuovo | 27 | 4,301 | $2,882 | 159.3 mi | 43.4 mi | 1,173 | $786 | 159.3 |
27% excess
|
| 19 | Shawn Kelley | 2 | 4,300 | $2,881 | 2149.9 mi | 2138.4 mi | 4,277 | $2,866 | 2150 |
99% excess
|
| 20 | Marvin Rivas | 31 | 3,705 | $2,482 | 119.5 mi | 5.9 mi | 184 | $123 | 119.5 |
5% excess
|
| 21 | Andrew Przybyla | 6 | 3,697 | $2,477 | 616.2 mi | 577.3 mi | 3,464 | $2,321 | 616.2 |
94% excess
|
| 22 | Praelow Cameron | 34 | 3,555 | $2,382 | 104.6 mi | 49.3 mi | 1,676 | $1,123 | 104.6 |
47% excess
|
| 23 | Phillip Castillo | 2 | 3,438 | $2,303 | 1718.8 mi | 1694.9 mi | 3,390 | $2,271 | 1719 |
99% excess
|
| 24 | Jennifer Johnson | 3 | 3,281 | $2,198 | 1093.8 mi | 1077.3 mi | 3,232 | $2,165 | 1093.7 |
99% excess
|
| 25 | Kenneth Lancara | 33 | 3,274 | $2,194 | 99.2 mi | 66 mi | 2,179 | $1,460 | 99.2 |
67% excess
|
| 26 | Luis Iser | 14 | 2,628 | $1,761 | 187.7 mi | 176.3 mi | 2,468 | $1,654 | 187.7 |
94% excess
|
| 27 | Horace Barnes | 34 | 2,480 | $1,662 | 72.9 mi | 67.2 mi | 2,286 | $1,532 | 72.9 |
92% excess
|
| 28 | Todd Fogiel | 13 | 2,368 | $1,587 | 182.1 mi | 73.5 mi | 955 | $640 | 182.2 |
40% excess
|
| 29 | Scott A Berry | 5 | 2,229 | $1,493 | 445.8 mi | 428.2 mi | 2,141 | $1,434 | 445.8 |
96% excess
|
| 30 | Jackson Reeves | 15 | 2,172 | $1,455 | 144.8 mi | 35.2 mi | 528 | $354 | 144.8 |
24% excess
|