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 | 247 | 72,146 | $48,338 | 292.1 mi | 277.2 mi | 68,459 | $45,868 | 292.1 |
95% excess
|
| 2 | Yves Dessin | 143 | 39,834 | $26,689 | 278.6 mi | 260.1 mi | 37,191 | $24,918 | 278.6 |
93% excess
|
| 3 | Joe Evans | 202 | 35,285 | $23,641 | 174.7 mi | 163.6 mi | 33,057 | $22,148 | 174.7 |
94% excess
|
| 4 | Konstantin Barskiy | 35 | 32,545 | $21,805 | 929.8 mi | 920.4 mi | 32,215 | $21,584 | 929.9 |
99% excess
|
| 5 | Kenneth Lancara | 442 | 19,139 | $12,823 | 43.3 mi | 15.1 mi | 6,660 | $4,462 | 43.3 |
35% excess
|
| 6 | Anthony Wright | 154 | 12,405 | $8,311 | 80.6 mi | 50.3 mi | 7,746 | $5,190 | 80.6 |
62% excess
|
| 7 | Christopher Carroll | 21 | 12,371 | $8,289 | 589.1 mi | 556.1 mi | 11,677 | $7,824 | 589.1 |
94% excess
|
| 8 | Jason Cunningham | 109 | 11,473 | $7,687 | 105.3 mi | 50.9 mi | 5,548 | $3,717 | 105.3 |
48% excess
|
| 9 | Robert Lewis | 147 | 11,229 | $7,523 | 76.4 mi | 22.3 mi | 3,273 | $2,193 | 76.4 |
29% excess
|
| 10 | Robert Rivera | 125 | 10,645 | $7,132 | 85.2 mi | 43.0 mi | 5,373 | $3,600 | 85.2 |
50% excess
|
| 11 | Torre Gifford | 165 | 9,662 | $6,474 | 58.6 mi | 37.7 mi | 6,228 | $4,173 | 58.6 |
64% excess
|
| 12 | Cynthia G Deville | 107 | 9,597 | $6,430 | 89.7 mi | 24.9 mi | 2,660 | $1,782 | 89.7 |
28% excess
|
| 13 | Dylan Ingraham | 92 | 8,219 | $5,507 | 89.3 mi | 40.2 mi | 3,700 | $2,479 | 89.3 |
45% excess
|
| 14 | Craig Walker | 208 | 7,787 | $5,217 | 37.4 mi | 4.0 mi | 836 | $560 | 37.4 |
11% excess
|
| 15 | Rozier Cole | 30 | 6,857 | $4,594 | 228.6 mi | 105.0 mi | 3,151 | $2,111 | 228.6 |
46% excess
|
| 16 | Henry Holmes | 146 | 6,849 | $4,589 | 46.9 mi | 20.9 mi | 3,048 | $2,042 | 46.9 |
45% excess
|
| 17 | Luis Iser | 28 | 6,454 | $4,324 | 230.5 mi | 221.1 mi | 6,191 | $4,148 | 230.5 |
96% excess
|
| 18 | Elkin Barahona | 108 | 6,275 | $4,204 | 58.1 mi | 41.0 mi | 4,424 | $2,964 | 58.1 |
71% excess
|
| 19 | Joseph Anderson | 105 | 5,655 | $3,789 | 53.9 mi | 23.6 mi | 2,475 | $1,658 | 53.9 |
44% excess
|
| 20 | Ray-Anthony Alston | 317 | 5,634 | $3,775 | 17.8 mi | 2.8 mi | 896 | $600 | 17.8 |
16% excess
|
| 21 | Philip Krogstad | 3 | 3,125 | $2,094 | 1041.8 mi | 1037.2 mi | 3,112 | $2,085 | 1041.7 |
100% excess
|
| 22 | Matthew Sebzda | 93 | 3,010 | $2,017 | 32.4 mi | 21.1 mi | 1,961 | $1,314 | 32.4 |
65% excess
|
| 23 | Ray Andreu | 95 | 2,714 | $1,818 | 28.6 mi | 0.4 mi | 35 | $23 | 28.6 |
1% excess
|
| 24 | Daniel Clark | 177 | 2,348 | $1,573 | 13.3 mi | 0.0 mi | 0 | $0 | 13.3 |
0% excess
|
| 25 | Dustin Antolin | 7 | 1,962 | $1,315 | 280.2 mi | 219.9 mi | 1,539 | $1,031 | 280.3 |
78% excess
|
| 26 | Michael Swingle | 12 | 1,124 | $753 | 93.7 mi | 17.6 mi | 211 | $141 | 93.7 |
19% excess
|
| 27 | Robert Butler | 3 | 1,007 | $675 | 335.8 mi | 284.3 mi | 853 | $572 | 335.7 |
85% excess
|
| 28 | Raymond Ebanks | 4 | 731 | $490 | 182.8 mi | 173.4 mi | 694 | $465 | 182.8 |
95% excess
|
| 29 | Eric Colon | 4 | 674 | $452 | 168.5 mi | 91.4 mi | 366 | $245 | 168.5 |
54% excess
|
| 30 | David Hernandez | 1 | 673 | $451 | 672.7 mi | 672.7 mi | 673 | $451 | 673 |
100% excess
|