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 | 39 | 36,953 | $24,759 | 947.5 mi | 929.7 mi | 36,259 | $24,294 | 947.5 |
98% excess
|
| 2 | Raymond Ebanks | 39 | 6,272 | $4,202 | 160.8 mi | 150 mi | 5,848 | $3,918 | 160.8 |
93% excess
|
| 3 | Horace Barnes | 28 | 2,046 | $1,371 | 73.1 mi | 67.3 mi | 1,886 | $1,264 | 73.1 |
92% excess
|
| 4 | Joseph Nuovo | 1 | 1,122 | $752 | 1121.5 mi | 1108.6 mi | 1,109 | $743 | 1122 |
99% excess
|
| 5 | Jared Heisler | 6 | 1,095 | $734 | 182.6 mi | 127.4 mi | 764 | $512 | 182.5 |
70% excess
|
| 6 | Fady Messak | 1 | 943 | $632 | 942.8 mi | 862 mi | 862 | $578 | 943 |
91% excess
|
| 7 | Robert Lewis | 81 | 817 | $547 | 10.1 mi | 2.8 mi | 225 | $151 | 10.1 |
28% excess
|
| 8 | Anthony Wright | 9 | 677 | $454 | 75.2 mi | 32.5 mi | 292 | $196 | 75.2 |
43% excess
|
| 9 | David Hernandez | 1 | 673 | $451 | 672.7 mi | 672.7 mi | 673 | $451 | 673 |
100% excess
|
| 10 | Robert Rivera | 27 | 630 | $422 | 23.3 mi | 0 mi | 1 | $1 | 23.3 |
0% excess
|
| 11 | Kenneth Lancara | 5 | 590 | $395 | 118 mi | 10.1 mi | 51 | $34 | 118 |
9% excess
|
| 12 | Derick Velazquez | 87 | 551 | $369 | 6.3 mi | 0.3 mi | 28 | $19 | 6.3 |
5% excess
|
| 13 | Yves Dessin | 5 | 527 | $353 | 105.5 mi | 78.9 mi | 395 | $265 | 105.4 |
75% excess
|
| 14 | Eric Colon | 1 | 368 | $247 | 368.4 mi | 365.7 mi | 366 | $245 | 368 |
99% excess
|
| 15 | Joseph Anderson | 6 | 299 | $200 | 49.8 mi | 7.5 mi | 45 | $30 | 49.8 |
15% excess
|
| 16 | Cynthia G Deville | 1 | 264 | $177 | 263.9 mi | 232.4 mi | 232 | $155 | 264 |
88% excess
|
| 17 | Ray Andreu | 7 | 161 | $108 | 23 mi | 0 mi | 0 | $0 | 23 |
0% excess
|
| 18 | Craig Walker | 5 | 156 | $105 | 31.1 mi | 0 mi | 0 | $0 | 31.2 |
0% excess
|
| 19 | Elkin Barahona | 5 | 147 | $98 | 29.4 mi | 13.1 mi | 66 | $44 | 29.4 |
45% excess
|
| 20 | Luis Iser | 2 | 117 | $78 | 58.6 mi | 0 mi | 0 | $0 | 58.5 |
0% excess
|