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 | Rodney Charles | 5 | 11,596 | $7,769 | 2319.1 mi | 2288.3 mi | 11,442 | $7,666 | 2319.2 |
99% excess
|
| 2 | Bennet O Dartey | 5 | 8,776 | $5,880 | 1755.2 mi | 1750.1 mi | 8,750 | $5,863 | 1755.2 |
100% excess
|
| 3 | Jackson Reeves | 4 | 7,472 | $5,006 | 1868.0 mi | 1862.5 mi | 7,450 | $4,992 | 1868 |
100% excess
|
| 4 | Konstantin Barskiy | 2 | 4,795 | $3,213 | 2397.4 mi | 2366.6 mi | 4,733 | $3,171 | 2397.5 |
99% excess
|
| 5 | Shawn Kelley | 2 | 4,776 | $3,200 | 2388.0 mi | 2304.0 mi | 4,608 | $3,087 | 2388 |
96% excess
|
| 6 | Tim Holman | 155 | 4,705 | $3,152 | 30.4 mi | 1.2 mi | 184 | $123 | 30.4 |
4% excess
|
| 7 | Jeffrey Pastor | 4 | 3,720 | $2,492 | 930.0 mi | 889.3 mi | 3,557 | $2,383 | 930 |
96% excess
|
| 8 | Kwame Cobb | 3 | 2,868 | $1,922 | 956.0 mi | 247.5 mi | 743 | $498 | 956 |
26% excess
|
| 9 | Derick Velazquez | 1 | 2,549 | $1,708 | 2548.5 mi | 2517.7 mi | 2,518 | $1,687 | 2549 |
99% excess
|
| 10 | Fady Messak | 1 | 2,381 | $1,595 | 2380.5 mi | 2349.7 mi | 2,350 | $1,575 | 2381 |
99% excess
|
| 11 | Michah Brackett | 5 | 2,232 | $1,495 | 446.5 mi | 0.0 mi | 0 | $0 | 446.4 |
0% excess
|
| 12 | Paul Mccormish | 1 | 1,989 | $1,333 | 1988.9 mi | 1958.1 mi | 1,958 | $1,312 | 1989 |
98% excess
|
| 13 | Jason Morris | 9 | 454 | $304 | 50.4 mi | 0.0 mi | 0 | $0 | 50.4 |
0% excess
|