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 | Michael Swingle | 14 | 10,196 | $6,831 | 728.3 mi | 710.3 mi | 9,944 | $6,662 | 728.3 |
98% excess
|
| 2 | Nkosi Wilson | 14 | 8,949 | $5,996 | 639.2 mi | 617.0 mi | 8,639 | $5,788 | 639.2 |
97% excess
|
| 3 | Alberto Galan | 85 | 8,454 | $5,664 | 99.5 mi | 93.2 mi | 7,920 | $5,306 | 99.5 |
94% excess
|
| 4 | Philip Krogstad | 207 | 8,113 | $5,436 | 39.2 mi | 18.7 mi | 3,863 | $2,588 | 39.2 |
48% excess
|
| 5 | Michael Steencken | 108 | 6,850 | $4,590 | 63.4 mi | 30.5 mi | 3,299 | $2,210 | 63.4 |
48% excess
|
| 6 | Rozier Cole | 10 | 5,116 | $3,428 | 511.6 mi | 433.8 mi | 4,338 | $2,906 | 511.6 |
85% excess
|
| 7 | Pete Ramos | 95 | 5,056 | $3,388 | 53.2 mi | 31.1 mi | 2,951 | $1,977 | 53.2 |
58% excess
|
| 8 | Fanfan Siku | 86 | 4,574 | $3,065 | 53.2 mi | 2.6 mi | 223 | $149 | 53.2 |
5% excess
|
| 9 | Bryan Rodriguez | 44 | 4,326 | $2,898 | 98.3 mi | 73.9 mi | 3,250 | $2,178 | 98.3 |
75% excess
|
| 10 | Megan Allen | 3 | 4,286 | $2,872 | 1428.8 mi | 1410.8 mi | 4,232 | $2,835 | 1428.7 |
99% excess
|
| 11 | Luis Iser | 4 | 4,155 | $2,784 | 1038.8 mi | 1025.9 mi | 4,104 | $2,750 | 1038.8 |
99% excess
|
| 12 | Maximilian Tucker | 98 | 3,931 | $2,634 | 40.1 mi | 11.8 mi | 1,155 | $774 | 40.1 |
29% excess
|
| 13 | Chris Galasso | 105 | 3,745 | $2,509 | 35.7 mi | 6.5 mi | 680 | $456 | 35.7 |
18% excess
|
| 14 | Fady Messak | 22 | 3,713 | $2,488 | 168.8 mi | 114.7 mi | 2,524 | $1,691 | 168.8 |
68% excess
|
| 15 | Konstantin Barskiy | 31 | 3,382 | $2,266 | 109.1 mi | 87.9 mi | 2,726 | $1,826 | 109.1 |
81% excess
|
| 16 | Brandon Green | 67 | 3,115 | $2,087 | 46.5 mi | -0.2 mi | 87 | $58 | 46.5 |
3% excess
|
| 17 | Davon Cox | 26 | 2,791 | $1,870 | 107.3 mi | 83.9 mi | 2,181 | $1,461 | 107.3 |
78% excess
|
| 18 | Jason Yenser | 74 | 2,759 | $1,849 | 37.3 mi | 13.1 mi | 971 | $651 | 37.3 |
35% excess
|
| 19 | Rodney Charles | 78 | 2,230 | $1,494 | 28.6 mi | 7.3 mi | 571 | $383 | 28.6 |
26% excess
|
| 20 | Rick Charles | 73 | 2,137 | $1,432 | 29.3 mi | 7.6 mi | 557 | $373 | 29.3 |
26% excess
|
| 21 | Pero Popovic | 45 | 2,119 | $1,420 | 47.1 mi | 38.8 mi | 1,746 | $1,170 | 47.1 |
82% excess
|
| 22 | Shady Messak | 26 | 1,719 | $1,152 | 66.1 mi | 44.1 mi | 1,147 | $768 | 66.1 |
67% excess
|
| 23 | Ronnie Salone | 2 | 1,676 | $1,123 | 837.9 mi | 0.0 mi | 0 | $0 | 838 |
0% excess
|
| 24 | Eric Mancerella | 33 | 1,662 | $1,114 | 50.4 mi | 17.6 mi | 580 | $389 | 50.4 |
35% excess
|
| 25 | Philmon Mehari | 13 | 1,361 | $912 | 104.7 mi | 79.6 mi | 1,035 | $693 | 104.7 |
76% excess
|
| 26 | Marvin Rivas | 1 | 1,334 | $894 | 1333.5 mi | 1320.8 mi | 1,321 | $885 | 1334 |
99% excess
|
| 27 | Natosha Beierschmitt | 1 | 1,302 | $872 | 1301.7 mi | 1268.8 mi | 1,269 | $850 | 1302 |
97% excess
|
| 28 | Minh Huynh | 4 | 961 | $644 | 240.3 mi | 236.3 mi | 945 | $633 | 240.3 |
98% excess
|
| 29 | Fady Khouzam | 9 | 744 | $498 | 82.6 mi | 66.8 mi | 601 | $403 | 82.7 |
81% excess
|
| 30 | James Duff | 1 | 646 | $433 | 646.0 mi | 643.4 mi | 643 | $431 | 646 |
100% excess
|