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 | 56 | 7,862 | $5,268 | 140.4 mi | 79.5 mi | 4,451 | $2,982 | 140.4 |
57% excess
|
| 2 | Curtis Sprague | 1 | 577 | $387 | 576.6 mi | 371.7 mi | 372 | $249 | 577 |
64% excess
|
| 3 | Craig Walker | 2 | 294 | $197 | 147.2 mi | 6.0 mi | 12 | $8 | 147 |
4% excess
|
| 4 | Michael Swingle | 1 | 148 | $99 | 147.6 mi | 110.3 mi | 110 | $74 | 148 |
74% excess
|