This global Pharma company required a worldwide, non-central, patient-based financial forecasting solution that is well-integrated end to end with various other systems. Their intention was to step away from typical siloed approach of forecasting, to make it more cross-functional and collaborative.
They also required the ability to model forecasts from a driver-based perspective, linking it to patient data and driving superior decision-making.
Solution
The solution created patient-based forecast models by therapeutic area and developed market share uptake simulator using Scenario Planning and Statistical Forecasting Techniques.
Consolidation of sales planning and price-volume analysis with production planning considering inventory and distribution constraints enabled them to review feasibility of the connected plan at country and global levels.
Results
Enabled cross-country comparisons
Aligned supply chain forecast with commercial & financial forecast
Promoted Finance, Commercial, Supply Chain and IT working as one.
Enabled easy integration of other IT infrastructure components such as SAP FIT B/W, Amazon Data Lake, CDE Data, Qliksense for analysis and action
