Thursday, August 18, 2011

Analytic picking route

In my previous post I showed how to use analytic rolling sums to do FIFO picking of items. But the final picking list of the solution had a weakness - the forklift driver picking the items would have to drive back and start from the beginning of each aisle in the warehouse.

In this post I show how to use analytic ranking to create a better more optimized picking route for our forklift driver to keep him happy :-)