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 Steencken | 78 | 4,655 | $3,119 | 59.7 mi | 26.7 mi | 2,086 | $1,398 | 59.7 |
45% excess
|
| 2 | Alberto Galan | 55 | 4,258 | $2,853 | 77.4 mi | 71.1 mi | 3,910 | $2,620 | 77.4 |
92% excess
|
| 3 | Konstantin Barskiy | 31 | 3,382 | $2,266 | 109.1 mi | 87.9 mi | 2,726 | $1,826 | 109.1 |
81% excess
|
| 4 | Fady Messak | 12 | 2,654 | $1,778 | 221.2 mi | 147.6 mi | 1,771 | $1,187 | 221.2 |
67% excess
|
| 5 | Jason Yenser | 56 | 2,014 | $1,349 | 36 mi | 11 mi | 616 | $413 | 36 |
31% excess
|
| 6 | Fanfan Siku | 38 | 1,931 | $1,294 | 50.8 mi | 5.6 mi | 212 | $142 | 50.8 |
11% excess
|
| 7 | Marvin Rivas | 1 | 1,334 | $894 | 1333.5 mi | 1320.8 mi | 1,321 | $885 | 1334 |
99% excess
|
| 8 | Rodney Charles | 36 | 1,069 | $716 | 29.7 mi | 10.6 mi | 382 | $256 | 29.7 |
36% excess
|
| 9 | Eric Mancerella | 25 | 891 | $597 | 35.6 mi | 18.6 mi | 464 | $311 | 35.6 |
52% excess
|
| 10 | Bryan Rodriguez | 7 | 772 | $517 | 110.2 mi | 85 mi | 595 | $399 | 110.3 |
77% excess
|
| 11 | Fady Khouzam | 8 | 652 | $437 | 81.5 mi | 66.4 mi | 531 | $356 | 81.5 |
81% excess
|
| 12 | Rick Charles | 19 | 572 | $383 | 30.1 mi | 9.8 mi | 187 | $125 | 30.1 |
33% excess
|
| 13 | Davon Cox | 3 | 378 | $253 | 126.1 mi | 99.2 mi | 298 | $200 | 126 |
79% excess
|
| 14 | Carlos Puebla | 2 | 308 | $206 | 153.8 mi | 102.8 mi | 206 | $138 | 154 |
67% excess
|
| 15 | Philmon Mehari | 1 | 115 | $77 | 114.7 mi | 87.8 mi | 88 | $59 | 115 |
77% excess
|
| 16 | Shady Messak | 2 | 84 | $56 | 41.9 mi | 32.7 mi | 65 | $44 | 42 |
77% excess
|
| 17 | Jeffrey Coles | 1 | 63 | $42 | 63.5 mi | 0 mi | 0 | $0 | 63 |
0% excess
|