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 | Paul Mccormish | 15 | 1,176 | $788 | 78.4 mi | 6.3 mi | 94 | $63 | 78.4 |
8% excess
|
| 2 | Brandon Rodriguez | 1 | 1,126 | $754 | 1125.5 mi | 1123.6 mi | 1,124 | $753 | 1126 |
100% excess
|
| 3 | Jordan Moceri | 9 | 840 | $563 | 93.3 mi | 81.6 mi | 734 | $492 | 93.3 |
87% excess
|
| 4 | Scott R Roberts | 10 | 712 | $477 | 71.2 mi | 8.7 mi | 87 | $58 | 71.2 |
12% excess
|
| 5 | Franco Jackson | 29 | 537 | $360 | 18.5 mi | 4.3 mi | 126 | $84 | 18.5 |
23% excess
|
| 6 | Dustin Antolin | 12 | 472 | $316 | 39.3 mi | 2.7 mi | 32 | $21 | 39.3 |
7% excess
|
| 7 | Brandon Green | 4 | 305 | $204 | 76.3 mi | 21.8 mi | 87 | $58 | 76.3 |
29% excess
|
| 8 | Ben McClerklin | 1 | 264 | $177 | 264.2 mi | 262.3 mi | 262 | $176 | 264 |
99% excess
|
| 9 | Jim Kingery | 3 | 165 | $111 | 55 mi | 54.4 mi | 163 | $109 | 55 |
99% excess
|
| 10 | Teddie Bracken | 3 | 97 | $65 | 32.5 mi | 8.3 mi | 25 | $17 | 32.3 |
26% excess
|