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 | 256 | 195,696 | $131,116 | 764.4 mi | 746 mi | 190,981 | $127,957 | 764.4 |
98% excess
|
| 2 | Yves Dessin | 164 | 78,606 | $52,666 | 479.3 mi | 466.9 mi | 76,567 | $51,300 | 479.3 |
97% excess
|
| 3 | Fernando Lemos | 63 | 62,364 | $41,784 | 989.9 mi | 962.1 mi | 60,611 | $40,609 | 989.9 |
97% excess
|
| 4 | Kevin Cogdill | 173 | 53,677 | $35,964 | 310.3 mi | 295.4 mi | 51,099 | $34,236 | 310.3 |
95% excess
|
| 5 | Philmon Mehari | 120 | 51,686 | $34,630 | 430.7 mi | 380.4 mi | 45,648 | $30,584 | 430.7 |
88% excess
|
| 6 | Luis Iser | 297 | 47,173 | $31,606 | 158.8 mi | 136.5 mi | 40,536 | $27,159 | 158.8 |
86% excess
|
| 7 | Fady Messak | 110 | 46,836 | $31,380 | 425.8 mi | 335.5 mi | 36,904 | $24,726 | 425.8 |
79% excess
|
| 8 | Marvin Rivas | 165 | 42,483 | $28,464 | 257.5 mi | 141.2 mi | 23,291 | $15,605 | 257.5 |
55% excess
|
| 9 | Eric Mancerella | 114 | 37,744 | $25,288 | 331.1 mi | 222.3 mi | 25,343 | $16,980 | 331.1 |
67% excess
|
| 10 | Raymond Ebanks | 250 | 36,681 | $24,576 | 146.7 mi | 129 mi | 32,254 | $21,610 | 146.7 |
88% excess
|
| 11 | Nkosi Wilson | 72 | 34,907 | $23,388 | 484.8 mi | 464.4 mi | 33,436 | $22,402 | 484.8 |
96% excess
|
| 12 | Natosha Beierschmitt | 34 | 32,070 | $21,487 | 943.2 mi | 882.1 mi | 30,032 | $20,121 | 943.2 |
94% excess
|
| 13 | Rozier Cole | 119 | 29,603 | $19,834 | 248.8 mi | 180.8 mi | 21,516 | $14,416 | 248.8 |
73% excess
|
| 14 | Michael Swingle | 116 | 29,519 | $19,778 | 254.5 mi | 214.5 mi | 24,888 | $16,675 | 254.5 |
84% excess
|
| 15 | Christopher Carroll | 51 | 28,798 | $19,295 | 564.7 mi | 527.1 mi | 26,881 | $18,010 | 564.7 |
93% excess
|
| 16 | Andrew Przybyla | 62 | 28,165 | $18,871 | 454.3 mi | 414.4 mi | 25,693 | $17,214 | 454.3 |
91% excess
|
| 17 | Davon Cox | 107 | 27,589 | $18,485 | 257.8 mi | 218.4 mi | 23,370 | $15,658 | 257.8 |
85% excess
|
| 18 | Ryan Lewis | 95 | 26,607 | $17,827 | 280.1 mi | 194.5 mi | 18,478 | $12,380 | 280.1 |
69% excess
|
| 19 | Ben Heinz | 82 | 26,149 | $17,520 | 318.9 mi | 309 mi | 25,334 | $16,974 | 318.9 |
97% excess
|
| 20 | Kenneth Lancara | 272 | 25,837 | $17,311 | 95 mi | 64.7 mi | 17,611 | $11,799 | 95 |
68% excess
|
| 21 | Joe Evans | 151 | 25,808 | $17,291 | 170.9 mi | 160.4 mi | 24,214 | $16,223 | 170.9 |
94% excess
|
| 22 | Derick Velazquez | 480 | 24,776 | $16,600 | 51.6 mi | 34.7 mi | 16,646 | $11,153 | 51.6 |
67% excess
|
| 23 | Minh Huynh | 24 | 24,165 | $16,191 | 1006.9 mi | 986.5 mi | 23,675 | $15,862 | 1006.9 |
98% excess
|
| 24 | Bennet O Dartey | 66 | 22,691 | $15,203 | 343.8 mi | 201.7 mi | 13,310 | $8,918 | 343.8 |
59% excess
|
| 25 | Praelow Cameron | 164 | 22,377 | $14,993 | 136.4 mi | 66 mi | 10,830 | $7,256 | 136.4 |
48% excess
|
| 26 | Jim Kingery | 103 | 21,359 | $14,311 | 207.4 mi | 144.1 mi | 14,839 | $9,942 | 207.4 |
69% excess
|
| 27 | Tyler Bollman | 100 | 19,990 | $13,393 | 199.9 mi | 86.4 mi | 8,639 | $5,788 | 199.9 |
43% excess
|
| 28 | Fady Khouzam | 103 | 19,020 | $12,743 | 184.7 mi | 159.7 mi | 16,453 | $11,024 | 184.7 |
87% excess
|
| 29 | James Duff | 40 | 18,213 | $12,203 | 455.3 mi | 430.7 mi | 17,229 | $11,543 | 455.3 |
95% excess
|
| 30 | Patricia Gordon | 123 | 18,088 | $12,119 | 147.1 mi | 75.2 mi | 9,249 | $6,197 | 147.1 |
51% excess
|