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 | Side Kick Technician | 43 | 16,591 | $11,116 | 385.8 mi | 378.4 mi | 16,271 | $10,902 | 385.8 |
98% excess
|
| 5 | Christopher Carroll | 23 | 15,654 | $10,488 | 680.6 mi | 624.8 mi | 14,369 | $9,627 | 680.6 |
92% excess
|
| 6 | Rozier Cole | 52 | 14,477 | $9,700 | 278.4 mi | 257.2 mi | 13,376 | $8,962 | 278.4 |
92% excess
|
| 7 | Kenneth Lancara | 19 | 10,382 | $6,956 | 546.4 mi | 538.6 mi | 10,234 | $6,857 | 546.4 |
99% excess
|
| 8 | Torre Gifford | 10 | 4,901 | $3,284 | 490.1 mi | 483.5 mi | 4,835 | $3,239 | 490.1 |
99% excess
|
| 9 | Xiraiyah Coston | 156 | 4,538 | $3,040 | 29.1 mi | 0 mi | 0 | $0 | 29.1 |
0% excess
|
| 10 | Carlos Robles | 194 | 1,741 | $1,166 | 9 mi | 6.8 mi | 1,312 | $879 | 9 |
75% excess
|
| 11 | Jon Sanchez | 141 | 1,433 | $960 | 10.2 mi | 0 mi | 4 | $3 | 10.2 |
0% excess
|
| 12 | David Hernandez | 35 | 496 | $332 | 14.2 mi | 0 mi | 0 | $0 | 14.2 |
0% excess
|