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 | 58 | 17,693 | $11,854 | 305 mi | 250.8 mi | 14,547 | $9,746 | 305.1 |
82% excess
|
| 2 | Jeffrey Coles | 28 | 3,449 | $2,311 | 123.2 mi | 79.1 mi | 2,216 | $1,485 | 123.2 |
64% excess
|
| 3 | Allan Klus | 48 | 3,128 | $2,096 | 65.2 mi | 31.2 mi | 1,497 | $1,003 | 65.2 |
48% excess
|
| 4 | Patricia Gordon | 12 | 1,625 | $1,089 | 135.4 mi | 10.2 mi | 123 | $82 | 135.4 |
8% excess
|
| 5 | Fady Messak | 4 | 891 | $597 | 222.7 mi | 189.7 mi | 759 | $509 | 222.8 |
85% excess
|
| 6 | Fady Khouzam | 3 | 859 | $576 | 286.4 mi | 266.4 mi | 799 | $535 | 286.3 |
93% excess
|
| 7 | Joe Hudson | 8 | 800 | $536 | 100 mi | 63.7 mi | 509 | $341 | 100 |
64% excess
|
| 8 | Raymond Ebanks | 1 | 756 | $507 | 755.6 mi | 629.8 mi | 630 | $422 | 756 |
83% excess
|
| 9 | Rick Charles | 3 | 676 | $453 | 225.2 mi | 219 mi | 657 | $440 | 225.3 |
97% excess
|
| 10 | Solomon Young | 6 | 135 | $90 | 22.5 mi | 7.1 mi | 43 | $29 | 22.5 |
32% excess
|