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 | Fady Messak | 36 | 23,544 | $15,774 | 654.0 mi | 563.8 mi | 20,297 | $13,599 | 654 |
86% excess
|
| 2 | Bruce Ballard | 124 | 6,538 | $4,380 | 52.7 mi | 9.0 mi | 1,112 | $745 | 52.7 |
17% excess
|
| 3 | Andre Samuda | 7 | 5,617 | $3,763 | 802.5 mi | 699.0 mi | 4,893 | $3,278 | 802.4 |
87% excess
|
| 4 | Nkosi Wilson | 75 | 2,605 | $1,745 | 34.7 mi | 4.4 mi | 333 | $223 | 34.7 |
13% excess
|
| 5 | Luis Iser | 4 | 2,569 | $1,721 | 642.2 mi | 624.0 mi | 2,496 | $1,672 | 642.3 |
97% excess
|
| 6 | Patricia Gordon | 5 | 1,176 | $788 | 235.1 mi | 128.4 mi | 642 | $430 | 235.2 |
55% excess
|
| 7 | Bennet O Dartey | 1 | 784 | $525 | 783.5 mi | 139.2 mi | 139 | $93 | 784 |
18% excess
|
| 8 | Marvin Rivas | 1 | 653 | $438 | 652.8 mi | 589.4 mi | 589 | $395 | 653 |
90% excess
|
| 9 | Jared Heisler | 2 | 271 | $182 | 135.5 mi | 0.0 mi | 0 | $0 | 135.5 |
0% excess
|