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 | Philmon Mehari | 22 | 32,890 | $22,036 | 1495 mi | 1358.6 mi | 29,890 | $20,026 | 1495 |
91% excess
|
| 2 | Eric Mancerella | 22 | 27,169 | $18,203 | 1235 mi | 1007 mi | 22,153 | $14,843 | 1235 |
82% excess
|
| 3 | Davon Cox | 16 | 21,912 | $14,681 | 1369.5 mi | 1336.2 mi | 21,379 | $14,324 | 1369.5 |
98% excess
|
| 4 | Derick Velazquez | 13 | 11,103 | $7,439 | 854.1 mi | 839.3 mi | 10,911 | $7,310 | 854.1 |
98% excess
|
| 5 | Chris Bakkemo | 12 | 10,399 | $6,967 | 866.6 mi | 859.5 mi | 10,314 | $6,910 | 866.6 |
99% excess
|
| 6 | Chane Lacy | 118 | 10,114 | $6,776 | 85.7 mi | 46.5 mi | 5,485 | $3,675 | 85.7 |
54% excess
|
| 7 | Marvin Rivas | 107 | 9,468 | $6,344 | 88.5 mi | 19.9 mi | 2,125 | $1,424 | 88.5 |
22% excess
|
| 8 | Fady Khouzam | 5 | 6,885 | $4,613 | 1376.9 mi | 1326.1 mi | 6,630 | $4,442 | 1377 |
96% excess
|
| 9 | Arturo Diaz | 58 | 6,712 | $4,497 | 115.7 mi | 77.6 mi | 4,499 | $3,014 | 115.7 |
67% excess
|
| 10 | Maria Davis | 46 | 5,699 | $3,818 | 123.9 mi | 109.7 mi | 5,044 | $3,379 | 123.9 |
89% excess
|
| 11 | Curtis Sprague | 36 | 4,538 | $3,040 | 126.1 mi | 51.4 mi | 1,849 | $1,239 | 126.1 |
41% excess
|
| 12 | Christopher Womack | 104 | 4,442 | $2,976 | 42.7 mi | 10.6 mi | 1,104 | $740 | 42.7 |
25% excess
|
| 13 | Anthony Wirth | 68 | 4,401 | $2,949 | 64.7 mi | 35.5 mi | 2,415 | $1,618 | 64.7 |
55% excess
|
| 14 | Zachary Stieben | 94 | 4,007 | $2,685 | 42.6 mi | 10.6 mi | 993 | $665 | 42.6 |
25% excess
|
| 15 | Minh Huynh | 2 | 3,274 | $2,194 | 1637.1 mi | 1607.2 mi | 3,214 | $2,153 | 1637 |
98% excess
|
| 16 | Darrell Hendrix | 13 | 2,480 | $1,662 | 190.8 mi | 62.6 mi | 814 | $545 | 190.8 |
33% excess
|
| 17 | Jose Gutierrez | 42 | 2,296 | $1,538 | 54.7 mi | 47.1 mi | 1,978 | $1,325 | 54.7 |
86% excess
|
| 18 | Emmanuel Morales | 1 | 1,227 | $822 | 1227.3 mi | 1200.3 mi | 1,200 | $804 | 1227 |
98% excess
|
| 19 | Christopher Carroll | 4 | 1,074 | $720 | 268.5 mi | 268.5 mi | 1,074 | $720 | 268.5 |
100% excess
|
| 20 | Brendan Chaney | 1 | 841 | $563 | 840.8 mi | 805.7 mi | 806 | $540 | 841 |
96% excess
|
| 21 | Scott E Yelverton | 4 | 735 | $492 | 183.7 mi | 154.9 mi | 620 | $415 | 183.8 |
84% excess
|
| 22 | Andrew Przybyla | 1 | 314 | $210 | 314.1 mi | 0 mi | 0 | $0 | 314 |
0% excess
|
| 23 | Natosha Beierschmitt | 4 | 281 | $188 | 70.3 mi | 40.2 mi | 202 | $135 | 70.3 |
72% excess
|
| 24 | Christopher Ables | 1 | 147 | $98 | 147.4 mi | 115.3 mi | 115 | $77 | 147 |
78% excess
|