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 | James Duff | 2 | 1,797 | $1,204 | 898.6 mi | 892.8 mi | 1,786 | $1,197 | 898.5 |
99% excess
|
| 2 | Luis Torres | 4 | 307 | $206 | 76.7 mi | 66.9 mi | 268 | $180 | 76.8 |
87% excess
|
| 3 | David Cavaco | 14 | 252 | $169 | 18 mi | 10.5 mi | 147 | $98 | 18 |
58% excess
|
| 4 | Nick O'Neill | 5 | 146 | $98 | 29.2 mi | 22.6 mi | 113 | $76 | 29.2 |
77% excess
|
| 5 | Paul Bonang Jr | 15 | 127 | $85 | 8.5 mi | 0.2 mi | 4 | $3 | 8.5 |
3% excess
|