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 | Praelow Cameron | 73 | 8,044 | $5,389 | 110.2 mi | 52.8 mi | 3,854 | $2,582 | 110.2 |
48% excess
|
| 2 | Patricia Gordon | 77 | 7,281 | $4,878 | 94.6 mi | 31.8 mi | 2,446 | $1,639 | 94.6 |
34% excess
|
| 3 | Marvin Rivas | 6 | 6,368 | $4,267 | 1061.4 mi | 998.8 mi | 5,993 | $4,015 | 1061.3 |
94% excess
|
| 4 | Eric Colon | 31 | 3,423 | $2,293 | 110.4 mi | 68.5 mi | 2,125 | $1,424 | 110.4 |
62% excess
|
| 5 | Christopher Morning | 64 | 3,339 | $2,237 | 52.2 mi | 18.6 mi | 1,187 | $795 | 52.2 |
36% excess
|
| 6 | Bruce Ballard | 14 | 3,276 | $2,195 | 234 mi | 216 mi | 3,025 | $2,027 | 234 |
92% excess
|
| 7 | Todd Fogiel | 50 | 3,114 | $2,086 | 62.3 mi | 4.9 mi | 244 | $163 | 62.3 |
8% excess
|
| 8 | Michael Swingle | 10 | 2,860 | $1,916 | 286 mi | 253 mi | 2,530 | $1,695 | 286 |
88% excess
|
| 9 | Rozier Cole | 16 | 1,716 | $1,150 | 107.2 mi | 28.6 mi | 457 | $306 | 107.3 |
27% excess
|
| 10 | Ryan Lewis | 6 | 1,374 | $921 | 229.1 mi | 130.9 mi | 785 | $526 | 229 |
57% excess
|
| 11 | Christopher Carroll | 2 | 1,178 | $789 | 589.1 mi | 556.1 mi | 1,112 | $745 | 589 |
94% excess
|
| 12 | Fady Messak | 3 | 1,155 | $774 | 385.2 mi | 270.3 mi | 811 | $543 | 385 |
70% excess
|
| 13 | Natosha Beierschmitt | 1 | 1,100 | $737 | 1099.8 mi | 961 mi | 961 | $644 | 1100 |
87% excess
|
| 14 | Minh Huynh | 1 | 730 | $489 | 730 mi | 697.4 mi | 697 | $467 | 730 |
95% excess
|
| 15 | Brendan Chaney | 1 | 365 | $245 | 364.8 mi | 344.2 mi | 344 | $230 | 365 |
94% excess
|