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 | Nkosi Wilson | 14 | 8,949 | $5,996 | 639.2 mi | 617.0 mi | 8,639 | $5,788 | 639.2 |
97% excess
|
| 2 | Alberto Galan | 85 | 8,454 | $5,664 | 99.5 mi | 93.2 mi | 7,920 | $5,306 | 99.5 |
94% excess
|
| 3 | Michael Steencken | 108 | 6,850 | $4,590 | 63.4 mi | 30.5 mi | 3,299 | $2,210 | 63.4 |
48% excess
|
| 4 | Fanfan Siku | 86 | 4,574 | $3,065 | 53.2 mi | 2.6 mi | 223 | $149 | 53.2 |
5% excess
|
| 5 | Bryan Rodriguez | 44 | 4,326 | $2,898 | 98.3 mi | 73.9 mi | 3,250 | $2,178 | 98.3 |
75% excess
|
| 6 | Luis Iser | 4 | 4,155 | $2,784 | 1038.8 mi | 1025.9 mi | 4,104 | $2,750 | 1038.8 |
99% excess
|
| 7 | Fady Messak | 22 | 3,713 | $2,488 | 168.8 mi | 114.7 mi | 2,524 | $1,691 | 168.8 |
68% excess
|
| 8 | Konstantin Barskiy | 31 | 3,382 | $2,266 | 109.1 mi | 87.9 mi | 2,726 | $1,826 | 109.1 |
81% excess
|
| 9 | Davon Cox | 26 | 2,791 | $1,870 | 107.3 mi | 83.9 mi | 2,181 | $1,461 | 107.3 |
78% excess
|
| 10 | Jason Yenser | 74 | 2,759 | $1,849 | 37.3 mi | 13.1 mi | 971 | $651 | 37.3 |
35% excess
|
| 11 | Rodney Charles | 78 | 2,230 | $1,494 | 28.6 mi | 7.3 mi | 571 | $383 | 28.6 |
26% excess
|
| 12 | Rick Charles | 73 | 2,137 | $1,432 | 29.3 mi | 7.6 mi | 557 | $373 | 29.3 |
26% excess
|
| 13 | Shady Messak | 26 | 1,719 | $1,152 | 66.1 mi | 44.1 mi | 1,147 | $768 | 66.1 |
67% excess
|
| 14 | Eric Mancerella | 33 | 1,662 | $1,114 | 50.4 mi | 17.6 mi | 580 | $389 | 50.4 |
35% excess
|
| 15 | Philmon Mehari | 13 | 1,361 | $912 | 104.7 mi | 79.6 mi | 1,035 | $693 | 104.7 |
76% excess
|
| 16 | Marvin Rivas | 1 | 1,334 | $894 | 1333.5 mi | 1320.8 mi | 1,321 | $885 | 1334 |
99% excess
|
| 17 | Fady Khouzam | 9 | 744 | $498 | 82.6 mi | 66.8 mi | 601 | $403 | 82.7 |
81% excess
|
| 18 | Carlos Puebla | 2 | 308 | $206 | 153.8 mi | 102.8 mi | 206 | $138 | 154 |
67% excess
|
| 19 | Andre Samuda | 2 | 183 | $123 | 91.3 mi | 82.5 mi | 165 | $111 | 91.5 |
90% excess
|
| 20 | Israel Martell | 1 | 80 | $54 | 80.4 mi | 61.7 mi | 62 | $42 | 80 |
78% excess
|