Pharmacy, Assortment Optimization

Pharmacy Assortment Optimization

The Problem

After multiple acquisitions, this Pharmacy chain, οne of the leaders in their local retail market, was operating 2500+ stores of different sizes and formats with a too-small central team to manage assortments. One of the challenges was centralization of the decision-making process to avoid manual errors and poor alignment.

They challenged our team to extend our Demand Forecasting analytics to predict demand for ultra-low rate-of-sale products as well as our Assortment Planning solution to fully automate assortment recommendations at store level and establish a unified assortment management approach.


Dataviva Assortment Planning solution was deployed in 30 pairs of stores with 30 reference stores under user maintenance over a two-month Pilot test period. The assortment matrix was optimized based on internal and external factors such as market data, thus achieving increased customer satisfaction.

The centralization of the assortment matrix management allowed the Pharmacy chain to create a high-quality analytical base for decision-making which, in turn, increased sales and margin. The new solution is simple-to-use, easier-to-adopt and can provide a platform that can be built upon as business matures.

  • Increased Margin >4%
  • Increased Transactions per Receipt 3.5%  
  • Average Decrease per Markup 1%

Share this case:

Related Cases

Hypermarket Supply Chain

Grocery, Supply Chain

This hypermarket’s supply chain was partly managed manually and partly automated, leading to a lack of synchronization across systems and departments as well as issues in Store replenishment and Distribution Center fulfillments. With Dataviva Supply Chain solution, the company was able to boost operational efficiency, centralize and synchronize their supply chain…