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 | 388 | 183,475 | $122,928 | 472.9 mi | 407.0 mi | 157,932 | $105,814 | 472.9 |
86% excess
|
| 2 | Marvin Rivas | 324 | 143,885 | $96,403 | 444.1 mi | 163.4 mi | 52,929 | $35,462 | 444.1 |
37% excess
|
| 3 | Philmon Mehari | 256 | 125,378 | $84,003 | 489.8 mi | 427.1 mi | 109,331 | $73,252 | 489.8 |
87% excess
|
| 4 | Bennet O Dartey | 144 | 119,483 | $80,054 | 829.7 mi | 243.9 mi | 35,125 | $23,534 | 829.7 |
29% excess
|
| 5 | Konstantin Barskiy | 153 | 106,550 | $71,389 | 696.4 mi | 633.3 mi | 96,889 | $64,916 | 696.4 |
91% excess
|
| 6 | Ryan Lewis | 195 | 90,114 | $60,376 | 462.1 mi | 296.6 mi | 57,845 | $38,756 | 462.1 |
64% excess
|
| 7 | Nkosi Wilson | 174 | 73,969 | $49,559 | 425.1 mi | 396.1 mi | 68,916 | $46,174 | 425.1 |
93% excess
|
| 8 | Carlos Puebla | 133 | 72,250 | $48,408 | 543.2 mi | 228.9 mi | 30,448 | $20,400 | 543.2 |
42% excess
|
| 9 | Eric Mancerella | 225 | 68,541 | $45,922 | 304.6 mi | 204.0 mi | 45,901 | $30,754 | 304.6 |
67% excess
|
| 10 | Davon Cox | 189 | 58,104 | $38,930 | 307.4 mi | 248.2 mi | 46,914 | $31,432 | 307.4 |
81% excess
|
| 11 | Paul Mccormish | 217 | 55,228 | $37,003 | 254.5 mi | 80.5 mi | 17,465 | $11,702 | 254.5 |
32% excess
|
| 12 | Luis Iser | 205 | 52,849 | $35,409 | 257.8 mi | 218.4 mi | 44,777 | $30,001 | 257.8 |
85% excess
|
| 13 | Allan Klus | 240 | 48,972 | $32,811 | 204.0 mi | 61.6 mi | 14,792 | $9,911 | 204.1 |
30% excess
|
| 14 | Fady Khouzam | 135 | 48,524 | $32,511 | 359.4 mi | 315.2 mi | 42,546 | $28,506 | 359.4 |
88% excess
|
| 15 | Joseph Nuovo | 318 | 47,592 | $31,887 | 149.7 mi | 63.7 mi | 20,261 | $13,575 | 149.7 |
43% excess
|
| 16 | Patricia Gordon | 225 | 41,181 | $27,591 | 183.0 mi | 96.1 mi | 21,618 | $14,484 | 183 |
52% excess
|
| 17 | April Nuovo | 223 | 35,559 | $23,825 | 159.5 mi | 84.8 mi | 18,920 | $12,676 | 159.5 |
53% excess
|
| 18 | Jackson Reeves | 159 | 34,292 | $22,976 | 215.7 mi | 128.5 mi | 20,433 | $13,690 | 215.7 |
60% excess
|
| 19 | Samuel Biddie | 165 | 31,748 | $21,271 | 192.4 mi | 110.5 mi | 18,233 | $12,216 | 192.4 |
57% excess
|
| 20 | Andre Samuda | 326 | 27,034 | $18,113 | 82.9 mi | 58.8 mi | 19,153 | $12,833 | 82.9 |
71% excess
|
| 21 | Bruce Ballard | 185 | 24,908 | $16,688 | 134.6 mi | 61.9 mi | 11,445 | $7,668 | 134.6 |
46% excess
|
| 22 | Rodney Charles | 147 | 23,908 | $16,018 | 162.6 mi | 119.8 mi | 17,615 | $11,802 | 162.6 |
74% excess
|
| 23 | Derick Velazquez | 107 | 23,443 | $15,707 | 219.1 mi | 187.9 mi | 20,105 | $13,470 | 219.1 |
86% excess
|
| 24 | Raymond Ebanks | 160 | 20,645 | $13,832 | 129.0 mi | 98.3 mi | 15,731 | $10,540 | 129 |
76% excess
|
| 25 | Bryan Rodriguez | 201 | 20,265 | $13,578 | 100.8 mi | 56.0 mi | 11,256 | $7,542 | 100.8 |
56% excess
|
| 26 | Shady Messak | 190 | 19,178 | $12,849 | 100.9 mi | 76.9 mi | 14,615 | $9,792 | 100.9 |
76% excess
|
| 27 | Alberto Galan | 306 | 17,733 | $11,881 | 58.0 mi | 44.6 mi | 13,646 | $9,143 | 58 |
77% excess
|
| 28 | Fanfan Siku | 155 | 15,800 | $10,586 | 101.9 mi | 21.7 mi | 3,367 | $2,256 | 101.9 |
21% excess
|
| 29 | Israel Martell | 178 | 15,648 | $10,484 | 87.9 mi | 70.5 mi | 12,541 | $8,402 | 87.9 |
80% excess
|
| 30 | Vivian Hyde | 300 | 13,015 | $8,720 | 43.4 mi | 28.3 mi | 8,497 | $5,693 | 43.4 |
65% excess
|