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 | Fady Messak | 50 | 26,184 | $17,543 | 523.7 mi | 447.1 mi | 22,353 | $14,977 | 523.7 |
85% excess
|
| 2 | Patricia Gordon | 19 | 6,235 | $4,177 | 328.1 mi | 310.9 mi | 5,908 | $3,958 | 328.2 |
95% excess
|
| 3 | Konstantin Barskiy | 4 | 2,972 | $1,991 | 742.9 mi | 716 mi | 2,864 | $1,919 | 743 |
96% excess
|
| 4 | Raymond Ebanks | 5 | 1,146 | $768 | 229.2 mi | 193.5 mi | 968 | $649 | 229.2 |
84% excess
|
| 5 | Philmon Mehari | 1 | 1,074 | $720 | 1073.8 mi | 974 mi | 974 | $653 | 1074 |
91% excess
|
| 6 | Bryan Rodriguez | 1 | 1,062 | $712 | 1062.3 mi | 962.5 mi | 963 | $645 | 1062 |
91% excess
|
| 7 | Rick Charles | 1 | 885 | $593 | 885.3 mi | 871.1 mi | 871 | $584 | 885 |
98% excess
|
| 8 | Joe Hudson | 2 | 867 | $581 | 433.7 mi | 418.4 mi | 837 | $561 | 433.5 |
97% excess
|
| 9 | Luis Iser | 11 | 842 | $564 | 76.6 mi | 53.6 mi | 590 | $395 | 76.5 |
70% excess
|
| 10 | Nkosi Wilson | 3 | 770 | $516 | 256.7 mi | 239.5 mi | 719 | $482 | 256.7 |
93% excess
|
| 11 | Rodney Charles | 1 | 474 | $318 | 473.8 mi | 469.3 mi | 469 | $314 | 474 |
99% excess
|
| 12 | Eric Mancerella | 10 | 453 | $304 | 45.3 mi | 26.9 mi | 269 | $180 | 45.3 |
59% excess
|
| 13 | Joseph Nuovo | 4 | 403 | $270 | 100.7 mi | 0 mi | 0 | $0 | 100.8 |
0% excess
|
| 14 | Fady Khouzam | 8 | 325 | $218 | 40.6 mi | 15.7 mi | 126 | $84 | 40.6 |
39% excess
|
| 15 | Alberto Galan | 8 | 288 | $193 | 36 mi | 29.8 mi | 238 | $159 | 36 |
83% excess
|
| 16 | Jackson Reeves | 3 | 238 | $159 | 79.4 mi | 7.7 mi | 23 | $15 | 79.3 |
10% excess
|
| 17 | Fanfan Siku | 4 | 189 | $127 | 47.3 mi | 13.4 mi | 53 | $36 | 47.3 |
28% excess
|
| 18 | Paul Mccormish | 1 | 139 | $93 | 139.3 mi | 134.8 mi | 135 | $90 | 139 |
97% excess
|
| 19 | Marvin Rivas | 1 | 136 | $91 | 135.9 mi | 0 mi | 0 | $0 | 136 |
0% excess
|
| 20 | Davon Cox | 1 | 126 | $84 | 126.1 mi | 99.2 mi | 99 | $66 | 126 |
79% excess
|
| 21 | April Nuovo | 1 | 125 | $84 | 125.4 mi | 97.8 mi | 98 | $66 | 125 |
78% excess
|
| 22 | Jeffrey Coles | 1 | 94 | $63 | 94.2 mi | 0 mi | 0 | $0 | 94 |
0% excess
|
| 23 | Shady Messak | 2 | 87 | $58 | 43.4 mi | 37.2 mi | 74 | $50 | 43.5 |
85% excess
|
| 24 | Derick Velazquez | 1 | 51 | $34 | 50.6 mi | 22.4 mi | 22 | $15 | 51 |
43% excess
|
| 25 | Israel Martell | 1 | 30 | $20 | 29.8 mi | 11.3 mi | 11 | $7 | 30 |
37% excess
|
| 26 | Carlos Puebla | 2 | 27 | $18 | 13.4 mi | 3.6 mi | 7 | $5 | 13.5 |
26% excess
|
| 27 | Bruce Ballard | 1 | 24 | $16 | 23.8 mi | 11.1 mi | 11 | $7 | 24 |
46% excess
|
| 28 | Jared Heisler | 1 | 10 | $7 | 10.2 mi | 0 mi | 0 | $0 | 10 |
0% excess
|
| 29 | Solomon Young | 1 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|