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 | Andrew Przybyla | 10 | 14,175 | $9,497 | 1417.5 mi | 1320.4 mi | 13,204 | $8,847 | 1417.5 |
93% excess
|
| 2 | Chris Galasso | 11 | 7,478 | $5,010 | 679.8 mi | 465.1 mi | 5,117 | $3,428 | 679.8 |
68% excess
|
| 3 | Tyler Bollman | 4 | 5,782 | $3,874 | 1445.6 mi | 1330.6 mi | 5,322 | $3,566 | 1445.5 |
92% excess
|
| 4 | Mike Huffman | 18 | 5,282 | $3,539 | 293.5 mi | 163.3 mi | 2,940 | $1,970 | 293.4 |
56% excess
|
| 5 | Franco Jackson | 17 | 4,262 | $2,856 | 250.7 mi | 129.2 mi | 2,197 | $1,472 | 250.7 |
52% excess
|
| 6 | Jon Kuehl | 25 | 3,485 | $2,335 | 139.4 mi | 46.2 mi | 1,154 | $773 | 139.4 |
33% excess
|
| 7 | Emmanuel Morales | 2 | 3,361 | $2,252 | 1680.3 mi | 1599.2 mi | 3,198 | $2,143 | 1680.5 |
95% excess
|
| 8 | Vincent Nyathi | 16 | 2,490 | $1,668 | 155.6 mi | 90.3 mi | 1,444 | $967 | 155.6 |
58% excess
|
| 9 | Natosha Beierschmitt | 3 | 2,388 | $1,600 | 796 mi | 561 mi | 1,683 | $1,128 | 796 |
70% excess
|
| 10 | Kevin Cox | 27 | 2,326 | $1,558 | 86.1 mi | 0 mi | 0 | $0 | 86.1 |
0% excess
|
| 11 | Ed Danek | 1 | 1,779 | $1,192 | 1779.2 mi | 1775.9 mi | 1,776 | $1,190 | 1779 |
100% excess
|
| 12 | Israel Martell | 2 | 1,736 | $1,163 | 867.9 mi | 762.9 mi | 1,526 | $1,022 | 868 |
88% excess
|
| 13 | Blake Ward | 19 | 1,689 | $1,132 | 88.9 mi | 19.2 mi | 365 | $245 | 88.9 |
22% excess
|
| 14 | Michah Brackett | 1 | 1,435 | $961 | 1434.5 mi | 1203.4 mi | 1,203 | $806 | 1435 |
84% excess
|
| 15 | Nicole Floyd | 5 | 1,309 | $877 | 261.8 mi | 260.6 mi | 1,303 | $873 | 261.8 |
100% excess
|
| 16 | Brandon Green | 3 | 1,140 | $764 | 379.9 mi | 140.8 mi | 422 | $283 | 380 |
37% excess
|
| 17 | Shawn Kelley | 1 | 878 | $588 | 878.1 mi | 769.9 mi | 770 | $516 | 878 |
88% excess
|
| 18 | Minh Huynh | 1 | 862 | $578 | 861.7 mi | 851.5 mi | 852 | $571 | 862 |
99% excess
|
| 19 | Christopher Ables | 1 | 530 | $355 | 530 mi | 429.7 mi | 430 | $288 | 530 |
81% excess
|
| 20 | Dustin Antolin | 1 | 465 | $312 | 465.5 mi | 0 mi | 0 | $0 | 465 |
0% excess
|
| 21 | Ronnie Salone | 1 | 341 | $228 | 341.3 mi | 329.2 mi | 329 | $220 | 341 |
96% excess
|
| 22 | Jackson Reeves | 2 | 288 | $193 | 144 mi | 135.5 mi | 271 | $182 | 144 |
94% excess
|
| 23 | Ben McClerklin | 3 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|