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 | 35 | 32,545 | $21,805 | 929.8 mi | 920.4 mi | 32,215 | $21,584 | 929.9 |
99% excess
|
| 2 | Anthony Wright | 154 | 12,405 | $8,311 | 80.6 mi | 50.3 mi | 7,746 | $5,190 | 80.6 |
62% excess
|
| 3 | Kevin Cogdill | 37 | 10,920 | $7,316 | 295.1 mi | 267.7 mi | 9,904 | $6,636 | 295.1 |
91% excess
|
| 4 | Robert Lewis | 145 | 10,879 | $7,289 | 75.0 mi | 21.2 mi | 3,068 | $2,056 | 75 |
28% excess
|
| 5 | Yves Dessin | 64 | 7,797 | $5,224 | 121.8 mi | 91.8 mi | 5,876 | $3,937 | 121.8 |
75% excess
|
| 6 | Robert Rivera | 116 | 7,203 | $4,826 | 62.1 mi | 24.6 mi | 2,852 | $1,911 | 62.1 |
40% excess
|
| 7 | Luis Iser | 28 | 6,454 | $4,324 | 230.5 mi | 221.1 mi | 6,191 | $4,148 | 230.5 |
96% excess
|
| 8 | Joseph Anderson | 105 | 5,655 | $3,789 | 53.9 mi | 23.6 mi | 2,475 | $1,658 | 53.9 |
44% excess
|
| 9 | Kenneth Lancara | 45 | 5,377 | $3,603 | 119.5 mi | 13.7 mi | 618 | $414 | 119.5 |
11% excess
|
| 10 | Craig Walker | 168 | 4,767 | $3,194 | 28.4 mi | 3.6 mi | 611 | $409 | 28.4 |
13% excess
|
| 11 | Rozier Cole | 9 | 3,188 | $2,136 | 354.2 mi | 120.9 mi | 1,088 | $729 | 354.2 |
34% excess
|
| 12 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 13 | Elkin Barahona | 102 | 2,887 | $1,934 | 28.3 mi | 14.1 mi | 1,442 | $966 | 28.3 |
50% excess
|
| 14 | Ray Andreu | 95 | 2,714 | $1,818 | 28.6 mi | 0.4 mi | 35 | $23 | 28.6 |
1% excess
|
| 15 | Dylan Ingraham | 9 | 2,067 | $1,385 | 229.7 mi | 129.2 mi | 1,163 | $779 | 229.7 |
56% excess
|
| 16 | Raymond Ebanks | 4 | 731 | $490 | 182.8 mi | 173.4 mi | 694 | $465 | 182.8 |
95% excess
|
| 17 | David Hernandez | 1 | 673 | $451 | 672.7 mi | 672.7 mi | 673 | $451 | 673 |
100% excess
|
| 18 | Derick Velazquez | 44 | 669 | $448 | 15.2 mi | 5.8 mi | 255 | $171 | 15.2 |
38% excess
|
| 19 | Ryan Lewis | 1 | 437 | $293 | 436.8 mi | 427.4 mi | 427 | $286 | 437 |
98% excess
|
| 20 | Horace Barnes | 6 | 408 | $273 | 68.0 mi | 58.6 mi | 351 | $235 | 68 |
86% excess
|
| 21 | Eric Colon | 1 | 368 | $247 | 368.4 mi | 365.7 mi | 366 | $245 | 368 |
99% excess
|
| 22 | Cynthia G Deville | 1 | 264 | $177 | 263.9 mi | 232.4 mi | 232 | $155 | 264 |
88% excess
|