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 | 438 | 372,585 | $249,632 | 850.7 mi | 821.8 mi | 359,962 | $241,175 | 850.7 |
97% excess
|
| 2 | Fady Messak | 390 | 188,560 | $126,335 | 483.5 mi | 406.5 mi | 158,554 | $106,231 | 483.5 |
84% excess
|
| 3 | Marvin Rivas | 324 | 143,885 | $96,403 | 444.1 mi | 163.4 mi | 52,929 | $35,462 | 444.1 |
37% excess
|
| 4 | Philmon Mehari | 256 | 125,378 | $84,003 | 489.8 mi | 427.1 mi | 109,331 | $73,252 | 489.8 |
87% excess
|
| 5 | Bennet O Dartey | 159 | 119,860 | $80,306 | 753.8 mi | 221.7 mi | 35,249 | $23,617 | 753.8 |
29% excess
|
| 6 | Yves Dessin | 263 | 118,563 | $79,437 | 450.8 mi | 431.9 mi | 113,589 | $76,105 | 450.8 |
96% excess
|
| 7 | Luis Iser | 482 | 111,031 | $74,391 | 230.4 mi | 203.6 mi | 98,153 | $65,763 | 230.4 |
88% excess
|
| 8 | Natosha Beierschmitt | 105 | 105,497 | $70,683 | 1004.7 mi | 949.8 mi | 99,819 | $66,879 | 1004.7 |
95% excess
|
| 9 | Ryan Lewis | 221 | 101,528 | $68,024 | 459.4 mi | 312.7 mi | 69,105 | $46,300 | 459.4 |
68% excess
|
| 10 | Kevin Cogdill | 311 | 91,239 | $61,130 | 293.4 mi | 279.3 mi | 86,876 | $58,207 | 293.4 |
95% excess
|
| 11 | Praelow Cameron | 367 | 80,424 | $53,884 | 219.1 mi | 163.4 mi | 59,981 | $40,187 | 219.1 |
75% excess
|
| 12 | Nkosi Wilson | 174 | 73,969 | $49,559 | 425.1 mi | 396.1 mi | 68,916 | $46,174 | 425.1 |
93% excess
|
| 13 | Carlos Puebla | 133 | 72,250 | $48,408 | 543.2 mi | 228.9 mi | 30,448 | $20,400 | 543.2 |
42% excess
|
| 14 | Eric Mancerella | 225 | 68,541 | $45,922 | 304.6 mi | 204.0 mi | 45,901 | $30,754 | 304.6 |
67% excess
|
| 15 | Fernando Lemos | 67 | 63,940 | $42,840 | 954.3 mi | 908.4 mi | 60,864 | $40,779 | 954.3 |
95% excess
|
| 16 | Raymond Ebanks | 400 | 61,399 | $41,137 | 153.5 mi | 135.0 mi | 54,000 | $36,180 | 153.5 |
88% excess
|
| 17 | Davon Cox | 191 | 58,104 | $38,930 | 304.2 mi | 245.6 mi | 46,914 | $31,432 | 304.2 |
81% excess
|
| 18 | Christopher Carroll | 116 | 56,474 | $37,838 | 486.8 mi | 445.7 mi | 51,706 | $34,643 | 486.8 |
92% excess
|
| 19 | Minh Huynh | 58 | 55,985 | $37,510 | 965.3 mi | 945.0 mi | 54,812 | $36,724 | 965.3 |
98% excess
|
| 20 | Paul Mccormish | 217 | 55,228 | $37,003 | 254.5 mi | 80.5 mi | 17,465 | $11,702 | 254.5 |
32% excess
|
| 21 | Andrew Przybyla | 150 | 51,721 | $34,653 | 344.8 mi | 308.0 mi | 46,195 | $30,951 | 344.8 |
89% excess
|
| 22 | Joe Evans | 288 | 49,435 | $33,121 | 171.7 mi | 161.0 mi | 46,363 | $31,063 | 171.6 |
94% excess
|
| 23 | Allan Klus | 240 | 48,972 | $32,811 | 204.0 mi | 61.6 mi | 14,792 | $9,911 | 204.1 |
30% excess
|
| 24 | Fady Khouzam | 135 | 48,524 | $32,511 | 359.4 mi | 315.2 mi | 42,546 | $28,506 | 359.4 |
88% excess
|
| 25 | Joseph Nuovo | 318 | 47,592 | $31,887 | 149.7 mi | 63.7 mi | 20,261 | $13,575 | 149.7 |
43% excess
|
| 26 | Kenneth Lancara | 536 | 47,219 | $31,637 | 88.1 mi | 59.5 mi | 31,909 | $21,379 | 88.1 |
68% excess
|
| 27 | Michael Swingle | 184 | 44,087 | $29,538 | 239.6 mi | 198.1 mi | 36,447 | $24,419 | 239.6 |
83% excess
|
| 28 | Jim Kingery | 268 | 41,213 | $27,613 | 153.8 mi | 112.5 mi | 30,153 | $20,203 | 153.8 |
73% excess
|
| 29 | Patricia Gordon | 225 | 41,181 | $27,591 | 183.0 mi | 96.1 mi | 21,618 | $14,484 | 183 |
52% excess
|
| 30 | Rozier Cole | 176 | 38,295 | $25,658 | 217.6 mi | 141.4 mi | 24,891 | $16,677 | 217.6 |
65% excess
|