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 | Praelow Cameron | 90 | 31,233 | $20,926 | 347.0 mi | 304.6 mi | 27,412 | $18,366 | 347 |
88% excess
|
| 2 | Allan Klus | 59 | 4,624 | $3,098 | 78.4 mi | 33.3 mi | 1,967 | $1,318 | 78.4 |
43% excess
|
| 3 | Michael Harris | 67 | 3,765 | $2,523 | 56.2 mi | 12.3 mi | 827 | $554 | 56.2 |
22% excess
|
| 4 | Maximilian Tucker | 34 | 3,422 | $2,293 | 100.7 mi | 50.9 mi | 1,732 | $1,160 | 100.6 |
51% excess
|
| 5 | Luis Iser | 3 | 2,951 | $1,977 | 983.6 mi | 971.1 mi | 2,913 | $1,952 | 983.7 |
99% excess
|
| 6 | Chris Galasso | 26 | 2,598 | $1,741 | 99.9 mi | 33.8 mi | 878 | $588 | 99.9 |
34% excess
|
| 7 | Rodney Charles | 25 | 2,574 | $1,725 | 103.0 mi | 62.8 mi | 1,570 | $1,052 | 103 |
61% excess
|
| 8 | Rick Charles | 21 | 2,074 | $1,390 | 98.8 mi | 77.9 mi | 1,636 | $1,096 | 98.8 |
79% excess
|
| 9 | Jeffrey Coles | 30 | 856 | $574 | 28.5 mi | 0.5 mi | 14 | $9 | 28.5 |
2% excess
|
| 10 | April Nuovo | 2 | 677 | $454 | 338.3 mi | 256.1 mi | 512 | $343 | 338.5 |
76% excess
|
| 11 | Bennet O Dartey | 1 | 597 | $400 | 596.8 mi | 580.7 mi | 581 | $389 | 597 |
97% excess
|
| 12 | Fady Messak | 3 | 502 | $336 | 167.5 mi | 112.4 mi | 337 | $226 | 167.3 |
67% excess
|
| 13 | Joe Hudson | 3 | 456 | $306 | 151.9 mi | 97.4 mi | 292 | $196 | 152 |
64% excess
|
| 14 | Michael Steencken | 3 | 395 | $265 | 131.6 mi | 86.9 mi | 261 | $175 | 131.7 |
66% excess
|
| 15 | Pero Popovic | 4 | 363 | $243 | 90.7 mi | 25.2 mi | 101 | $68 | 90.8 |
28% excess
|
| 16 | Shawn Kelley | 1 | 345 | $231 | 345.1 mi | 335.3 mi | 335 | $224 | 345 |
97% excess
|
| 17 | Davon Cox | 2 | 343 | $230 | 171.4 mi | 69.9 mi | 140 | $94 | 171.5 |
41% excess
|
| 18 | Joseph Nuovo | 1 | 334 | $224 | 334.1 mi | 318.0 mi | 318 | $213 | 334 |
95% excess
|
| 19 | Patricia Gordon | 1 | 330 | $221 | 329.8 mi | 286.4 mi | 286 | $192 | 330 |
87% excess
|
| 20 | Brandon Green | 2 | 280 | $188 | 139.9 mi | 42.8 mi | 86 | $58 | 140 |
31% excess
|
| 21 | Todd Fogiel | 1 | 249 | $167 | 249.1 mi | 183.8 mi | 184 | $123 | 249 |
74% excess
|
| 22 | Dillon Pilgrim | 1 | 218 | $146 | 217.9 mi | 159.9 mi | 160 | $107 | 218 |
73% excess
|
| 23 | Jason Yenser | 2 | 203 | $136 | 101.7 mi | 11.1 mi | 22 | $15 | 101.5 |
11% excess
|
| 24 | Carlos Puebla | 1 | 176 | $118 | 175.9 mi | 159.8 mi | 160 | $107 | 176 |
91% excess
|
| 25 | Alberto Galan | 1 | 160 | $107 | 159.7 mi | 143.6 mi | 144 | $96 | 160 |
90% excess
|
| 26 | Shady Messak | 1 | 140 | $94 | 139.5 mi | 123.4 mi | 123 | $82 | 140 |
88% excess
|