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 | Rozier Cole | 10 | 5,116 | $3,428 | 511.6 mi | 433.8 mi | 4,338 | $2,906 | 511.6 |
85% excess
|
| 2 | Philip Krogstad | 92 | 3,788 | $2,538 | 41.2 mi | 21.8 mi | 2,010 | $1,347 | 41.2 |
53% excess
|
| 3 | Pero Popovic | 33 | 1,661 | $1,113 | 50.3 mi | 42.5 mi | 1,401 | $939 | 50.3 |
84% excess
|
| 4 | Maximilian Tucker | 42 | 1,291 | $865 | 30.7 mi | 7.8 mi | 326 | $218 | 30.7 |
25% excess
|
| 5 | Ronnie Salone | 1 | 902 | $604 | 902.1 mi | 0 mi | 0 | $0 | 902 |
0% excess
|
| 6 | Chris Galasso | 35 | 889 | $596 | 25.4 mi | 1.6 mi | 57 | $38 | 25.4 |
6% excess
|
| 7 | Brandon Green | 12 | 592 | $397 | 49.3 mi | 0 mi | 0 | $0 | 49.3 |
0% excess
|
| 8 | Dustin Antolin | 4 | 389 | $261 | 97.2 mi | 23.7 mi | 95 | $64 | 97.3 |
24% excess
|
| 9 | Darrell Hope | 2 | 178 | $119 | 88.8 mi | 28.9 mi | 58 | $39 | 89 |
33% excess
|
| 10 | Michael Harris | 4 | 168 | $113 | 41.9 mi | 30 mi | 120 | $80 | 42 |
71% excess
|
| 11 | David Trost | 1 | 161 | $108 | 161.5 mi | 57.4 mi | 57 | $38 | 161 |
35% excess
|
| 12 | Curtis Allen | 1 | 61 | $41 | 60.7 mi | 8.3 mi | 8 | $5 | 61 |
13% excess
|
| 13 | Pete Ramos | 1 | 33 | $22 | 33.3 mi | 5.4 mi | 5 | $3 | 33 |
15% excess
|