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 | Scott A Berry | 5 | 2,229 | $1,493 | 445.8 mi | 428.2 mi | 2,141 | $1,434 | 445.8 |
96% excess
|
| 2 | Bryan Rodriguez | 7 | 1,310 | $878 | 187.1 mi | 34 mi | 238 | $159 | 187.1 |
18% excess
|
| 3 | Christopher Carroll | 1 | 1,090 | $730 | 1089.8 mi | 1089.8 mi | 1,090 | $730 | 1090 |
100% excess
|
| 4 | Fady Messak | 7 | 496 | $332 | 70.9 mi | 38.4 mi | 269 | $180 | 70.9 |
54% excess
|
| 5 | Joseph Nuovo | 2 | 274 | $184 | 136.9 mi | 32 mi | 64 | $43 | 137 |
23% excess
|
| 6 | Andre Samuda | 17 | 242 | $162 | 14.2 mi | 6.4 mi | 109 | $73 | 14.2 |
45% excess
|
| 7 | Darek Kirkpatrick | 2 | 186 | $125 | 93.1 mi | 10.6 mi | 21 | $14 | 93 |
11% excess
|
| 8 | Fady Khouzam | 1 | 180 | $121 | 180 mi | 30.4 mi | 30 | $20 | 180 |
17% excess
|
| 9 | Vivian Hyde | 12 | 177 | $119 | 14.8 mi | 3.9 mi | 47 | $31 | 14.8 |
27% excess
|
| 10 | Erwin Forster | 4 | 149 | $100 | 37.3 mi | 13.9 mi | 55 | $37 | 37.3 |
37% excess
|
| 11 | April Nuovo | 1 | 143 | $96 | 143 mi | 1.5 mi | 1 | $1 | 143 |
1% excess
|
| 12 | Luis Torres | 2 | 128 | $86 | 64.1 mi | 43.5 mi | 87 | $58 | 64 |
68% excess
|
| 13 | Israel Martell | 8 | 113 | $76 | 14.1 mi | 4.9 mi | 40 | $27 | 14.1 |
35% excess
|
| 14 | Michael Steencken | 1 | 111 | $74 | 111.3 mi | 109.4 mi | 109 | $73 | 111 |
98% excess
|
| 15 | Bernard Thompson | 3 | 110 | $74 | 36.6 mi | 12.7 mi | 38 | $25 | 36.7 |
35% excess
|
| 16 | Edward Arias | 4 | 103 | $69 | 25.7 mi | 9.5 mi | 38 | $25 | 25.8 |
37% excess
|
| 17 | David Trost | 6 | 84 | $56 | 14 mi | 4.9 mi | 29 | $19 | 14 |
35% excess
|
| 18 | Darrell Hope | 3 | 74 | $50 | 24.6 mi | 2.6 mi | 8 | $5 | 24.7 |
11% excess
|
| 19 | Pete Ramos | 2 | 63 | $42 | 31.7 mi | 20.8 mi | 42 | $28 | 31.5 |
67% excess
|
| 20 | Taylor Duda | 1 | 20 | $13 | 19.8 mi | 15.6 mi | 16 | $11 | 20 |
80% excess
|
| 21 | Mohamed Shareed | 2 | 8 | $5 | 3.8 mi | 3 mi | 6 | $4 | 4 |
75% excess
|
| 22 | Hector Castaneda | 1 | 0 | $0 | 0 mi | 0 mi | 0 | $0 | 0 |
0% excess
|