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 | Kenneth Lancara | 33 | 3,777 | $2,531 | 114.4 mi | 45.5 mi | 1,500 | $1,005 | 114.5 |
40% excess
|
| 2 | Minh Huynh | 2 | 2,053 | $1,376 | 1026.7 mi | 980.7 mi | 1,961 | $1,314 | 1026.5 |
96% excess
|
| 3 | Samuel Biddie | 36 | 1,385 | $928 | 38.5 mi | 3.2 mi | 117 | $78 | 38.5 |
8% excess
|
| 4 | Craig Walker | 22 | 1,186 | $795 | 53.9 mi | 3.4 mi | 74 | $50 | 53.9 |
6% excess
|
| 5 | VPD Bench | 1 | 975 | $653 | 974.6 mi | 942.1 mi | 942 | $631 | 975 |
97% excess
|
| 6 | Fady Messak | 1 | 872 | $584 | 872 mi | 829.1 mi | 829 | $555 | 872 |
95% excess
|
| 7 | Cynthia G Deville | 6 | 833 | $558 | 138.8 mi | 66.9 mi | 401 | $269 | 138.8 |
48% excess
|
| 8 | Michael Swingle | 9 | 587 | $393 | 65.3 mi | 5.1 mi | 46 | $31 | 65.2 |
8% excess
|
| 9 | Torre Gifford | 6 | 544 | $364 | 90.7 mi | 1.8 mi | 11 | $7 | 90.7 |
2% excess
|
| 10 | Dylan Ingraham | 4 | 532 | $356 | 132.9 mi | 42.5 mi | 170 | $114 | 133 |
32% excess
|
| 11 | Henry Holmes | 3 | 383 | $257 | 127.8 mi | 105.7 mi | 317 | $212 | 127.7 |
83% excess
|
| 12 | Rozier Cole | 1 | 335 | $224 | 335.4 mi | 13.2 mi | 13 | $9 | 335 |
4% excess
|
| 13 | Jason Cunningham | 2 | 333 | $223 | 166.3 mi | 91.4 mi | 183 | $123 | 166.5 |
55% excess
|
| 14 | Bruce Ballard | 2 | 155 | $104 | 77.3 mi | 0 mi | 0 | $0 | 77.5 |
0% excess
|