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 | Philip Krogstad | 85 | 3,263 | $2,186 | 38.4 mi | 21 mi | 1,787 | $1,197 | 38.4 |
55% excess
|
| 2 | Pero Popovic | 30 | 1,572 | $1,053 | 52.4 mi | 44.6 mi | 1,337 | $896 | 52.4 |
85% excess
|
| 3 | Brandon Green | 12 | 532 | $356 | 44.4 mi | 0 mi | 0 | $0 | 44.3 |
0% excess
|
| 4 | Chris Galasso | 17 | 319 | $214 | 18.8 mi | 3.3 mi | 57 | $38 | 18.8 |
18% excess
|
| 5 | Dustin Antolin | 3 | 309 | $207 | 103.2 mi | 31.5 mi | 95 | $64 | 103 |
31% excess
|
| 6 | Michael Harris | 4 | 168 | $113 | 41.9 mi | 30 mi | 120 | $80 | 42 |
71% excess
|
| 7 | Pete Ramos | 1 | 33 | $22 | 33.3 mi | 5.4 mi | 5 | $3 | 33 |
15% excess
|