x

    SCM Planning for India’s Leading Manufacturer of Pharma and Allied Services

    • LinkedIn
    • Twitter
    • Copy
    • |
    • Shares 1
    • Reads 356
    • Download 17
    case study
    • Anaplan
    • Pharma
    • Manufacturing
    Problem Statement Problem Statement

    The company is facing major obstacles because of ineffective demand and supply planning methods, leading to a continuous discrepancy between supply and demand. This lack of alignment frequently results in shortages, which can have a detrimental impact on customer contentment. Furthermore, the inefficiencies in generating critical reports are being caused by reliance on manual reporting and inconsistent Excel sheets, leading to delays in gaining insights into inventory levels.

    Key Challenges Key Challenges
    • An average of 5% of SKUs were out of stock each month, indicating a significant demand-supply gap.
    • Data sources were fragmented, with three teams using separate Excel files, complicating consolidation and analysis.
    • The reporting process was inefficient, taking 2.5 days for the Penalty Report and 1 day for new product integration due to manual processes.
    • Insufficient inventory coverage resulted in stockouts, with 30% of SKUs having less than six months of coverage, leading to lost sales opportunities.
    Solution Implemented Solution Implemented
    • The model was personalized for each user, showcasing relevant KPIs and action buttons for a seamless experience.
    • Dynamic Variance Analysis enables real-time insights by comparing demand plans to forecasts.
    • Statistical demand forecasting improved accuracy by considering reorder points, safety stock, inventory age, seasonality, and granularity.
    • Efficient New Product Integration reduced integration time from days to just 30 minutes.
    • The model facilitated instant report creation, reducing the Penalty Report preparation time from 2.5 days to under 1 minute.
    Architecting with the Best Tech Stack
    • Anaplan
    • SAP LOGO
    • Microsoft Excel Logo
    Any Challenges ?
    Our Industry Experts can solve your problem.
    Business Impact
    • 98% faster new product integration from 1 day to just 30 minutes
    • 40% reduction in demand-supply gap
    • 99.92% reduction in reporting time

    More Case Studies