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 | Jim Kingery | 100 | 21,005 | $14,073 | 210.1 mi | 145.6 mi | 14,565 | $9,759 | 210.1 |
69% excess
|
| 2 | Mark Stelter | 113 | 9,458 | $6,337 | 83.7 mi | 19.6 mi | 2,218 | $1,486 | 83.7 |
23% excess
|
| 3 | Scott R Roberts | 24 | 3,743 | $2,508 | 156 mi | 77.6 mi | 1,862 | $1,248 | 156 |
50% excess
|
| 4 | Franco Jackson | 124 | 1,712 | $1,147 | 13.8 mi | 0.6 mi | 70 | $47 | 13.8 |
4% excess
|
| 5 | Jordan Moceri | 1 | 61 | $41 | 61 mi | 45.3 mi | 45 | $30 | 61 |
74% excess
|