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 | Allan Klus | 59 | 4,624 | $3,098 | 78.4 mi | 33.3 mi | 1,967 | $1,318 | 78.4 |
43% excess
|
| 2 | Luis Iser | 3 | 2,951 | $1,977 | 983.6 mi | 971.1 mi | 2,913 | $1,952 | 983.7 |
99% excess
|
| 3 | Rodney Charles | 25 | 2,574 | $1,725 | 103.0 mi | 62.8 mi | 1,570 | $1,052 | 103 |
61% excess
|
| 4 | Rick Charles | 21 | 2,074 | $1,390 | 98.8 mi | 77.9 mi | 1,636 | $1,096 | 98.8 |
79% excess
|
| 5 | Jeffrey Coles | 30 | 856 | $574 | 28.5 mi | 0.5 mi | 14 | $9 | 28.5 |
2% excess
|
| 6 | April Nuovo | 2 | 677 | $454 | 338.3 mi | 256.1 mi | 512 | $343 | 338.5 |
76% excess
|
| 7 | Bennet O Dartey | 1 | 597 | $400 | 596.8 mi | 580.7 mi | 581 | $389 | 597 |
97% excess
|
| 8 | Fady Messak | 3 | 502 | $336 | 167.5 mi | 112.4 mi | 337 | $226 | 167.3 |
67% excess
|
| 9 | Joe Hudson | 3 | 456 | $306 | 151.9 mi | 97.4 mi | 292 | $196 | 152 |
64% excess
|
| 10 | Michael Steencken | 3 | 395 | $265 | 131.6 mi | 86.9 mi | 261 | $175 | 131.7 |
66% excess
|
| 11 | Davon Cox | 2 | 343 | $230 | 171.4 mi | 69.9 mi | 140 | $94 | 171.5 |
41% excess
|
| 12 | Joseph Nuovo | 1 | 334 | $224 | 334.1 mi | 318.0 mi | 318 | $213 | 334 |
95% excess
|
| 13 | Patricia Gordon | 1 | 330 | $221 | 329.8 mi | 286.4 mi | 286 | $192 | 330 |
87% excess
|
| 14 | Dillon Pilgrim | 1 | 218 | $146 | 217.9 mi | 159.9 mi | 160 | $107 | 218 |
73% excess
|
| 15 | Jason Yenser | 2 | 203 | $136 | 101.7 mi | 11.1 mi | 22 | $15 | 101.5 |
11% excess
|
| 16 | Carlos Puebla | 1 | 176 | $118 | 175.9 mi | 159.8 mi | 160 | $107 | 176 |
91% excess
|
| 17 | Alberto Galan | 1 | 160 | $107 | 159.7 mi | 143.6 mi | 144 | $96 | 160 |
90% excess
|
| 18 | Shady Messak | 1 | 140 | $94 | 139.5 mi | 123.4 mi | 123 | $82 | 140 |
88% excess
|