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.
Start a Conversation
Drop us a note through this form and we'll get back to you as soon as we can.