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.