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 | 62 | 93,377 | $62,563 | 1506.1 mi | 1367.7 mi | 84,797 | $56,814 | 1506.1 |
91% excess
|
| 2 | Eric Mancerella | 38 | 43,966 | $29,457 | 1157.0 mi | 1007.8 mi | 38,295 | $25,658 | 1157 |
87% excess
|
| 3 | Davon Cox | 24 | 35,536 | $23,809 | 1480.7 mi | 1351.3 mi | 32,431 | $21,729 | 1480.7 |
91% excess
|
| 4 | Marvin Rivas | 174 | 28,177 | $18,879 | 161.9 mi | 62.4 mi | 10,861 | $7,277 | 161.9 |
39% excess
|
| 5 | Fady Messak | 14 | 21,675 | $14,522 | 1548.2 mi | 1407.1 mi | 19,699 | $13,198 | 1548.2 |
91% excess
|
| 6 | Chris Bakkemo | 24 | 20,798 | $13,935 | 866.6 mi | 859.5 mi | 20,628 | $13,821 | 866.6 |
99% excess
|
| 7 | Chane Lacy | 196 | 16,897 | $11,321 | 86.2 mi | 49.1 mi | 9,628 | $6,451 | 86.2 |
57% excess
|
| 8 | Patricia Gordon | 8 | 12,031 | $8,061 | 1503.9 mi | 1018.0 mi | 8,144 | $5,456 | 1503.9 |
68% excess
|
| 9 | Derick Velazquez | 13 | 11,103 | $7,439 | 854.1 mi | 839.3 mi | 10,911 | $7,310 | 854.1 |
98% excess
|
| 10 | Anthony Wirth | 141 | 9,604 | $6,435 | 68.1 mi | 34.5 mi | 4,864 | $3,259 | 68.1 |
51% excess
|
| 11 | Christopher Womack | 187 | 9,327 | $6,249 | 49.9 mi | 13.6 mi | 2,544 | $1,704 | 49.9 |
27% excess
|
| 12 | Maria Davis | 75 | 9,208 | $6,169 | 122.8 mi | 107.6 mi | 8,072 | $5,408 | 122.8 |
88% excess
|
| 13 | Arturo Diaz | 96 | 8,552 | $5,730 | 89.1 mi | 60.4 mi | 5,798 | $3,885 | 89.1 |
68% excess
|
| 14 | Curtis Sprague | 62 | 6,989 | $4,683 | 112.7 mi | 32.0 mi | 1,983 | $1,329 | 112.7 |
28% excess
|
| 15 | Fady Khouzam | 5 | 6,885 | $4,613 | 1376.9 mi | 1326.1 mi | 6,630 | $4,442 | 1377 |
96% excess
|
| 16 | Minh Huynh | 4 | 6,632 | $4,443 | 1658.0 mi | 1632.2 mi | 6,529 | $4,374 | 1658 |
98% excess
|
| 17 | Zachary Stieben | 152 | 6,520 | $4,368 | 42.9 mi | 11.4 mi | 1,738 | $1,164 | 42.9 |
27% excess
|
| 18 | Bruce Ballard | 5 | 6,388 | $4,280 | 1277.6 mi | 788.6 mi | 3,943 | $2,642 | 1277.6 |
62% excess
|
| 19 | Jose Gutierrez | 82 | 5,716 | $3,830 | 69.7 mi | 57.4 mi | 4,705 | $3,152 | 69.7 |
82% excess
|
| 20 | Shady Messak | 2 | 3,742 | $2,507 | 1870.8 mi | 1381.8 mi | 2,764 | $1,852 | 1871 |
74% excess
|
| 21 | April Nuovo | 2 | 3,443 | $2,307 | 1721.5 mi | 1576.6 mi | 3,153 | $2,113 | 1721.5 |
92% excess
|
| 22 | Luis Iser | 2 | 3,271 | $2,192 | 1635.7 mi | 1146.8 mi | 2,294 | $1,537 | 1635.5 |
70% excess
|
| 23 | Israel Martell | 2 | 2,789 | $1,869 | 1394.5 mi | 1348.1 mi | 2,696 | $1,806 | 1394.5 |
97% excess
|
| 24 | Emmanuel Morales | 2 | 2,429 | $1,627 | 1214.5 mi | 1198.8 mi | 2,398 | $1,607 | 1214.5 |
99% excess
|
| 25 | Darrell Hendrix | 12 | 2,377 | $1,593 | 198.1 mi | 43.6 mi | 523 | $350 | 198.1 |
22% excess
|
| 26 | Samuel Biddie | 2 | 2,268 | $1,520 | 1134.0 mi | 645.0 mi | 1,290 | $864 | 1134 |
57% excess
|
| 27 | Rick Charles | 1 | 1,824 | $1,222 | 1823.6 mi | 1334.7 mi | 1,335 | $894 | 1824 |
73% excess
|
| 28 | Shawn Kelley | 1 | 1,673 | $1,121 | 1673.0 mi | 1665.8 mi | 1,666 | $1,116 | 1673 |
100% excess
|
| 29 | Nicole Floyd | 1 | 1,078 | $722 | 1077.9 mi | 1074.8 mi | 1,075 | $720 | 1078 |
100% excess
|
| 30 | Christopher Carroll | 4 | 1,074 | $720 | 268.5 mi | 268.5 mi | 1,074 | $720 | 268.5 |
100% excess
|