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 | 310 | 91,195 | $61,101 | 294.2 mi | 280.2 mi | 86,876 | $58,207 | 294.2 |
95% excess
|
| 2 | Yves Dessin | 159 | 84,600 | $56,682 | 532.1 mi | 522.3 mi | 83,053 | $55,646 | 532.1 |
98% excess
|
| 3 | Fernando Lemos | 65 | 63,937 | $42,838 | 983.6 mi | 936.4 mi | 60,864 | $40,779 | 983.6 |
95% excess
|
| 4 | Joe Evans | 286 | 49,254 | $33,000 | 172.2 mi | 161.5 mi | 46,196 | $30,951 | 172.2 |
94% excess
|
| 5 | Jim Kingery | 268 | 41,213 | $27,613 | 153.8 mi | 112.5 mi | 30,153 | $20,203 | 153.8 |
73% excess
|
| 6 | Christopher Carroll | 63 | 40,399 | $27,067 | 641.3 mi | 597.5 mi | 37,645 | $25,222 | 641.3 |
93% excess
|
| 7 | Michael Swingle | 65 | 35,434 | $23,741 | 545.1 mi | 510.4 mi | 33,173 | $22,226 | 545.1 |
94% excess
|
| 8 | Kenneth Lancara | 494 | 34,042 | $22,808 | 68.9 mi | 41.4 mi | 20,436 | $13,692 | 68.9 |
60% excess
|
| 9 | Mark Stelter | 166 | 29,688 | $19,891 | 178.8 mi | 121.2 mi | 20,115 | $13,477 | 178.8 |
68% excess
|
| 10 | Side Kick Technician | 60 | 23,374 | $15,661 | 389.6 mi | 380.2 mi | 22,815 | $15,286 | 389.6 |
98% excess
|
| 11 | Jennifer Johnson | 19 | 20,782 | $13,924 | 1093.8 mi | 1077.3 mi | 20,469 | $13,714 | 1093.8 |
98% excess
|
| 12 | Tyler Bollman | 107 | 19,691 | $13,193 | 184.0 mi | 2.9 mi | 305 | $204 | 184 |
2% excess
|
| 13 | Rozier Cole | 64 | 16,799 | $11,255 | 262.5 mi | 241.0 mi | 15,426 | $10,335 | 262.5 |
92% excess
|
| 14 | Justin Armas | 22 | 11,379 | $7,624 | 517.2 mi | 461.9 mi | 10,161 | $6,808 | 517.2 |
89% excess
|
| 15 | Torre Gifford | 163 | 9,457 | $6,336 | 58.0 mi | 38.1 mi | 6,211 | $4,161 | 58 |
66% excess
|
| 16 | Xiraiyah Coston | 176 | 7,180 | $4,811 | 40.8 mi | 13.9 mi | 2,440 | $1,635 | 40.8 |
34% excess
|
| 17 | Ray-Anthony Alston | 384 | 6,654 | $4,458 | 17.3 mi | 2.3 mi | 894 | $599 | 17.3 |
13% excess
|
| 18 | Bernard Thompson | 69 | 5,071 | $3,398 | 73.5 mi | 0.0 mi | 0 | $0 | 73.5 |
0% excess
|
| 19 | Daniel Clark | 280 | 4,971 | $3,331 | 17.8 mi | 0.0 mi | 0 | $0 | 17.8 |
0% excess
|
| 20 | Matthew Sebzda | 146 | 4,168 | $2,793 | 28.5 mi | 17.2 mi | 2,508 | $1,680 | 28.5 |
60% excess
|
| 21 | Pete Ramos | 87 | 3,876 | $2,597 | 44.5 mi | 28.1 mi | 2,441 | $1,635 | 44.6 |
63% excess
|
| 22 | Scott R Roberts | 24 | 3,743 | $2,508 | 156.0 mi | 77.6 mi | 1,862 | $1,248 | 156 |
50% excess
|
| 23 | Franco Jackson | 272 | 3,679 | $2,465 | 13.5 mi | 0.3 mi | 70 | $47 | 13.5 |
2% excess
|
| 24 | Craig Walker | 167 | 2,381 | $1,595 | 14.3 mi | 0.0 mi | 0 | $0 | 14.3 |
0% excess
|
| 25 | David Hernandez | 72 | 2,205 | $1,477 | 30.6 mi | 16.7 mi | 1,203 | $806 | 30.6 |
55% excess
|
| 26 | Carlos Robles | 222 | 1,990 | $1,333 | 9.0 mi | 6.7 mi | 1,496 | $1,002 | 9 |
75% excess
|
| 27 | Jon Sanchez | 178 | 1,679 | $1,125 | 9.4 mi | 0.0 mi | 4 | $3 | 9.4 |
0% excess
|
| 28 | Chane Lacy | 5 | 950 | $637 | 190.0 mi | 186.3 mi | 932 | $624 | 190 |
98% excess
|
| 29 | Michael Harris | 10 | 423 | $283 | 42.3 mi | 0.0 mi | 0 | $0 | 42.3 |
0% excess
|
| 30 | Bennet O Dartey | 15 | 378 | $253 | 25.2 mi | 8.2 mi | 123 | $82 | 25.2 |
33% excess
|