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 | Ryan Lewis | 42 | 20,598 | $13,801 | 490.4 mi | 287.5 mi | 12,074 | $8,090 | 490.4 |
59% excess
|
| 2 | Jason Cunningham | 72 | 10,000 | $6,700 | 138.9 mi | 78.1 mi | 5,624 | $3,768 | 138.9 |
56% excess
|
| 3 | April Nuovo | 5 | 5,647 | $3,783 | 1129.5 mi | 962.2 mi | 4,811 | $3,223 | 1129.4 |
85% excess
|
| 4 | Joseph Nuovo | 2 | 2,208 | $1,479 | 1104.1 mi | 992.3 mi | 1,985 | $1,330 | 1104 |
90% excess
|
| 5 | Minh Huynh | 1 | 1,184 | $793 | 1184.5 mi | 1138.7 mi | 1,139 | $763 | 1184 |
96% excess
|
| 6 | Davon Cox | 1 | 946 | $634 | 945.7 mi | 771.1 mi | 771 | $517 | 946 |
82% excess
|
| 7 | Curtis Sprague | 1 | 577 | $387 | 576.6 mi | 371.7 mi | 372 | $249 | 577 |
64% excess
|
| 8 | Craig Walker | 2 | 294 | $197 | 147.2 mi | 6.0 mi | 12 | $8 | 147 |
4% excess
|
| 9 | Michael Swingle | 1 | 148 | $99 | 147.6 mi | 110.3 mi | 110 | $74 | 148 |
74% excess
|