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 | 33 | 60,810 | $40,743 | 1842.7 mi | 1836.7 mi | 60,611 | $40,609 | 1842.7 |
100% excess
|
| 2 | Yves Dessin | 81 | 54,475 | $36,498 | 672.5 mi | 662.4 mi | 53,651 | $35,946 | 672.5 |
98% excess
|
| 3 | Michael Swingle | 41 | 22,378 | $14,993 | 545.8 mi | 504.9 mi | 20,700 | $13,869 | 545.8 |
93% excess
|
| 4 | Ryan Lewis | 58 | 17,693 | $11,854 | 305 mi | 250.8 mi | 14,547 | $9,746 | 305.1 |
82% excess
|
| 5 | Side Kick Technician | 43 | 16,591 | $11,116 | 385.8 mi | 378.4 mi | 16,271 | $10,902 | 385.8 |
98% excess
|
| 6 | Christopher Carroll | 23 | 15,654 | $10,488 | 680.6 mi | 624.8 mi | 14,369 | $9,627 | 680.6 |
92% excess
|
| 7 | Rozier Cole | 53 | 14,798 | $9,915 | 279.2 mi | 256.2 mi | 13,578 | $9,097 | 279.2 |
92% excess
|
| 8 | Kenneth Lancara | 19 | 10,382 | $6,956 | 546.4 mi | 538.6 mi | 10,234 | $6,857 | 546.4 |
99% excess
|
| 9 | Praelow Cameron | 37 | 7,794 | $5,222 | 210.6 mi | 127.8 mi | 4,730 | $3,169 | 210.6 |
61% excess
|
| 10 | Todd Fogiel | 35 | 5,171 | $3,465 | 147.7 mi | 47.3 mi | 1,657 | $1,110 | 147.7 |
32% excess
|
| 11 | Torre Gifford | 10 | 4,901 | $3,284 | 490.1 mi | 483.5 mi | 4,835 | $3,239 | 490.1 |
99% excess
|
| 12 | Xiraiyah Coston | 158 | 4,539 | $3,041 | 28.7 mi | 0 mi | 0 | $0 | 28.7 |
0% excess
|
| 13 | Jeffrey Coles | 28 | 3,449 | $2,311 | 123.2 mi | 79.1 mi | 2,216 | $1,485 | 123.2 |
64% excess
|
| 14 | Allan Klus | 48 | 3,128 | $2,096 | 65.2 mi | 31.2 mi | 1,497 | $1,003 | 65.2 |
48% excess
|
| 15 | Christopher Morning | 20 | 2,953 | $1,979 | 147.6 mi | 117.3 mi | 2,345 | $1,571 | 147.7 |
79% excess
|
| 16 | Carlos Robles | 197 | 1,741 | $1,166 | 8.8 mi | 6.7 mi | 1,312 | $879 | 8.8 |
75% excess
|
| 17 | Patricia Gordon | 12 | 1,625 | $1,089 | 135.4 mi | 10.2 mi | 123 | $82 | 135.4 |
8% excess
|
| 18 | Jon Sanchez | 143 | 1,433 | $960 | 10 mi | 0 mi | 4 | $3 | 10 |
0% excess
|
| 19 | Fady Messak | 4 | 891 | $597 | 222.7 mi | 189.7 mi | 759 | $509 | 222.8 |
85% excess
|
| 20 | Fady Khouzam | 3 | 859 | $576 | 286.4 mi | 266.4 mi | 799 | $535 | 286.3 |
93% excess
|
| 21 | Joe Hudson | 8 | 800 | $536 | 100 mi | 63.7 mi | 509 | $341 | 100 |
64% excess
|
| 22 | Raymond Ebanks | 1 | 756 | $507 | 755.6 mi | 629.8 mi | 630 | $422 | 756 |
83% excess
|
| 23 | Michael Harris | 5 | 689 | $462 | 137.8 mi | 124.7 mi | 624 | $418 | 137.8 |
91% excess
|
| 24 | Rick Charles | 3 | 676 | $453 | 225.2 mi | 219 mi | 657 | $440 | 225.3 |
97% excess
|
| 25 | David Hernandez | 36 | 496 | $332 | 13.8 mi | 0 mi | 0 | $0 | 13.8 |
0% excess
|
| 26 | Charles Sellon | 1 | 483 | $324 | 483.1 mi | 475.1 mi | 475 | $318 | 483 |
98% excess
|
| 27 | Shawn Kelley | 1 | 396 | $265 | 396.2 mi | 383.9 mi | 384 | $257 | 396 |
97% excess
|
| 28 | Solomon Young | 6 | 135 | $90 | 22.5 mi | 7.1 mi | 43 | $29 | 22.5 |
32% excess
|