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 | Luis Iser | 1 | 1,043 | $699 | 1042.7 mi | 1020.5 mi | 1,021 | $684 | 1043 |
98% excess
|
| 2 | Rick Charles | 17 | 496 | $332 | 29.2 mi | 9.7 mi | 166 | $111 | 29.2 |
33% excess
|
| 3 | Bryan Rodriguez | 4 | 458 | $307 | 114.5 mi | 87.6 mi | 350 | $235 | 114.5 |
76% excess
|
| 4 | Fady Khouzam | 3 | 262 | $176 | 87.2 mi | 68.2 mi | 205 | $137 | 87.3 |
78% excess
|
| 5 | Jason Yenser | 5 | 195 | $131 | 39.0 mi | 13.3 mi | 66 | $44 | 39 |
34% excess
|
| 6 | Fady Messak | 3 | 162 | $109 | 53.9 mi | 28.0 mi | 84 | $56 | 54 |
52% excess
|
| 7 | Rodney Charles | 5 | 153 | $103 | 30.6 mi | 8.4 mi | 42 | $28 | 30.6 |
27% excess
|
| 8 | Michael Steencken | 2 | 99 | $66 | 49.6 mi | 45.4 mi | 91 | $61 | 49.5 |
92% excess
|
| 9 | Shady Messak | 1 | 96 | $64 | 96.5 mi | 49.7 mi | 50 | $34 | 96 |
52% excess
|
| 10 | Konstantin Barskiy | 1 | 96 | $64 | 96.5 mi | 74.3 mi | 74 | $50 | 96 |
77% excess
|
| 11 | Eric Mancerella | 1 | 33 | $22 | 33.5 mi | 21.2 mi | 21 | $14 | 33 |
64% excess
|