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 | Patricia Gordon | 8 | 12,031 | $8,061 | 1503.9 mi | 1018.0 mi | 8,144 | $5,456 | 1503.9 |
68% excess
|
| 7 | Derick Velazquez | 13 | 11,103 | $7,439 | 854.1 mi | 839.3 mi | 10,911 | $7,310 | 854.1 |
98% excess
|
| 8 | Fady Khouzam | 5 | 6,885 | $4,613 | 1376.9 mi | 1326.1 mi | 6,630 | $4,442 | 1377 |
96% excess
|
| 9 | Bruce Ballard | 5 | 6,388 | $4,280 | 1277.6 mi | 788.6 mi | 3,943 | $2,642 | 1277.6 |
62% excess
|
| 10 | Shady Messak | 2 | 3,742 | $2,507 | 1870.8 mi | 1381.8 mi | 2,764 | $1,852 | 1871 |
74% excess
|
| 11 | April Nuovo | 2 | 3,443 | $2,307 | 1721.5 mi | 1576.6 mi | 3,153 | $2,113 | 1721.5 |
92% excess
|
| 12 | Luis Iser | 2 | 3,271 | $2,192 | 1635.7 mi | 1146.8 mi | 2,294 | $1,537 | 1635.5 |
70% excess
|
| 13 | Israel Martell | 2 | 2,789 | $1,869 | 1394.5 mi | 1348.1 mi | 2,696 | $1,806 | 1394.5 |
97% excess
|
| 14 | Curtis Sprague | 21 | 2,432 | $1,629 | 115.8 mi | 15.9 mi | 335 | $224 | 115.8 |
14% excess
|
| 15 | Samuel Biddie | 2 | 2,268 | $1,520 | 1134.0 mi | 645.0 mi | 1,290 | $864 | 1134 |
57% excess
|
| 16 | Rick Charles | 1 | 1,824 | $1,222 | 1823.6 mi | 1334.7 mi | 1,335 | $894 | 1824 |
73% excess
|
| 17 | Raymond Ebanks | 1 | 963 | $645 | 963.2 mi | 958.8 mi | 959 | $643 | 963 |
100% excess
|
| 18 | Christopher Womack | 16 | 698 | $468 | 43.6 mi | 0.0 mi | 0 | $0 | 43.6 |
0% excess
|
| 19 | Darrell Hendrix | 1 | 195 | $131 | 195.0 mi | 165.6 mi | 166 | $111 | 195 |
85% excess
|