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 | Joseph Nuovo | 87 | 6,925 | $4,640 | 79.6 mi | 28.0 mi | 2,440 | $1,635 | 79.6 |
35% excess
|
| 2 | April Nuovo | 64 | 5,178 | $3,469 | 80.9 mi | 24.8 mi | 1,586 | $1,063 | 80.9 |
31% excess
|
| 3 | Mohamed Shareed | 62 | 4,385 | $2,938 | 70.7 mi | 53.8 mi | 3,336 | $2,235 | 70.7 |
76% excess
|
| 4 | Edward Arias | 61 | 4,243 | $2,843 | 69.6 mi | 55.4 mi | 3,381 | $2,265 | 69.6 |
80% excess
|
| 5 | Fady Messak | 21 | 2,548 | $1,707 | 121.3 mi | 66.1 mi | 1,389 | $931 | 121.3 |
55% excess
|
| 6 | Luis Torres | 124 | 2,464 | $1,651 | 19.9 mi | 2.0 mi | 244 | $163 | 19.9 |
10% excess
|
| 7 | Natosha Beierschmitt | 1 | 1,403 | $940 | 1402.6 mi | 1376.9 mi | 1,377 | $923 | 1403 |
98% excess
|
| 8 | David Cavaco | 17 | 1,142 | $765 | 67.2 mi | 45.9 mi | 781 | $523 | 67.2 |
68% excess
|
| 9 | Pete Ramos | 11 | 896 | $600 | 81.4 mi | 36.1 mi | 397 | $266 | 81.5 |
44% excess
|
| 10 | Davon Cox | 10 | 756 | $507 | 75.6 mi | 22.9 mi | 229 | $153 | 75.6 |
30% excess
|
| 11 | Nick O'Neill | 6 | 564 | $378 | 94.0 mi | 86.3 mi | 518 | $347 | 94 |
92% excess
|
| 12 | Philmon Mehari | 7 | 478 | $320 | 68.3 mi | 13.1 mi | 92 | $62 | 68.3 |
19% excess
|
| 13 | Curtis Allen | 6 | 471 | $316 | 78.5 mi | 61.1 mi | 367 | $246 | 78.5 |
78% excess
|
| 14 | Carlos Puebla | 4 | 389 | $261 | 97.1 mi | 80.6 mi | 323 | $216 | 97.3 |
83% excess
|
| 15 | Darrell Hope | 6 | 351 | $235 | 58.5 mi | 36.7 mi | 220 | $147 | 58.5 |
63% excess
|
| 16 | Bryan Rodriguez | 4 | 304 | $204 | 76.1 mi | 20.7 mi | 83 | $56 | 76 |
27% excess
|
| 17 | Fady Khouzam | 1 | 115 | $77 | 115.4 mi | 60.9 mi | 61 | $41 | 115 |
53% excess
|
| 18 | VPD Bench | 1 | 109 | $73 | 108.9 mi | 92.6 mi | 93 | $62 | 109 |
85% excess
|
| 19 | David Trost | 3 | 79 | $53 | 26.3 mi | 13.4 mi | 40 | $27 | 26.3 |
51% excess
|