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 | Kevin Cogdill | 246 | 72,102 | $48,308 | 293.1 mi | 278.3 mi | 68,459 | $45,868 | 293.1 |
95% excess
|
| 2 | Joe Evans | 201 | 35,105 | $23,520 | 174.7 mi | 163.6 mi | 32,890 | $22,036 | 174.7 |
94% excess
|
| 3 | Yves Dessin | 80 | 32,465 | $21,752 | 405.8 mi | 396.6 mi | 31,729 | $21,258 | 405.8 |
98% excess
|
| 4 | Kenneth Lancara | 435 | 17,736 | $11,883 | 40.8 mi | 12.5 mi | 5,458 | $3,657 | 40.8 |
31% excess
|
| 5 | Christopher Carroll | 21 | 12,371 | $8,289 | 589.1 mi | 556.1 mi | 11,677 | $7,824 | 589.1 |
94% excess
|
| 6 | Torre Gifford | 140 | 8,763 | $5,871 | 62.6 mi | 42.9 mi | 6,008 | $4,025 | 62.6 |
69% excess
|
| 7 | Ray-Anthony Alston | 316 | 5,619 | $3,765 | 17.8 mi | 2.8 mi | 894 | $599 | 17.8 |
16% excess
|
| 8 | Matthew Sebzda | 92 | 2,991 | $2,004 | 32.5 mi | 21.2 mi | 1,952 | $1,308 | 32.5 |
65% excess
|
| 9 | Daniel Clark | 175 | 2,348 | $1,573 | 13.4 mi | 0.0 mi | 0 | $0 | 13.4 |
0% excess
|
| 10 | Rozier Cole | 12 | 2,322 | $1,556 | 193.5 mi | 170.8 mi | 2,050 | $1,374 | 193.5 |
88% excess
|
| 11 | Craig Walker | 146 | 2,106 | $1,411 | 14.4 mi | 0.0 mi | 0 | $0 | 14.4 |
0% excess
|
| 12 | Franco Jackson | 10 | 136 | $91 | 13.6 mi | 0.0 mi | 0 | $0 | 13.6 |
0% excess
|
| 13 | Todd Fogiel | 1 | 115 | $77 | 114.5 mi | 81.5 mi | 82 | $55 | 115 |
71% excess
|
| 14 | Mark Stelter | 3 | 113 | $76 | 37.6 mi | 0.0 mi | 0 | $0 | 37.7 |
0% excess
|
| 15 | Jon Sanchez | 3 | 20 | $13 | 6.7 mi | 0.0 mi | 0 | $0 | 6.7 |
0% excess
|