Rossmann
Contact: Adam Marchel
Country: Poland
Award Category: Innovative Problem Solver
Tell us about the business problem you were trying to solve.
We needed to determine the optimal size for each delivery to our drugstores. This information is crucial for planning the details of our replenishment strategy.
What SAS products did you use and how did you use them?
We leveraged the power of SAS Viya Optimization and CAS to tackle this challenge.
CAS enabled us to process large volumes of data swiftly and efficiently.
Viya Optimization played a crucial role in tackling the most challenging tasks.
What were the results or outcomes?
We achieved full automation of a previously time-consuming business process.
This new process provides detailed insights on the number of distinct products to send to our drugstores over a mid-term horizon, factoring in specific business considerations like promotions, new store openings, various configurations, parameters and lots of constraints.
Additionally, it aligns with our goal of minimizing stockouts.
Why is this approach innovative?
By utilizing advanced optimization tools in SAS Viya, we were able to solve a highly complex problem that previously relied on less sophisticated tools like Excel. This new approach allows us to simulate multiple scenarios and select the one that best meets our requirements.
