To increase sales during the Christmas season, Douglas asked us to create a stock allocation model for the representative references of this period, gifsets. Based on the sales history, brand weight per store and stock available, target stock levels per SKU were assigned based on the sales accumulated during this season and the sales profile obtained from the last campaign. Stock for online channel was considered as well. Stock out and over stock at stores were measured daily using a color code to prioritize shortages that could be attended from the warehouse.
Having an important growth during the last years that triggered an expansion if their factory and warehouse, the client asked us to calculate optimum warehouse model to stock finished goods for both infraestructures and processes. To start with this project, a previous phase should be done to define warehouse sizing: a deep analysis of production planning processes.