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 | 78 | 6,497 | $4,353 | 83.3 mi | 50.5 mi | 3,942 | $2,641 | 83.3 |
61% excess
|
| 2 | Eric Colon | 52 | 4,736 | $3,173 | 91.1 mi | 47.1 mi | 2,449 | $1,641 | 91.1 |
52% excess
|
| 3 | Philip Krogstad | 83 | 3,377 | $2,263 | 40.7 mi | 23.2 mi | 1,925 | $1,290 | 40.7 |
57% excess
|
| 4 | Michael Harris | 54 | 3,314 | $2,220 | 61.4 mi | 25 mi | 1,351 | $905 | 61.4 |
41% excess
|
| 5 | Michael Swingle | 32 | 2,575 | $1,725 | 80.5 mi | 46.9 mi | 1,502 | $1,006 | 80.5 |
58% excess
|
| 6 | Christopher Carroll | 8 | 1,954 | $1,309 | 244.3 mi | 207.1 mi | 1,657 | $1,110 | 244.3 |
85% excess
|
| 7 | Pero Popovic | 32 | 1,863 | $1,248 | 58.2 mi | 42.7 mi | 1,366 | $915 | 58.2 |
73% excess
|
| 8 | Todd Fogiel | 24 | 1,508 | $1,010 | 62.8 mi | 16.5 mi | 396 | $265 | 62.8 |
26% excess
|
| 9 | James Duff | 18 | 1,504 | $1,008 | 83.6 mi | 43.7 mi | 787 | $527 | 83.6 |
52% excess
|
| 10 | Chris Galasso | 30 | 547 | $366 | 18.2 mi | 1.9 mi | 57 | $38 | 18.2 |
10% excess
|
| 11 | Angel Rios | 1 | 393 | $263 | 393 mi | 373.7 mi | 374 | $251 | 393 |
95% excess
|
| 12 | Dustin Antolin | 3 | 309 | $207 | 103.2 mi | 31.5 mi | 95 | $64 | 103 |
31% excess
|
| 13 | Brandon Green | 5 | 270 | $181 | 54 mi | 0 mi | 0 | $0 | 54 |
0% excess
|
| 14 | Mohamed Shareed | 1 | 41 | $27 | 41.1 mi | 3.8 mi | 4 | $3 | 41 |
10% excess
|
| 15 | Pete Ramos | 1 | 33 | $22 | 33.3 mi | 5.4 mi | 5 | $3 | 33 |
15% excess
|
| 16 | Edward Arias | 1 | 8 | $5 | 8.3 mi | 7.5 mi | 8 | $5 | 8 |
100% excess
|