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 | Konstantin Barskiy | 156 | 145,028 | $97,169 | 929.7 mi | 923.5 mi | 144,063 | $96,522 | 929.7 |
99% excess
|
| 2 | Luis Iser | 184 | 37,496 | $25,122 | 203.8 mi | 181.4 mi | 33,375 | $22,361 | 203.8 |
89% excess
|
| 3 | Raymond Ebanks | 171 | 29,086 | $19,488 | 170.1 mi | 159 mi | 27,192 | $18,219 | 170.1 |
93% excess
|
| 4 | Horace Barnes | 148 | 10,266 | $6,878 | 69.4 mi | 61.4 mi | 9,088 | $6,089 | 69.4 |
89% excess
|
| 5 | Derick Velazquez | 403 | 9,910 | $6,640 | 24.6 mi | 9 mi | 3,647 | $2,443 | 24.6 |
37% excess
|
| 6 | Fady Messak | 1 | 2,543 | $1,704 | 2542.5 mi | 127.1 mi | 127 | $85 | 2543 |
5% excess
|
| 7 | Kenneth Lancara | 7 | 2,403 | $1,610 | 343.3 mi | 300.4 mi | 2,103 | $1,409 | 343.3 |
88% excess
|
| 8 | Robert Lewis | 276 | 2,208 | $1,479 | 8 mi | 1.7 mi | 469 | $314 | 8 |
21% excess
|
| 9 | Yves Dessin | 3 | 1,759 | $1,179 | 586.4 mi | 543.4 mi | 1,630 | $1,092 | 586.3 |
93% excess
|
| 10 | Christopher Carroll | 1 | 1,257 | $842 | 1256.8 mi | 1152.3 mi | 1,152 | $772 | 1257 |
92% excess
|
| 11 | David Cavaco | 1 | 22 | $15 | 21.6 mi | 0 mi | 0 | $0 | 22 |
0% excess
|