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 | Tyler Bollman | 204 | 22,394 | $15,004 | 109.8 mi | 4.4 mi | 895 | $600 | 109.8 |
4% excess
|
| 2 | Andrew Przybyla | 101 | 5,730 | $3,839 | 56.7 mi | 28.7 mi | 2,900 | $1,943 | 56.7 |
51% excess
|
| 3 | Brendan Chaney | 2 | 3,234 | $2,167 | 1616.8 mi | 1610.7 mi | 3,221 | $2,158 | 1617 |
100% excess
|
| 4 | Brandon Rodriguez | 5 | 2,962 | $1,985 | 592.4 mi | 592.4 mi | 2,962 | $1,985 | 592.4 |
100% excess
|
| 5 | Minh Huynh | 1 | 2,255 | $1,511 | 2255.3 mi | 2244.9 mi | 2,245 | $1,504 | 2255 |
100% excess
|
| 6 | Michael Russell | 1 | 95 | $64 | 94.6 mi | 0.0 mi | 0 | $0 | 95 |
0% excess
|