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 | Jason Yenser | 11 | 670 | $449 | 60.9 mi | 26.3 mi | 289 | $194 | 60.9 |
43% excess
|
| 2 | Alberto Galan | 11 | 442 | $296 | 40.2 mi | 9.4 mi | 104 | $70 | 40.2 |
24% excess
|
| 3 | Israel Martell | 9 | 290 | $194 | 32.3 mi | 18.1 mi | 163 | $109 | 32.2 |
56% excess
|
| 4 | Shady Messak | 8 | 227 | $152 | 28.4 mi | 2.6 mi | 21 | $14 | 28.4 |
9% excess
|
| 5 | Rick Charles | 2 | 145 | $97 | 72.3 mi | 18.8 mi | 38 | $25 | 72.5 |
26% excess
|
| 6 | Curtis Allen | 6 | 143 | $96 | 23.9 mi | 1.8 mi | 11 | $7 | 23.8 |
8% excess
|
| 7 | David Trost | 5 | 129 | $86 | 25.8 mi | 13.2 mi | 66 | $44 | 25.8 |
51% excess
|
| 8 | Michael Steencken | 1 | 98 | $66 | 97.7 mi | 79.2 mi | 79 | $53 | 98 |
81% excess
|
| 9 | Darrell Hope | 3 | 86 | $58 | 28.8 mi | 9.4 mi | 28 | $19 | 28.7 |
33% excess
|
| 10 | Bryan Rodriguez | 2 | 65 | $44 | 32.4 mi | 13.9 mi | 28 | $19 | 32.5 |
43% excess
|
| 11 | Rodney Charles | 1 | 57 | $38 | 56.7 mi | 39.9 mi | 40 | $27 | 57 |
70% excess
|
| 12 | Davon Cox | 2 | 53 | $36 | 26.5 mi | 22 mi | 44 | $29 | 26.5 |
83% excess
|
| 13 | Andre Samuda | 1 | 41 | $27 | 41.3 mi | 23.5 mi | 24 | $16 | 41 |
59% excess
|
| 14 | Fady Khouzam | 2 | 36 | $24 | 17.9 mi | 14.6 mi | 29 | $19 | 18 |
81% excess
|
| 15 | Chris Galasso | 2 | 16 | $11 | 7.8 mi | 0 mi | 0 | $0 | 8 |
0% excess
|