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 | Fady Messak | 36 | 23,544 | $15,774 | 654.0 mi | 563.8 mi | 20,297 | $13,599 | 654 |
86% excess
|
| 2 | Henry Holmes | 168 | 7,241 | $4,851 | 43.1 mi | 17.3 mi | 2,909 | $1,949 | 43.1 |
40% excess
|
| 3 | Bruce Ballard | 124 | 6,538 | $4,380 | 52.7 mi | 9.0 mi | 1,112 | $745 | 52.7 |
17% excess
|
| 4 | Cynthia G Deville | 135 | 6,170 | $4,134 | 45.7 mi | 13.6 mi | 1,836 | $1,230 | 45.7 |
30% excess
|
| 5 | Torre Gifford | 211 | 5,793 | $3,881 | 27.5 mi | 7.9 mi | 1,674 | $1,122 | 27.5 |
29% excess
|
| 6 | Andre Samuda | 7 | 5,617 | $3,763 | 802.5 mi | 699.0 mi | 4,893 | $3,278 | 802.4 |
87% excess
|
| 7 | Rozier Cole | 31 | 4,826 | $3,233 | 155.7 mi | 77.1 mi | 2,392 | $1,603 | 155.7 |
50% excess
|
| 8 | Dylan Ingraham | 71 | 4,395 | $2,945 | 61.9 mi | 23.2 mi | 1,647 | $1,103 | 61.9 |
37% excess
|
| 9 | Kenneth Lancara | 348 | 3,718 | $2,491 | 10.7 mi | 0.0 mi | 0 | $0 | 10.7 |
0% excess
|
| 10 | Robert Rivera | 9 | 3,442 | $2,306 | 382.5 mi | 280.1 mi | 2,521 | $1,689 | 382.4 |
73% excess
|
| 11 | Kevin Cogdill | 12 | 3,425 | $2,295 | 285.4 mi | 262.8 mi | 3,153 | $2,113 | 285.4 |
92% excess
|
| 12 | Minh Huynh | 3 | 2,730 | $1,829 | 910.1 mi | 897.2 mi | 2,692 | $1,804 | 910 |
99% excess
|
| 13 | Nkosi Wilson | 75 | 2,605 | $1,745 | 34.7 mi | 4.4 mi | 333 | $223 | 34.7 |
13% excess
|
| 14 | Luis Iser | 4 | 2,569 | $1,721 | 642.2 mi | 624.0 mi | 2,496 | $1,672 | 642.3 |
97% excess
|
| 15 | Patricia Gordon | 5 | 1,176 | $788 | 235.1 mi | 128.4 mi | 642 | $430 | 235.2 |
55% excess
|
| 16 | Ronnie Salone | 1 | 970 | $650 | 970.1 mi | 0.0 mi | 0 | $0 | 970 |
0% excess
|
| 17 | Eric Colon | 10 | 918 | $615 | 91.8 mi | 18.6 mi | 186 | $125 | 91.8 |
20% excess
|
| 18 | Matthew Sebzda | 3 | 870 | $583 | 290.1 mi | 280.0 mi | 840 | $563 | 290 |
97% excess
|
| 19 | Bennet O Dartey | 1 | 784 | $525 | 783.5 mi | 139.2 mi | 139 | $93 | 784 |
18% excess
|
| 20 | Brendan Chaney | 2 | 735 | $492 | 367.5 mi | 358.0 mi | 716 | $480 | 367.5 |
97% excess
|
| 21 | Marvin Rivas | 1 | 653 | $438 | 652.8 mi | 589.4 mi | 589 | $395 | 653 |
90% excess
|
| 22 | Robert Lewis | 3 | 580 | $389 | 193.2 mi | 101.1 mi | 303 | $203 | 193.3 |
52% excess
|
| 23 | David Hernandez | 1 | 541 | $362 | 540.5 mi | 530.5 mi | 530 | $355 | 541 |
98% excess
|
| 24 | Praelow Cameron | 2 | 449 | $301 | 224.4 mi | 143.3 mi | 287 | $192 | 224.5 |
64% excess
|
| 25 | Jared Heisler | 2 | 271 | $182 | 135.5 mi | 0.0 mi | 0 | $0 | 135.5 |
0% excess
|
| 26 | Todd Fogiel | 1 | 216 | $145 | 215.9 mi | 137.8 mi | 138 | $92 | 216 |
64% excess
|
| 27 | Craig Walker | 1 | 148 | $99 | 148.5 mi | 0.0 mi | 0 | $0 | 148 |
0% excess
|