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 | James Duff | 8 | 7,515 | $5,035 | 939.4 mi | 927.9 mi | 7,423 | $4,973 | 939.4 |
99% excess
|
| 2 | Paul Bonang Jr | 25 | 2,680 | $1,796 | 107.2 mi | 4.6 mi | 116 | $78 | 107.2 |
4% excess
|
| 3 | Joseph Anderson | 2 | 2,570 | $1,722 | 1285.1 mi | 1268.6 mi | 2,537 | $1,700 | 1285 |
99% excess
|
| 4 | Arturo Diaz | 1 | 1,595 | $1,069 | 1594.9 mi | 1593.3 mi | 1,593 | $1,067 | 1595 |
100% excess
|
| 5 | Jason Cunningham | 1 | 1,412 | $946 | 1411.7 mi | 1403.7 mi | 1,404 | $941 | 1412 |
99% excess
|
| 6 | Luis Torres | 5 | 697 | $467 | 139.4 mi | 24.5 mi | 123 | $82 | 139.4 |
18% excess
|
| 7 | Mohamed Shareed | 3 | 537 | $360 | 179.0 mi | 177.5 mi | 532 | $356 | 179 |
99% excess
|
| 8 | David Cavaco | 5 | 426 | $285 | 85.1 mi | 69.9 mi | 349 | $234 | 85.2 |
82% excess
|
| 9 | Nick O'Neill | 3 | 286 | $192 | 95.3 mi | 83.7 mi | 251 | $168 | 95.3 |
88% excess
|
| 10 | Bernard Thompson | 1 | 212 | $142 | 212.4 mi | 129.3 mi | 129 | $86 | 212 |
61% excess
|