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 | Michael Swingle | 18 | 9,595 | $6,429 | 533 mi | 497.4 mi | 8,954 | $5,999 | 533.1 |
93% excess
|
| 2 | Joe Evans | 38 | 6,565 | $4,399 | 172.8 mi | 164 mi | 6,230 | $4,174 | 172.8 |
95% excess
|
| 3 | Christopher Carroll | 8 | 5,747 | $3,850 | 718.4 mi | 669 mi | 5,352 | $3,586 | 718.4 |
93% excess
|
| 4 | Rozier Cole | 21 | 5,112 | $3,425 | 243.4 mi | 199.5 mi | 4,190 | $2,807 | 243.4 |
82% excess
|
| 5 | Xiraiyah Coston | 133 | 4,222 | $2,829 | 31.7 mi | 2.7 mi | 365 | $245 | 31.7 |
9% excess
|
| 6 | Side Kick Technician | 5 | 2,222 | $1,489 | 444.4 mi | 433.6 mi | 2,168 | $1,453 | 444.4 |
98% excess
|
| 7 | Kevin Cogdill | 6 | 2,001 | $1,341 | 333.5 mi | 322.8 mi | 1,937 | $1,298 | 333.5 |
97% excess
|
| 8 | David Hernandez | 2 | 1,213 | $813 | 606.6 mi | 601.6 mi | 1,203 | $806 | 606.5 |
99% excess
|
| 9 | Yves Dessin | 2 | 1,014 | $679 | 507.2 mi | 498 mi | 996 | $667 | 507 |
98% excess
|
| 10 | Michael Harris | 9 | 380 | $255 | 42.3 mi | 0 mi | 0 | $0 | 42.2 |
0% excess
|
| 11 | Matthew Sebzda | 2 | 199 | $133 | 99.3 mi | 90.2 mi | 180 | $121 | 99.5 |
90% excess
|
| 12 | Carlos Robles | 7 | 63 | $42 | 9 mi | 6.8 mi | 48 | $32 | 9 |
76% excess
|
| 13 | Jon Sanchez | 1 | 7 | $5 | 6.7 mi | 0 mi | 0 | $0 | 7 |
0% excess
|