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 | Andre Samuda | 8 | 8,645 | $5,792 | 1080.6 mi | 814.3 mi | 6,514 | $4,364 | 1080.6 |
75% excess
|
| 2 | Derick Velazquez | 6 | 4,649 | $3,115 | 774.8 mi | 604.1 mi | 3,625 | $2,429 | 774.8 |
78% excess
|
| 3 | Davon Cox | 4 | 4,337 | $2,906 | 1084.2 mi | 808.1 mi | 3,232 | $2,165 | 1084.3 |
75% excess
|
| 4 | Blake Ward | 56 | 4,191 | $2,808 | 74.8 mi | 43.0 mi | 2,410 | $1,615 | 74.8 |
58% excess
|
| 5 | April Nuovo | 3 | 3,687 | $2,470 | 1229.0 mi | 925.8 mi | 2,778 | $1,861 | 1229 |
75% excess
|
| 6 | Marvin Rivas | 4 | 2,645 | $1,772 | 661.3 mi | 560.9 mi | 2,243 | $1,503 | 661.3 |
85% excess
|
| 7 | Kevin Cox | 53 | 2,637 | $1,767 | 49.8 mi | 12.8 mi | 678 | $454 | 49.8 |
26% excess
|
| 8 | Natosha Beierschmitt | 5 | 2,476 | $1,659 | 495.2 mi | 461.1 mi | 2,306 | $1,545 | 495.2 |
93% excess
|
| 9 | Fady Messak | 2 | 1,990 | $1,333 | 994.9 mi | 794.8 mi | 1,590 | $1,065 | 995 |
80% excess
|
| 10 | Thomas J Langenberg Jr | 39 | 1,536 | $1,029 | 39.4 mi | 6.3 mi | 248 | $166 | 39.4 |
16% excess
|
| 11 | Joseph Nuovo | 1 | 1,229 | $823 | 1229.1 mi | 966.3 mi | 966 | $647 | 1229 |
79% excess
|
| 12 | Curtis Sprague | 1 | 863 | $578 | 862.9 mi | 351.4 mi | 351 | $235 | 863 |
41% excess
|
| 13 | Bennet O Dartey | 2 | 778 | $521 | 389.0 mi | 222.0 mi | 444 | $297 | 389 |
57% excess
|
| 14 | Christopher Ables | 1 | 426 | $285 | 426.1 mi | 313.3 mi | 313 | $210 | 426 |
73% excess
|