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 | Chris Bakkemo | 24 | 20,798 | $13,935 | 866.6 mi | 859.5 mi | 20,628 | $13,821 | 866.6 |
99% excess
|
| 2 | Maria Davis | 75 | 9,208 | $6,169 | 122.8 mi | 107.6 mi | 8,072 | $5,408 | 122.8 |
88% excess
|
| 3 | Minh Huynh | 4 | 6,632 | $4,443 | 1658.0 mi | 1632.2 mi | 6,529 | $4,374 | 1658 |
98% excess
|
| 4 | Jose Gutierrez | 82 | 5,716 | $3,830 | 69.7 mi | 57.4 mi | 4,705 | $3,152 | 69.7 |
82% excess
|
| 5 | Shawn Kelley | 1 | 1,673 | $1,121 | 1673.0 mi | 1665.8 mi | 1,666 | $1,116 | 1673 |
100% excess
|
| 6 | Curtis Sprague | 7 | 1,430 | $958 | 204.3 mi | 0.0 mi | 0 | $0 | 204.3 |
0% excess
|
| 7 | Ben Heinz | 1 | 380 | $255 | 379.8 mi | 0.0 mi | 0 | $0 | 380 |
0% excess
|
| 8 | Chane Lacy | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|
| 9 | Zachary Stieben | 1 | 0 | $0 | 0.0 mi | 0.0 mi | 0 | $0 | 0 |
0% excess
|