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 | Rozier Cole | 10 | 3,058 | $2,049 | 305.8 mi | 270.5 mi | 2,705 | $1,812 | 305.8 |
88% excess
|
| 2 | Side Kick Technician | 5 | 2,222 | $1,489 | 444.4 mi | 433.6 mi | 2,168 | $1,453 | 444.4 |
98% excess
|
| 3 | Christopher Carroll | 1 | 737 | $494 | 736.9 mi | 685.2 mi | 685 | $459 | 737 |
93% excess
|
| 4 | David Hernandez | 1 | 673 | $451 | 672.7 mi | 672.7 mi | 673 | $451 | 673 |
100% excess
|
| 5 | Xiraiyah Coston | 10 | 230 | $154 | 23 mi | 0 mi | 0 | $0 | 23 |
0% excess
|
| 6 | Carlos Robles | 2 | 18 | $12 | 9 mi | 6.8 mi | 14 | $9 | 9 |
78% excess
|