Effeciently origanizing my wdgets for packing
October 25, 2011 8:31 PM Subscribe
How do I analyze 7 years of past orders to determine how to best organize my 6 shelves of widgets for packing future orders? Each shelf should, on average, be picked from equally.
posted by Nonsteroidal Anti-Inflammatory Drug to Grab Bag (9 answers total) 7 users marked this as a favorite
I have a warehouse of 400 SKUs. Crates of these SKUs are stored on 6 shelving units. To pack orders, I send an empty box along a conveyor belt past these 6 shelves. Each shelving unit is staffed by a worker who will place appropriate widgets into the boxes.
In order to not over (or under) work any of the staff, I want to arrange the widgets so that each shelf is used about the same amount. For example, if I knew that most orders contain item 1000 and item 1001, I would want those items on different shelves.
Continuing along this line of reasoning, I suspect I just need to organize a list of SKUs by popularity, and then arrange such that shelf 1 gets the 1st, 7th, 13th, etc popular item, shelf 2 gets the 2nd, 8th, 14th, etc popular item, and so on from there. Is this the best way? Is this a common problem in mathematics, and if so, is there a name for it?
For bonus points, I would potentially like to only have a subset of my stock out at a time, and then only pack orders with those widgets. I imagine that having smaller shelves will make it easier/quicker to identify the proper widget. If I do this, is there a way to determine the most efficient selection of SKUs to have out at time?