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 | Konstantin Barskiy | 25 | 23,374 | $15,661 | 935.0 mi | 919.2 mi | 22,980 | $15,397 | 935 |
98% excess
|
| 2 | Fady Messak | 13 | 11,883 | $7,962 | 914.0 mi | 882.9 mi | 11,478 | $7,690 | 914.1 |
97% excess
|
| 3 | Luis Iser | 51 | 10,548 | $7,067 | 206.8 mi | 176.9 mi | 9,020 | $6,043 | 206.8 |
86% excess
|
| 4 | Raymond Ebanks | 45 | 7,700 | $5,159 | 171.1 mi | 152.6 mi | 6,867 | $4,601 | 171.1 |
89% excess
|
| 5 | Douglas Pearce | 1 | 1,546 | $1,036 | 1546.4 mi | 1532.2 mi | 1,532 | $1,026 | 1546 |
99% excess
|
| 6 | Horace Barnes | 22 | 1,371 | $919 | 62.3 mi | 57.2 mi | 1,259 | $844 | 62.3 |
92% excess
|
| 7 | Philmon Mehari | 1 | 1,074 | $720 | 1073.8 mi | 974.0 mi | 974 | $653 | 1074 |
91% excess
|
| 8 | Bryan Rodriguez | 1 | 1,062 | $712 | 1062.3 mi | 962.5 mi | 963 | $645 | 1062 |
91% excess
|
| 9 | Vivian Hyde | 1 | 1,021 | $684 | 1020.9 mi | 1005.4 mi | 1,005 | $673 | 1021 |
98% excess
|
| 10 | Rick Charles | 1 | 885 | $593 | 885.3 mi | 871.1 mi | 871 | $584 | 885 |
98% excess
|
| 11 | Derick Velazquez | 33 | 851 | $570 | 25.8 mi | 9.6 mi | 317 | $212 | 25.8 |
37% excess
|
| 12 | Joe Hudson | 1 | 700 | $469 | 700.0 mi | 697.4 mi | 697 | $467 | 700 |
100% excess
|
| 13 | Marvin Rivas | 1 | 497 | $333 | 496.9 mi | 484.1 mi | 484 | $324 | 497 |
97% excess
|
| 14 | Jared Heisler | 2 | 99 | $66 | 49.4 mi | 0.0 mi | 0 | $0 | 49.5 |
0% excess
|
| 15 | Robert Lewis | 13 | 94 | $63 | 7.2 mi | 1.6 mi | 20 | $13 | 7.2 |
21% excess
|