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 | Eric Mancerella | 98 | 14,656 | $9,820 | 149.5 mi | 56.0 mi | 5,492 | $3,680 | 149.6 |
37% excess
|
| 2 | Paul Mccormish | 170 | 10,314 | $6,910 | 60.7 mi | 4.8 mi | 820 | $549 | 60.7 |
8% excess
|
| 3 | Fady Messak | 11 | 4,713 | $3,158 | 428.4 mi | 328.2 mi | 3,611 | $2,419 | 428.5 |
77% excess
|
| 4 | Jackson Reeves | 26 | 4,047 | $2,711 | 155.6 mi | 112.7 mi | 2,930 | $1,963 | 155.7 |
72% excess
|
| 5 | Luis Iser | 2 | 2,125 | $1,424 | 1062.3 mi | 1005.6 mi | 2,011 | $1,347 | 1062.5 |
95% excess
|
| 6 | Samuel Biddie | 2 | 1,209 | $810 | 604.6 mi | 552.9 mi | 1,106 | $741 | 604.5 |
91% excess
|
| 7 | Israel Martell | 2 | 1,016 | $681 | 508.0 mi | 385.3 mi | 771 | $517 | 508 |
76% excess
|
| 8 | Rodney Charles | 3 | 1,008 | $675 | 336.1 mi | 275.1 mi | 825 | $553 | 336 |
82% excess
|
| 9 | Bennet O Dartey | 3 | 881 | $590 | 293.8 mi | 218.3 mi | 655 | $439 | 293.7 |
74% excess
|
| 10 | Rick Charles | 2 | 657 | $440 | 328.3 mi | 294.5 mi | 589 | $395 | 328.5 |
90% excess
|
| 11 | Bruce Ballard | 1 | 558 | $374 | 557.9 mi | 524.0 mi | 524 | $351 | 558 |
94% excess
|
| 12 | Andre Samuda | 1 | 407 | $273 | 407.0 mi | 326.2 mi | 326 | $218 | 407 |
80% excess
|
| 13 | Carlos Puebla | 1 | 390 | $261 | 389.6 mi | 355.8 mi | 356 | $239 | 390 |
91% excess
|
| 14 | Philmon Mehari | 1 | 375 | $251 | 374.6 mi | 340.7 mi | 341 | $228 | 375 |
91% excess
|
| 15 | Shady Messak | 1 | 371 | $249 | 370.8 mi | 337.0 mi | 337 | $226 | 371 |
91% excess
|
| 16 | Jason Yenser | 1 | 312 | $209 | 312.0 mi | 278.2 mi | 278 | $186 | 312 |
89% excess
|