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 | 48 | 3,813 | $2,555 | 79.4 mi | 40.7 mi | 1,954 | $1,309 | 79.4 |
51% excess
|
| 2 | Maximilian Tucker | 32 | 3,175 | $2,127 | 99.2 mi | 49.5 mi | 1,584 | $1,061 | 99.2 |
50% excess
|
| 3 | Michael Harris | 47 | 2,630 | $1,762 | 56 mi | 11.8 mi | 554 | $371 | 56 |
21% excess
|
| 4 | Chris Galasso | 17 | 1,682 | $1,127 | 98.9 mi | 35.3 mi | 600 | $402 | 98.9 |
36% excess
|
| 5 | Rick Charles | 13 | 1,365 | $915 | 105 mi | 74.9 mi | 974 | $653 | 105 |
71% excess
|
| 6 | Jeffrey Coles | 30 | 1,092 | $732 | 36.4 mi | 2.3 mi | 69 | $46 | 36.4 |
6% excess
|
| 7 | Bennet O Dartey | 1 | 597 | $400 | 596.8 mi | 580.7 mi | 581 | $389 | 597 |
97% excess
|
| 8 | Rodney Charles | 5 | 569 | $381 | 113.9 mi | 59.4 mi | 297 | $199 | 113.8 |
52% excess
|
| 9 | Joe Hudson | 3 | 456 | $306 | 151.9 mi | 97.4 mi | 292 | $196 | 152 |
64% excess
|
| 10 | Pero Popovic | 4 | 363 | $243 | 90.7 mi | 25.2 mi | 101 | $68 | 90.8 |
28% 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 mi | 318 | $213 | 334 |
95% excess
|
| 13 | Brandon Green | 2 | 280 | $188 | 139.9 mi | 42.8 mi | 86 | $58 | 140 |
31% excess
|
| 14 | Todd Fogiel | 1 | 249 | $167 | 249.1 mi | 183.8 mi | 184 | $123 | 249 |
74% excess
|
| 15 | Carlos Puebla | 1 | 176 | $118 | 175.9 mi | 159.8 mi | 160 | $107 | 176 |
91% excess
|
| 16 | Alberto Galan | 1 | 160 | $107 | 159.7 mi | 143.6 mi | 144 | $96 | 160 |
90% excess
|
| 17 | Shady Messak | 1 | 140 | $94 | 139.5 mi | 123.4 mi | 123 | $82 | 140 |
88% excess
|