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 | Bernard Thompson | 69 | 5,071 | $3,398 | 73.5 mi | 0.0 mi | 0 | $0 | 73.5 |
0% excess
|
| 3 | Pete Ramos | 50 | 2,211 | $1,481 | 44.2 mi | 27.3 mi | 1,367 | $916 | 44.2 |
62% excess
|
| 4 | Paul Bonang Jr | 4 | 281 | $188 | 70.2 mi | 1.0 mi | 4 | $3 | 70.3 |
1% excess
|
| 5 | Jim Kingery | 4 | 220 | $147 | 55.0 mi | 54.4 mi | 217 | $145 | 55 |
99% excess
|
| 6 | Darrell Hope | 6 | 83 | $56 | 13.8 mi | 0.0 mi | 0 | $0 | 13.8 |
0% excess
|
| 7 | Franco Jackson | 1 | 4 | $3 | 3.8 mi | 0.0 mi | 0 | $0 | 4 |
0% excess
|