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 | Kevin Cogdill | 148 | 45,474 | $30,468 | 307.3 mi | 291.7 mi | 43,173 | $28,926 | 307.3 |
95% excess
|
| 2 | Yves Dessin | 82 | 25,267 | $16,929 | 308.1 mi | 294.6 mi | 24,158 | $16,186 | 308.1 |
96% excess
|
| 3 | Joe Evans | 91 | 15,469 | $10,364 | 170 mi | 158.9 mi | 14,457 | $9,686 | 170 |
93% excess
|
| 4 | Kenneth Lancara | 237 | 12,680 | $8,496 | 53.5 mi | 21.8 mi | 5,175 | $3,467 | 53.5 |
41% excess
|
| 5 | Anthony Wright | 87 | 7,373 | $4,940 | 84.8 mi | 55.1 mi | 4,793 | $3,211 | 84.7 |
65% excess
|
| 6 | Torre Gifford | 46 | 7,016 | $4,701 | 152.5 mi | 134 mi | 6,164 | $4,130 | 152.5 |
88% excess
|
| 7 | Jason Cunningham | 58 | 5,531 | $3,706 | 95.4 mi | 38.4 mi | 2,227 | $1,492 | 95.4 |
40% excess
|
| 8 | Craig Walker | 134 | 5,074 | $3,400 | 37.9 mi | 5.2 mi | 697 | $467 | 37.9 |
14% excess
|
| 9 | Dylan Ingraham | 48 | 4,300 | $2,881 | 89.6 mi | 41.1 mi | 1,974 | $1,323 | 89.6 |
46% excess
|
| 10 | Rozier Cole | 13 | 4,033 | $2,702 | 310.2 mi | 84.7 mi | 1,101 | $738 | 310.2 |
27% excess
|
| 11 | Joseph Anderson | 54 | 3,573 | $2,394 | 66.2 mi | 38 mi | 2,052 | $1,375 | 66.2 |
57% excess
|
| 12 | Ray-Anthony Alston | 179 | 3,376 | $2,262 | 18.9 mi | 4 mi | 715 | $479 | 18.9 |
21% excess
|
| 13 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 14 | Henry Holmes | 62 | 3,119 | $2,090 | 50.3 mi | 18.9 mi | 1,169 | $783 | 50.3 |
37% excess
|
| 15 | Robert Rivera | 58 | 2,857 | $1,914 | 49.3 mi | 15.9 mi | 920 | $616 | 49.3 |
32% excess
|
| 16 | Robert Lewis | 40 | 2,790 | $1,869 | 69.8 mi | 12.8 mi | 512 | $343 | 69.8 |
18% excess
|
| 17 | Cynthia G Deville | 42 | 2,458 | $1,647 | 58.5 mi | 24.8 mi | 1,042 | $698 | 58.5 |
42% excess
|
| 18 | Matthew Sebzda | 77 | 2,437 | $1,633 | 31.7 mi | 20.4 mi | 1,574 | $1,055 | 31.6 |
65% excess
|
| 19 | Elkin Barahona | 56 | 1,600 | $1,072 | 28.6 mi | 15.3 mi | 859 | $576 | 28.6 |
54% excess
|
| 20 | Daniel Clark | 113 | 1,515 | $1,015 | 13.4 mi | 0 mi | 0 | $0 | 13.4 |
0% excess
|
| 21 | Ray Andreu | 58 | 1,368 | $917 | 23.6 mi | 0.6 mi | 35 | $23 | 23.6 |
3% excess
|
| 22 | Konstantin Barskiy | 1 | 930 | $623 | 929.9 mi | 920.4 mi | 920 | $616 | 930 |
99% excess
|
| 23 | Luis Iser | 3 | 692 | $464 | 230.5 mi | 221.1 mi | 663 | $444 | 230.7 |
96% excess
|
| 24 | David Hernandez | 1 | 673 | $451 | 672.7 mi | 672.7 mi | 673 | $451 | 673 |
100% excess
|
| 25 | Christopher Carroll | 1 | 589 | $395 | 589.1 mi | 556.1 mi | 556 | $373 | 589 |
94% excess
|
| 26 | Curtis Sprague | 1 | 577 | $387 | 576.6 mi | 371.7 mi | 372 | $249 | 577 |
64% excess
|
| 27 | Eric Colon | 3 | 535 | $358 | 178.5 mi | 121.9 mi | 366 | $245 | 178.3 |
68% excess
|
| 28 | Michael Swingle | 6 | 480 | $322 | 80 mi | 26.1 mi | 156 | $105 | 80 |
33% excess
|
| 29 | Horace Barnes | 6 | 408 | $273 | 68 mi | 58.6 mi | 351 | $235 | 68 |
86% excess
|
| 30 | Raymond Ebanks | 2 | 366 | $245 | 182.8 mi | 173.4 mi | 347 | $232 | 183 |
95% excess
|