APPROACH

                          We predicted store replenishment quantities for each item sold across the retailer expanse using a combination of internal shipping data, point of sales, inventory and invoice inputs at the retailer level. We did this by:

                          • First, determining product level seasonality and underlying daily sales variations
                          • This information was used to forecast expected future sales
                          • Multiple forecasting techniques using time series trends, in combination with store and product related factors were considered
                          • Relevant constraints were applied to forecast quantities such as the minimum order quantity required for a replenishment trip to a store, the total capacity of a store, and the threshold below which an inventory replenishment will be required

                          KEY BENEFITS

                          • Our solution provided an intuitive interface for over 500 users, with reports on sales performance and sell-in recommendations
                          • Provided a single, comprehensive veiw of total business performance by Integrating information across retailers

                          RESULTS

                          The intuitive and easy-to-use interface provided critical metrics, which helped the client reduce onground execution of tasks such as:

                          • Adherence to route plan
                          • Root cause for missed replenishments
                          • “Loss tree” that captures value lost at various stages of execution owing to non-adherence, Standard Operating Procedure

                          The client was able to generate precise ROI by capturing trends with respect to lost opportunity and stock outs, in near real-time.

                          538porm