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.

[wpli_login_link class='et_pb_button et_pb_button_0 et_pb_module et_pb_bg_layout_dark' text='Download this Case Study' redirect = 'https://www.tredence.com/case-study/automated-store-replenishment-for-a-leading-global-cpg-manufacturer?download=true']