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 | Fernando Lemos | 18 | 31,382 | $21,026 | 1743.4 mi | 1734.7 mi | 31,224 | $20,920 | 1743.4 |
99% excess
|
| 2 | Side Kick Technician | 27 | 10,652 | $7,137 | 394.5 mi | 387.1 mi | 10,452 | $7,003 | 394.5 |
98% excess
|
| 3 | Christopher Carroll | 16 | 10,495 | $7,032 | 656 mi | 598.3 mi | 9,573 | $6,414 | 655.9 |
91% excess
|
| 4 | Kevin Cogdill | 19 | 4,406 | $2,952 | 231.9 mi | 217.5 mi | 4,132 | $2,768 | 231.9 |
94% excess
|
| 5 | Rozier Cole | 13 | 3,945 | $2,643 | 303.4 mi | 267.2 mi | 3,474 | $2,328 | 303.5 |
88% excess
|
| 6 | Jennifer Johnson | 3 | 3,281 | $2,198 | 1093.8 mi | 1077.3 mi | 3,232 | $2,165 | 1093.7 |
99% excess
|
| 7 | Kenneth Lancara | 33 | 3,274 | $2,194 | 99.2 mi | 66 mi | 2,179 | $1,460 | 99.2 |
67% excess
|
| 8 | Yves Dessin | 3 | 2,017 | $1,351 | 672.2 mi | 663.5 mi | 1,990 | $1,333 | 672.3 |
99% excess
|
| 9 | David Hernandez | 36 | 1,169 | $783 | 32.5 mi | 18.7 mi | 673 | $451 | 32.5 |
58% excess
|
| 10 | Joe Evans | 10 | 1,165 | $781 | 116.5 mi | 103.2 mi | 1,032 | $691 | 116.5 |
89% excess
|
| 11 | Pete Ramos | 25 | 1,165 | $781 | 46.6 mi | 31.9 mi | 797 | $534 | 46.6 |
68% excess
|
| 12 | Carlos Robles | 71 | 635 | $425 | 8.9 mi | 6.7 mi | 476 | $319 | 8.9 |
75% excess
|
| 13 | Chane Lacy | 3 | 570 | $382 | 190 mi | 186.3 mi | 559 | $375 | 190 |
98% excess
|
| 14 | Jon Sanchez | 44 | 513 | $344 | 11.7 mi | 0 mi | 2 | $1 | 11.7 |
0% excess
|
| 15 | Mark Stelter | 11 | 414 | $277 | 37.6 mi | 0 mi | 0 | $0 | 37.6 |
0% excess
|
| 16 | Xiraiyah Coston | 16 | 402 | $269 | 25.1 mi | 0 mi | 0 | $0 | 25.1 |
0% excess
|
| 17 | Franco Jackson | 22 | 316 | $212 | 14.4 mi | 1.8 mi | 40 | $27 | 14.4 |
13% excess
|
| 18 | Daniel Clark | 21 | 226 | $151 | 10.8 mi | 0 mi | 0 | $0 | 10.8 |
0% excess
|
| 19 | Jim Kingery | 3 | 165 | $111 | 55 mi | 54.4 mi | 163 | $109 | 55 |
99% excess
|
| 20 | Torre Gifford | 1 | 79 | $53 | 78.6 mi | 67.9 mi | 68 | $46 | 79 |
86% excess
|
| 21 | Matthew Sebzda | 3 | 64 | $43 | 21.3 mi | 6.1 mi | 18 | $12 | 21.3 |
28% excess
|