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 | Michael Swingle | 9 | 6,572 | $4,403 | 730.2 mi | 710.3 mi | 6,393 | $4,283 | 730.2 |
97% excess
|
| 2 | Pete Ramos | 54 | 2,456 | $1,646 | 45.5 mi | 26.4 mi | 1,426 | $955 | 45.5 |
58% excess
|
| 3 | Erwin Forster | 4 | 525 | $352 | 131.4 mi | 31.4 mi | 125 | $84 | 131.3 |
24% excess
|
| 4 | Darrell Hope | 5 | 468 | $314 | 93.5 mi | 18.5 mi | 92 | $62 | 93.6 |
20% excess
|
| 5 | David Trost | 2 | 323 | $216 | 161.5 mi | 57.4 mi | 115 | $77 | 161.5 |
36% excess
|
| 6 | Philip Krogstad | 2 | 71 | $48 | 35.6 mi | 9.6 mi | 19 | $13 | 35.5 |
27% excess
|
| 7 | Maximilian Tucker | 1 | 27 | $18 | 27.2 mi | 0.0 mi | 0 | $0 | 27 |
0% excess
|