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 | Jackson Reeves | 2 | 3,732 | $2,500 | 1866 mi | 1858.1 mi | 3,716 | $2,490 | 1866 |
100% excess
|
| 2 | Bennet O Dartey | 2 | 3,502 | $2,346 | 1750.8 mi | 1742.9 mi | 3,486 | $2,336 | 1751 |
100% excess
|
| 3 | Jeffrey Pastor | 3 | 2,892 | $1,938 | 963.9 mi | 910.3 mi | 2,731 | $1,830 | 964 |
94% excess
|
| 4 | Shawn Kelley | 1 | 2,446 | $1,639 | 2445.5 mi | 2433.1 mi | 2,433 | $1,630 | 2446 |
99% excess
|
| 5 | Tim Holman | 92 | 2,286 | $1,532 | 24.8 mi | 1 mi | 91 | $61 | 24.8 |
4% excess
|
| 6 | Kwame Cobb | 2 | 1,917 | $1,284 | 958.3 mi | 247.7 mi | 495 | $332 | 958.5 |
26% excess
|
| 7 | Michah Brackett | 4 | 1,787 | $1,197 | 446.8 mi | 0 mi | 0 | $0 | 446.8 |
0% excess
|
| 8 | Jason Morris | 5 | 246 | $165 | 49.2 mi | 0 mi | 0 | $0 | 49.2 |
0% excess
|