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 | Natosha Beierschmitt | 7 | 9,628 | $6,451 | 1375.4 mi | 1334.0 mi | 9,338 | $6,256 | 1375.4 |
97% excess
|
| 2 | Erwin Forster | 35 | 2,019 | $1,353 | 57.7 mi | 1.6 mi | 55 | $37 | 57.7 |
3% excess
|
| 3 | Luis Torres | 13 | 1,461 | $979 | 112.4 mi | 12.3 mi | 160 | $107 | 112.4 |
11% excess
|
| 4 | Darrell Hope | 62 | 1,460 | $978 | 23.5 mi | 3.5 mi | 220 | $147 | 23.5 |
15% excess
|
| 5 | David Trost | 17 | 412 | $276 | 24.3 mi | 6.2 mi | 106 | $71 | 24.2 |
26% excess
|
| 6 | Curtis Allen | 4 | 393 | $263 | 98.3 mi | 11.7 mi | 47 | $31 | 98.3 |
12% excess
|
| 7 | Shawn Rogers | 1 | 96 | $64 | 95.5 mi | -25.2 mi | 0 | $0 | 96 |
0% excess
|
| 8 | Bernard Thompson | 2 | 92 | $62 | 45.9 mi | 25.3 mi | 51 | $34 | 46 |
55% excess
|
| 9 | Taylor Duda | 2 | 39 | $26 | 19.7 mi | 13.4 mi | 27 | $18 | 19.5 |
69% excess
|
| 10 | Darek Kirkpatrick | 1 | 6 | $4 | 5.8 mi | 0.0 mi | 0 | $0 | 6 |
0% excess
|