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 | Christopher Morning | 143 | 11,214 | $7,513 | 78.4 mi | 48.6 mi | 6,943 | $4,652 | 78.4 |
62% excess
|
| 2 | Eric Colon | 99 | 8,576 | $5,746 | 86.6 mi | 42.9 mi | 4,247 | $2,845 | 86.6 |
50% excess
|
| 3 | Michael Harris | 101 | 6,382 | $4,276 | 63.2 mi | 27.9 mi | 2,820 | $1,889 | 63.2 |
44% excess
|
| 4 | Philip Krogstad | 154 | 6,033 | $4,042 | 39.2 mi | 22.4 mi | 3,446 | $2,309 | 39.2 |
57% excess
|
| 5 | Christopher Carroll | 28 | 4,207 | $2,819 | 150.3 mi | 101.9 mi | 2,854 | $1,912 | 150.3 |
68% excess
|
| 6 | Michael Swingle | 51 | 4,142 | $2,775 | 81.2 mi | 48.2 mi | 2,456 | $1,646 | 81.2 |
59% excess
|
| 7 | Todd Fogiel | 55 | 3,981 | $2,667 | 72.4 mi | 20.4 mi | 1,122 | $752 | 72.4 |
28% excess
|
| 8 | James Duff | 32 | 2,924 | $1,959 | 91.4 mi | 52.7 mi | 1,687 | $1,130 | 91.4 |
58% excess
|
| 9 | Pero Popovic | 41 | 2,250 | $1,508 | 54.9 mi | 40.0 mi | 1,639 | $1,098 | 54.9 |
73% excess
|
| 10 | Chris Galasso | 62 | 1,129 | $756 | 18.2 mi | 3.5 mi | 214 | $143 | 18.2 |
19% excess
|
| 11 | Pete Ramos | 4 | 934 | $626 | 233.6 mi | 112.8 mi | 451 | $302 | 233.5 |
48% excess
|
| 12 | Brandon Green | 19 | 794 | $532 | 41.8 mi | 4.6 mi | 87 | $58 | 41.8 |
11% excess
|
| 13 | Dustin Antolin | 4 | 393 | $263 | 98.2 mi | 33.3 mi | 133 | $89 | 98.3 |
34% excess
|
| 14 | Angel Rios | 1 | 393 | $263 | 393.0 mi | 373.7 mi | 374 | $251 | 393 |
95% excess
|
| 15 | Rozier Cole | 2 | 196 | $131 | 98.2 mi | 85.7 mi | 171 | $115 | 98 |
87% excess
|
| 16 | Mohamed Shareed | 1 | 41 | $27 | 41.2 mi | 3.8 mi | 4 | $3 | 41 |
10% excess
|
| 17 | Edward Arias | 1 | 8 | $5 | 8.3 mi | 7.5 mi | 8 | $5 | 8 |
100% excess
|