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 Nuovo | 55 | 7,004 | $4,693 | 127.3 mi | 16.8 mi | 926 | $620 | 127.3 |
13% excess
|
| 3 | Natosha Beierschmitt | 2 | 3,139 | $2,103 | 1569.5 mi | 1416.4 mi | 2,833 | $1,898 | 1569.5 |
90% excess
|
| 4 | Paul Bonang Jr | 26 | 2,763 | $1,851 | 106.3 mi | 4.5 mi | 116 | $78 | 106.3 |
4% excess
|
| 5 | Joseph Anderson | 2 | 2,570 | $1,722 | 1285.1 mi | 1268.6 mi | 2,537 | $1,700 | 1285 |
99% excess
|
| 6 | April Nuovo | 27 | 2,368 | $1,587 | 87.7 mi | 9.3 mi | 250 | $168 | 87.7 |
11% excess
|
| 7 | Arturo Diaz | 1 | 1,595 | $1,069 | 1594.9 mi | 1593.3 mi | 1,593 | $1,067 | 1595 |
100% excess
|
| 8 | Jason Cunningham | 1 | 1,412 | $946 | 1411.7 mi | 1403.7 mi | 1,404 | $941 | 1412 |
99% excess
|
| 9 | Fady Messak | 5 | 1,275 | $854 | 255.0 mi | 124.4 mi | 622 | $417 | 255 |
49% excess
|
| 10 | Luis Torres | 6 | 851 | $570 | 141.8 mi | 24.9 mi | 150 | $101 | 141.8 |
18% excess
|
| 11 | Mohamed Shareed | 3 | 537 | $360 | 179.0 mi | 177.5 mi | 532 | $356 | 179 |
99% excess
|
| 12 | David Cavaco | 5 | 426 | $285 | 85.1 mi | 69.9 mi | 349 | $234 | 85.2 |
82% excess
|
| 13 | Shady Messak | 1 | 289 | $194 | 288.7 mi | 131.3 mi | 131 | $88 | 289 |
45% excess
|
| 14 | Nick O'Neill | 3 | 286 | $192 | 95.3 mi | 83.7 mi | 251 | $168 | 95.3 |
88% excess
|
| 15 | Bernard Thompson | 1 | 212 | $142 | 212.4 mi | 129.3 mi | 129 | $86 | 212 |
61% excess
|
| 16 | Minh Huynh | 3 | 211 | $141 | 70.4 mi | 53.3 mi | 160 | $107 | 70.3 |
76% excess
|
| 17 | Tim Dinh | 1 | 42 | $28 | 42.0 mi | 41.7 mi | 42 | $28 | 42 |
100% excess
|
| 18 | VPD Bench | 1 | 39 | $26 | 38.8 mi | 28.2 mi | 28 | $19 | 39 |
72% excess
|