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 | Mike Huffman | 32 | 10,546 | $7,066 | 329.6 mi | 263.6 mi | 8,436 | $5,652 | 329.6 |
80% excess
|
| 2 | Chris Galasso | 7 | 4,698 | $3,148 | 671.2 mi | 440.9 mi | 3,087 | $2,068 | 671.1 |
66% excess
|
| 3 | Andrew Przybyla | 1 | 1,408 | $943 | 1407.5 mi | 1170.3 mi | 1,170 | $784 | 1408 |
83% excess
|
| 4 | Ronnie Salone | 1 | 341 | $228 | 341.3 mi | 329.2 mi | 329 | $220 | 341 |
96% excess
|
| 5 | Kevin Cox | 1 | 94 | $63 | 94.4 mi | 0.0 mi | 0 | $0 | 94 |
0% excess
|