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 | Rozier Cole | 10 | 5,116 | $3,428 | 511.6 mi | 433.8 mi | 4,338 | $2,906 | 511.6 |
85% excess
|
| 2 | Michael Steencken | 78 | 4,655 | $3,119 | 59.7 mi | 26.7 mi | 2,086 | $1,398 | 59.7 |
45% excess
|
| 3 | Alberto Galan | 55 | 4,258 | $2,853 | 77.4 mi | 71.1 mi | 3,910 | $2,620 | 77.4 |
92% excess
|
| 4 | Philip Krogstad | 105 | 4,172 | $2,795 | 39.7 mi | 19.5 mi | 2,043 | $1,369 | 39.7 |
49% excess
|
| 5 | Konstantin Barskiy | 31 | 3,382 | $2,266 | 109.1 mi | 87.9 mi | 2,726 | $1,826 | 109.1 |
81% excess
|
| 6 | Maximilian Tucker | 73 | 2,864 | $1,919 | 39.2 mi | 10.8 mi | 790 | $529 | 39.2 |
28% excess
|
| 7 | Fady Messak | 12 | 2,654 | $1,778 | 221.2 mi | 147.6 mi | 1,771 | $1,187 | 221.2 |
67% excess
|
| 8 | Pete Ramos | 58 | 2,596 | $1,739 | 44.8 mi | 26.3 mi | 1,527 | $1,023 | 44.8 |
59% excess
|
| 9 | Jason Yenser | 56 | 2,014 | $1,349 | 36 mi | 11 mi | 616 | $413 | 36 |
31% excess
|
| 10 | Fanfan Siku | 38 | 1,931 | $1,294 | 50.8 mi | 5.6 mi | 212 | $142 | 50.8 |
11% excess
|
| 11 | Pero Popovic | 35 | 1,733 | $1,161 | 49.5 mi | 42.1 mi | 1,473 | $987 | 49.5 |
85% excess
|
| 12 | Brandon Green | 32 | 1,546 | $1,036 | 48.3 mi | 0 mi | 0 | $0 | 48.3 |
0% excess
|
| 13 | Megan Allen | 1 | 1,428 | $957 | 1427.8 mi | 1406.6 mi | 1,407 | $943 | 1428 |
99% excess
|
| 14 | Marvin Rivas | 1 | 1,334 | $894 | 1333.5 mi | 1320.8 mi | 1,321 | $885 | 1334 |
99% excess
|
| 15 | Natosha Beierschmitt | 1 | 1,302 | $872 | 1301.7 mi | 1268.8 mi | 1,269 | $850 | 1302 |
97% excess
|
| 16 | Rodney Charles | 36 | 1,069 | $716 | 29.7 mi | 10.6 mi | 382 | $256 | 29.7 |
36% excess
|
| 17 | Chris Galasso | 42 | 1,039 | $696 | 24.7 mi | 2.1 mi | 89 | $60 | 24.7 |
9% excess
|
| 18 | Ronnie Salone | 1 | 902 | $604 | 902.1 mi | 0 mi | 0 | $0 | 902 |
0% excess
|
| 19 | Eric Mancerella | 25 | 891 | $597 | 35.6 mi | 18.6 mi | 464 | $311 | 35.6 |
52% excess
|
| 20 | Bryan Rodriguez | 7 | 772 | $517 | 110.2 mi | 85 mi | 595 | $399 | 110.3 |
77% excess
|
| 21 | Fady Khouzam | 8 | 652 | $437 | 81.5 mi | 66.4 mi | 531 | $356 | 81.5 |
81% excess
|
| 22 | David Trost | 4 | 646 | $433 | 161.5 mi | 57.4 mi | 229 | $153 | 161.5 |
35% excess
|
| 23 | Rick Charles | 19 | 572 | $383 | 30.1 mi | 9.8 mi | 187 | $125 | 30.1 |
33% excess
|
| 24 | Darrell Hope | 6 | 571 | $383 | 95.1 mi | 17.3 mi | 104 | $70 | 95.2 |
18% excess
|
| 25 | Dustin Antolin | 4 | 389 | $261 | 97.2 mi | 23.7 mi | 95 | $64 | 97.3 |
24% excess
|
| 26 | Davon Cox | 3 | 378 | $253 | 126.1 mi | 99.2 mi | 298 | $200 | 126 |
79% excess
|
| 27 | Carlos Puebla | 2 | 308 | $206 | 153.8 mi | 102.8 mi | 206 | $138 | 154 |
67% excess
|
| 28 | Minh Huynh | 1 | 232 | $155 | 232.1 mi | 229 mi | 229 | $153 | 232 |
99% excess
|
| 29 | Michael Harris | 4 | 168 | $113 | 41.9 mi | 30 mi | 120 | $80 | 42 |
71% excess
|
| 30 | Philmon Mehari | 1 | 115 | $77 | 114.7 mi | 87.8 mi | 88 | $59 | 115 |
77% excess
|