This data has been adapted from a real warehouse. If you use it for a purpose other than Georgia Tech’s ISyE 6335 class, please include the following acknowledgement “This data courtesy of”.

A wholesale distributor

The customers of this warehouse are retail stores. Most of them are relatively small and order much of their stock in piece quantities. The data below shows the resulting activity in the warehouse to pick pieces.


Item master (25KB)

All distance measurements are in centimeters.

Picks (29MB)

This is a history of piece-picks, not complete customer orders.

The first several questions are checks to see how stable this data is, how useful it might be in predicting future warehouse activity.

The following questions seek to discover patterns of customer orders.

Design a forward piece-pick area

Up to now pieces have been picked together with cases. This created handling problems and so the decision has been made to create a separate process and area for piece-picking.

Initial design

The initial design calls for 30 bays of flow rack along each side of a conveyor for a total of 60 bays. Each bay is 5 feet wide and 10 feet deep. Shelf heights can be chosen as necessary.

There would be three work “stations” at equal intervals, with each station staffed by a pair of workers, one on each side of the conveyor. Each worker would be responsible for picking out of five bays.

Each order is assigned to one or more totes and each tote holds pieces for a single order. Totes flow in one direction through the flow rack. When a worker finishes picks from his zone to a tote, the tote will either be diverted across to the worker on the opposite side of the conveyor (the same work station) or else will be transported down to the next station. Product will be restocked from nearby pallet rack.


Assume 120 picks per hour from flow rack and 60 picks per hour elsewhere. Assume about 15 restocks per hour.

Use historical data as forecast for the near future.