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 | Joseph Nuovo | 12 | 12,204 | $8,177 | 1017.0 mi | 997.3 mi | 11,968 | $8,019 | 1017 |
98% excess
|
| 2 | Kenneth Lancara | 62 | 7,082 | $4,745 | 114.2 mi | 45.7 mi | 2,832 | $1,897 | 114.2 |
40% excess
|
| 3 | Cynthia G Deville | 40 | 6,159 | $4,127 | 154.0 mi | 35.8 mi | 1,432 | $959 | 154 |
23% excess
|
| 4 | Vivian Hyde | 5 | 4,194 | $2,810 | 838.8 mi | 785.5 mi | 3,927 | $2,631 | 838.8 |
94% excess
|
| 5 | Elkin Barahona | 6 | 3,389 | $2,271 | 564.8 mi | 496.9 mi | 2,982 | $1,998 | 564.8 |
88% excess
|
| 6 | Samuel Biddie | 86 | 3,363 | $2,253 | 39.1 mi | 8.5 mi | 732 | $490 | 39.1 |
22% excess
|
| 7 | Craig Walker | 40 | 2,690 | $1,802 | 67.2 mi | 1.9 mi | 74 | $50 | 67.3 |
3% excess
|
| 8 | Michael Swingle | 25 | 2,062 | $1,382 | 82.5 mi | 6.1 mi | 152 | $102 | 82.5 |
7% excess
|
| 9 | Minh Huynh | 2 | 2,053 | $1,376 | 1026.7 mi | 980.7 mi | 1,961 | $1,314 | 1026.5 |
96% excess
|
| 10 | Dylan Ingraham | 15 | 1,947 | $1,304 | 129.8 mi | 61.8 mi | 926 | $620 | 129.8 |
48% excess
|
| 11 | Emmanuel Morales | 1 | 1,764 | $1,182 | 1764.1 mi | 1596.0 mi | 1,596 | $1,069 | 1764 |
90% excess
|
| 12 | Jason Cunningham | 7 | 1,422 | $953 | 203.1 mi | 90.3 mi | 632 | $423 | 203.1 |
44% excess
|
| 13 | Charles Sellon | 1 | 1,035 | $693 | 1035.5 mi | 1004.4 mi | 1,004 | $673 | 1035 |
97% excess
|
| 14 | VPD Bench | 1 | 975 | $653 | 974.6 mi | 942.1 mi | 942 | $631 | 975 |
97% excess
|
| 15 | Fady Messak | 1 | 872 | $584 | 872.0 mi | 829.2 mi | 829 | $555 | 872 |
95% excess
|
| 16 | Rozier Cole | 2 | 694 | $465 | 347.0 mi | 6.6 mi | 13 | $9 | 347 |
2% excess
|
| 17 | Torre Gifford | 7 | 629 | $421 | 89.9 mi | 1.5 mi | 11 | $7 | 89.9 |
2% excess
|
| 18 | Henry Holmes | 3 | 378 | $253 | 126.0 mi | 103.9 mi | 312 | $209 | 126 |
83% excess
|
| 19 | Praelow Cameron | 1 | 360 | $241 | 359.8 mi | 230.7 mi | 231 | $155 | 360 |
64% excess
|
| 20 | Bruce Ballard | 3 | 282 | $189 | 94.1 mi | 17.7 mi | 53 | $36 | 94 |
19% excess
|