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 | Bruce Ballard | 83 | 4,734 | $3,172 | 57 mi | 9.9 mi | 822 | $551 | 57 |
17% excess
|
| 2 | Cynthia G Deville | 85 | 3,428 | $2,297 | 40.3 mi | 13 mi | 1,104 | $740 | 40.3 |
32% excess
|
| 3 | Henry Holmes | 65 | 2,989 | $2,003 | 46 mi | 14.3 mi | 930 | $623 | 46 |
31% excess
|
| 4 | Torre Gifford | 54 | 2,311 | $1,548 | 42.8 mi | 28.8 mi | 1,555 | $1,042 | 42.8 |
67% excess
|
| 5 | Dylan Ingraham | 38 | 2,231 | $1,495 | 58.7 mi | 20.3 mi | 770 | $516 | 58.7 |
35% excess
|
| 6 | Fady Messak | 3 | 2,023 | $1,355 | 674.2 mi | 619 mi | 1,857 | $1,244 | 674.3 |
92% excess
|
| 7 | Kenneth Lancara | 169 | 1,805 | $1,209 | 10.7 mi | 0 mi | 0 | $0 | 10.7 |
0% excess
|
| 8 | Minh Huynh | 1 | 977 | $655 | 976.6 mi | 957.7 mi | 958 | $642 | 977 |
98% excess
|
| 9 | Ronnie Salone | 1 | 970 | $650 | 970.1 mi | 0 mi | 0 | $0 | 970 |
0% excess
|
| 10 | Patricia Gordon | 4 | 936 | $627 | 233.9 mi | 104.2 mi | 417 | $279 | 234 |
45% excess
|
| 11 | Rozier Cole | 5 | 895 | $600 | 179 mi | 68.3 mi | 342 | $229 | 179 |
38% excess
|
| 12 | Brendan Chaney | 2 | 735 | $492 | 367.5 mi | 358 mi | 716 | $480 | 367.5 |
97% excess
|
| 13 | Nkosi Wilson | 26 | 665 | $446 | 25.6 mi | 5.1 mi | 132 | $88 | 25.6 |
20% excess
|
| 14 | Marvin Rivas | 1 | 653 | $438 | 652.7 mi | 589.4 mi | 589 | $395 | 653 |
90% excess
|
| 15 | Matthew Sebzda | 2 | 580 | $389 | 290.1 mi | 280 mi | 560 | $375 | 290 |
97% excess
|
| 16 | David Hernandez | 1 | 541 | $362 | 540.5 mi | 530.5 mi | 530 | $355 | 541 |
98% excess
|
| 17 | Eric Colon | 5 | 498 | $334 | 99.7 mi | 35.8 mi | 179 | $120 | 99.6 |
36% excess
|
| 18 | Jared Heisler | 2 | 271 | $182 | 135.5 mi | 0 mi | 0 | $0 | 135.5 |
0% excess
|
| 19 | Praelow Cameron | 1 | 217 | $145 | 216.6 mi | 75 mi | 75 | $50 | 217 |
35% excess
|
| 20 | Todd Fogiel | 1 | 216 | $145 | 215.9 mi | 137.8 mi | 138 | $92 | 216 |
64% excess
|
| 21 | Robert Lewis | 1 | 156 | $105 | 156.3 mi | 94.9 mi | 95 | $64 | 156 |
61% excess
|