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 | Joseph Anderson | 2 | 2,570 | $1,722 | 1285.1 mi | 1268.6 mi | 2,537 | $1,700 | 1285 |
99% excess
|
| 3 | Arturo Diaz | 1 | 1,595 | $1,069 | 1594.9 mi | 1593.3 mi | 1,593 | $1,067 | 1595 |
100% excess
|
| 4 | Jason Cunningham | 1 | 1,412 | $946 | 1411.7 mi | 1403.7 mi | 1,404 | $941 | 1412 |
99% excess
|
| 5 | Paul Bonang Jr | 7 | 899 | $602 | 128.4 mi | 16.0 mi | 112 | $75 | 128.4 |
12% excess
|
| 6 | Mohamed Shareed | 3 | 537 | $360 | 179.0 mi | 177.5 mi | 532 | $356 | 179 |
99% excess
|
| 7 | David Cavaco | 4 | 331 | $222 | 82.8 mi | 71.7 mi | 287 | $192 | 82.8 |
87% excess
|
| 8 | Nick O'Neill | 3 | 286 | $192 | 95.3 mi | 83.7 mi | 251 | $168 | 95.3 |
88% excess
|
| 9 | Bernard Thompson | 1 | 212 | $142 | 212.4 mi | 129.3 mi | 129 | $86 | 212 |
61% excess
|