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 | Anthony Wright | 87 | 7,373 | $4,940 | 84.8 mi | 55.1 mi | 4,793 | $3,211 | 84.7 |
65% excess
|
| 2 | Kevin Cogdill | 25 | 7,326 | $4,908 | 293 mi | 257.5 mi | 6,438 | $4,313 | 293 |
88% excess
|
| 3 | Kenneth Lancara | 31 | 3,657 | $2,450 | 118 mi | 10.1 mi | 314 | $210 | 118 |
9% excess
|
| 4 | Craig Walker | 110 | 3,594 | $2,408 | 32.7 mi | 5.6 mi | 611 | $409 | 32.7 |
17% excess
|
| 5 | Joseph Anderson | 54 | 3,573 | $2,394 | 66.2 mi | 38 mi | 2,052 | $1,375 | 66.2 |
57% excess
|
| 6 | Rozier Cole | 9 | 3,188 | $2,136 | 354.2 mi | 120.9 mi | 1,088 | $729 | 354.2 |
34% excess
|
| 7 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 8 | Robert Rivera | 58 | 2,857 | $1,914 | 49.3 mi | 15.9 mi | 920 | $616 | 49.3 |
32% excess
|
| 9 | Yves Dessin | 24 | 2,640 | $1,769 | 110 mi | 85.5 mi | 2,052 | $1,375 | 110 |
78% excess
|
| 10 | Robert Lewis | 39 | 2,634 | $1,765 | 67.5 mi | 10.7 mi | 418 | $280 | 67.5 |
16% excess
|
| 11 | Dylan Ingraham | 8 | 1,726 | $1,156 | 215.8 mi | 133.6 mi | 1,069 | $716 | 215.8 |
62% excess
|
| 12 | Elkin Barahona | 56 | 1,600 | $1,072 | 28.6 mi | 15.3 mi | 859 | $576 | 28.6 |
54% excess
|
| 13 | Ray Andreu | 58 | 1,368 | $917 | 23.6 mi | 0.6 mi | 35 | $23 | 23.6 |
3% excess
|
| 14 | Konstantin Barskiy | 1 | 930 | $623 | 929.9 mi | 920.4 mi | 920 | $616 | 930 |
99% excess
|
| 15 | Luis Iser | 3 | 692 | $464 | 230.5 mi | 221.1 mi | 663 | $444 | 230.7 |
96% excess
|
| 16 | David Hernandez | 1 | 673 | $451 | 672.7 mi | 672.7 mi | 673 | $451 | 673 |
100% excess
|
| 17 | Horace Barnes | 6 | 408 | $273 | 68 mi | 58.6 mi | 351 | $235 | 68 |
86% excess
|
| 18 | Eric Colon | 1 | 368 | $247 | 368.4 mi | 365.7 mi | 366 | $245 | 368 |
99% excess
|
| 19 | Raymond Ebanks | 2 | 366 | $245 | 182.8 mi | 173.4 mi | 347 | $232 | 183 |
95% excess
|
| 20 | Derick Velazquez | 23 | 350 | $235 | 15.2 mi | 5.8 mi | 133 | $89 | 15.2 |
38% excess
|
| 21 | Cynthia G Deville | 1 | 264 | $177 | 263.9 mi | 232.4 mi | 232 | $155 | 264 |
88% excess
|