skip to Main Content

Stock allocation and replenishment model design of gift sets

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.

Selection and implementation of a last mile delivery software

The client asked us to lead the selection process of a Track & Trace solution to address multiple situations depending on the fulfillment location (supplier, DC, hyper, super…), type of goods (food or non-food items), volumes of delivery (small, large…), service required by customer (express, same day, next day…), distance of customer location from fulfillment location, carrier capacity, transport mode (inhouse, crowdsourced, outsourced). During the assessment, we run simulations with different scenarios in vendor’s free trial in order to check that finalists solutions really covered our client needs.

Design of stock management policies and planning model

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.

Selection of a Forecast and Replenishment software solution

Douglas Spain asked us to select a forecast and replenishment solution to optimize stock management increasing service levels and reducing inventory costs.The selected solution should provide coverage to the replenishment requirements for stores, e-commerce and distribution center. Although the client has an ERP, their capabilities to manage the demand are limited.

Design of finished product warehouse

After analysing current warehouse processes and identifying infrastructure and equipments limitation, we used information obtained during previous project phase regarding to stock sizing and flows definition, such as volumes to be handled, mono and multi client references and logistic handling units used for picking.

Software selection to fulfil e-commerce orders in hypermarkets

The client requested a functional and technical assessment of an ad-hoc solution they were developing in house and allowed them to enable picking, packing and tracking last-mile deliveries. Technically, the solution was very good to cover their needs at that moment but it wasn’t a scalable model capable to cover both future scenarios and developments required to enable detailed operations described before so, the client asked us to assess solutions available in the market.

E-commerce operation definition

The client asked us to design e-commerce operation models for food and non-food articles. These operations were designed allowing Majid Al Futtaim to be adapted according to a changing and rising demand as the e-commerce was ramping up in the region.

Design of auxiliary material warehouse

The client requested us the analysis and definition of infrastructures and handling processes of auxiliary manufacturing materials.  For this, a study was made considering the quantity to be consumed of auxiliary material by manufacturing lot, taking into account the defined stock policies (project made for finished product).