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 | 80 | 34,630 | $23,202 | 432.9 mi | 341.9 mi | 27,349 | $18,324 | 432.9 |
79% excess
|
| 2 | Andre Samuda | 19 | 17,406 | $11,662 | 916.1 mi | 744.1 mi | 14,139 | $9,473 | 916.1 |
81% excess
|
| 3 | Konstantin Barskiy | 14 | 13,275 | $8,894 | 948.2 mi | 887.3 mi | 12,422 | $8,323 | 948.2 |
94% excess
|
| 4 | April Nuovo | 13 | 13,030 | $8,730 | 1002.3 mi | 834.0 mi | 10,842 | $7,264 | 1002.3 |
83% excess
|
| 5 | Luis Iser | 27 | 8,732 | $5,850 | 323.4 mi | 258.3 mi | 6,975 | $4,673 | 323.4 |
80% excess
|
| 6 | Vivian Hyde | 10 | 7,326 | $4,908 | 732.6 mi | 668.2 mi | 6,682 | $4,477 | 732.6 |
91% excess
|
| 7 | Davon Cox | 9 | 6,613 | $4,431 | 734.8 mi | 574.1 mi | 5,167 | $3,462 | 734.8 |
78% excess
|
| 8 | Patricia Gordon | 20 | 6,393 | $4,283 | 319.6 mi | 295.4 mi | 5,908 | $3,958 | 319.7 |
92% excess
|
| 9 | Allan Klus | 2 | 4,851 | $3,250 | 2425.6 mi | 724.5 mi | 1,449 | $971 | 2425.5 |
30% excess
|
| 10 | Carlos Puebla | 5 | 4,809 | $3,222 | 961.8 mi | 348.5 mi | 1,742 | $1,167 | 961.8 |
36% excess
|
| 11 | Israel Martell | 7 | 4,275 | $2,864 | 610.7 mi | 513.1 mi | 3,592 | $2,407 | 610.7 |
84% excess
|
| 12 | Raymond Ebanks | 21 | 4,109 | $2,753 | 195.7 mi | 156.7 mi | 3,292 | $2,206 | 195.7 |
80% excess
|
| 13 | Nkosi Wilson | 8 | 3,282 | $2,199 | 410.2 mi | 294.0 mi | 2,352 | $1,576 | 410.3 |
72% excess
|
| 14 | Joseph Nuovo | 10 | 2,888 | $1,935 | 288.8 mi | 200.0 mi | 2,000 | $1,340 | 288.8 |
69% excess
|
| 15 | Bennet O Dartey | 3 | 2,679 | $1,795 | 893.1 mi | 145.6 mi | 437 | $293 | 893 |
16% excess
|
| 16 | Douglas Pearce | 1 | 1,546 | $1,036 | 1546.4 mi | 1532.2 mi | 1,532 | $1,026 | 1546 |
99% excess
|
| 17 | Philmon Mehari | 1 | 1,074 | $720 | 1073.8 mi | 974.0 mi | 974 | $653 | 1074 |
91% excess
|
| 18 | Bryan Rodriguez | 3 | 1,062 | $712 | 354.1 mi | 320.8 mi | 963 | $645 | 354 |
91% excess
|
| 19 | Samuel Biddie | 2 | 1,013 | $679 | 506.7 mi | 429.7 mi | 859 | $576 | 506.5 |
85% excess
|
| 20 | Derick Velazquez | 2 | 1,000 | $670 | 499.8 mi | 476.4 mi | 953 | $639 | 500 |
95% excess
|
| 21 | Rick Charles | 1 | 885 | $593 | 885.3 mi | 871.1 mi | 871 | $584 | 885 |
98% excess
|
| 22 | Joe Hudson | 2 | 867 | $581 | 433.7 mi | 418.4 mi | 837 | $561 | 433.5 |
97% excess
|
| 23 | Marvin Rivas | 3 | 647 | $433 | 215.6 mi | 161.4 mi | 484 | $324 | 215.7 |
75% excess
|
| 24 | Fanfan Siku | 7 | 536 | $359 | 76.6 mi | 7.6 mi | 53 | $36 | 76.6 |
10% excess
|
| 25 | Fady Khouzam | 9 | 519 | $348 | 57.7 mi | 30.8 mi | 277 | $186 | 57.7 |
53% excess
|
| 26 | Rodney Charles | 1 | 474 | $318 | 473.8 mi | 469.3 mi | 469 | $314 | 474 |
99% excess
|
| 27 | Shady Messak | 3 | 458 | $307 | 152.6 mi | 137.1 mi | 411 | $275 | 152.7 |
90% excess
|
| 28 | Eric Mancerella | 8 | 408 | $273 | 51.0 mi | 28.8 mi | 231 | $155 | 51 |
57% excess
|
| 29 | Jason Yenser | 3 | 406 | $272 | 135.2 mi | 121.8 mi | 365 | $245 | 135.3 |
90% excess
|
| 30 | Alberto Galan | 8 | 288 | $193 | 36.0 mi | 29.8 mi | 238 | $159 | 36 |
83% excess
|