Pharmaceutical Company

This company is engaged in manufacturing and distributing over-the-counter pharmaceutical products. The demand profile for their products is characterized by high seasonality as well as extreme volatility caused by wholesalers.

We helped them identify the major drivers of demand volatility. We designed and developed a process to segment customer demand volatility and major demand clusters for better supply chain execution

• Develop a robust demand forecasting process with an emphasis on exception management.
• Leverage customer information through VMI and CPFR depending on the size of the customer.
• This process helped the company achieve monthly revenue forecast error within +/-2% and annual revenue estimate error for the division within +/-5%.
• The division’s item level absolute accuracy improved from 50% MAPE to 25% MAPE with in a year after going live with this process.
• The realized savings included both reductions in inventory as well as improvement in customer service as measured by the First-time Fill Rate.