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 | Ryan Lewis | 76 | 22,205 | $14,877 | 292.2 mi | 230.4 mi | 17,510 | $11,732 | 292.2 |
79% excess
|
| 2 | Allan Klus | 106 | 6,466 | $4,332 | 61.0 mi | 20.8 mi | 2,208 | $1,479 | 61 |
34% excess
|
| 3 | Patricia Gordon | 29 | 4,468 | $2,994 | 154.1 mi | 30.1 mi | 873 | $585 | 154.1 |
20% excess
|
| 4 | Jeffrey Coles | 31 | 3,794 | $2,542 | 122.4 mi | 75.5 mi | 2,339 | $1,567 | 122.4 |
62% excess
|
| 5 | Fady Messak | 9 | 2,617 | $1,753 | 290.7 mi | 228.4 mi | 2,056 | $1,378 | 290.8 |
79% excess
|
| 6 | Joe Hudson | 11 | 1,029 | $689 | 93.5 mi | 53.5 mi | 589 | $395 | 93.5 |
57% excess
|
| 7 | Rick Charles | 5 | 985 | $660 | 196.9 mi | 181.4 mi | 907 | $608 | 197 |
92% excess
|
| 8 | Fady Khouzam | 3 | 859 | $576 | 286.4 mi | 266.4 mi | 799 | $535 | 286.3 |
93% excess
|
| 9 | Raymond Ebanks | 1 | 756 | $507 | 755.6 mi | 629.8 mi | 630 | $422 | 756 |
83% excess
|
| 10 | Solomon Young | 15 | 514 | $344 | 34.2 mi | 17.5 mi | 262 | $176 | 34.3 |
51% excess
|
| 11 | Nkosi Wilson | 1 | 497 | $333 | 497.2 mi | 488.7 mi | 489 | $328 | 497 |
98% excess
|
| 12 | Israel Martell | 1 | 299 | $200 | 299.1 mi | 280.5 mi | 280 | $188 | 299 |
94% excess
|
| 13 | Fanfan Siku | 1 | 245 | $164 | 244.7 mi | 224.3 mi | 224 | $150 | 245 |
91% excess
|