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 | Jason Cunningham | 24 | 3,693 | $2,474 | 153.9 mi | 77.2 mi | 1,852 | $1,241 | 153.9 |
50% excess
|
| 2 | Minh Huynh | 1 | 1,184 | $793 | 1184.5 mi | 1138.7 mi | 1,139 | $763 | 1184 |
96% excess
|
| 3 | Curtis Sprague | 1 | 577 | $387 | 576.6 mi | 371.7 mi | 372 | $249 | 577 |
64% excess
|
| 4 | Craig Walker | 2 | 294 | $197 | 147.2 mi | 6 mi | 12 | $8 | 147 |
4% excess
|
| 5 | Michael Swingle | 1 | 148 | $99 | 147.6 mi | 110.3 mi | 110 | $74 | 148 |
74% excess
|