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 | Andrew Przybyla | 27 | 15,782 | $10,574 | 584.5 mi | 575.6 mi | 15,542 | $10,413 | 584.5 |
98% excess
|
| 2 | Jason Morris | 15 | 14,989 | $10,043 | 999.2 mi | 931.6 mi | 13,973 | $9,362 | 999.3 |
93% excess
|
| 3 | Shawn Kelley | 6 | 10,463 | $7,010 | 1743.9 mi | 1725.0 mi | 10,350 | $6,935 | 1743.8 |
99% excess
|
| 4 | Minh Huynh | 4 | 7,042 | $4,718 | 1760.5 mi | 1749.8 mi | 6,999 | $4,689 | 1760.5 |
99% excess
|
| 5 | Curtis Sprague | 7 | 6,694 | $4,485 | 956.3 mi | 934.0 mi | 6,538 | $4,380 | 956.3 |
98% excess
|
| 6 | Fady Messak | 2 | 3,276 | $2,195 | 1637.9 mi | 1181.7 mi | 2,363 | $1,583 | 1638 |
72% excess
|
| 7 | Marvin Rivas | 3 | 2,585 | $1,732 | 861.5 mi | 838.2 mi | 2,515 | $1,685 | 861.7 |
97% excess
|
| 8 | Michah Brackett | 4 | 2,375 | $1,591 | 593.8 mi | 554.7 mi | 2,219 | $1,487 | 593.8 |
93% excess
|
| 9 | VPD Bench | 1 | 1,766 | $1,183 | 1765.8 mi | 1749.3 mi | 1,749 | $1,172 | 1766 |
99% excess
|
| 10 | Michael Russell | 2 | 1,204 | $807 | 602.0 mi | 599.5 mi | 1,199 | $803 | 602 |
100% excess
|
| 11 | Ben Heinz | 11 | 371 | $249 | 33.7 mi | 0.0 mi | 0 | $0 | 33.7 |
0% excess
|
| 12 | Brandon Rodriguez | 3 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|