Case Study: Forecasting CoE

Building intuitive global forecasting

The client

The new Vice President of Analytics for this global pharmaceutical organization was challenged with streamlining global product reporting and forecasting across more than 20 countries. His vision was to create a global forecasting centre of excellence (CoE) with a dedicated team of full time experts who could support agile enterprise forecasting needs.

The challenge

The forecasting team was working out of three locations to build and update complex Excel based models for eight brands and dozens of products. Their existing manual processes meant the team spent most of its time consolidating and updating multiple Excel files and PowerPoint decks to keep up with requests from the business, including support for new product launches. The result was a slow, error-prone process with poor version change management, and no time for the forecasters to add value with strategic insights.

The solution

Scarsin was selected to build a pilot program to test the platform for two products. In the first 60 days, the client was so impressed, they added the remaining brands to the mandate. Within three months, Scarsin had built models for all brands, including Monte Carlo functionality to support sensitivity analysis.

The client was also impressed with the flexibility of the Scarsin platform to support a corporate restructuring during which the forecasters were able to keep working seamlessly. The models were complete in time for the new forecasting season, and Scarsin soon added consolidated dashboards for senior executives and brand managers to access via the web and mobile solutions.

The results

With the Scarsin platform, the Forecasting CoE was able to deliver significant value to the business including:

70% faster forecast delivery, with 50% fewer resources
Accurate, consistent and insightful forecasts
Improved collaboration, productivity and decision-making
Intuitive, interactive tools for long range forecasting across divisions
Simple dashboards that empower executives, finance managers and brand team leads to make faster, more informed decisions
More efficient forecasting processes across the global organization
Live internal dashboards that demonstrate how assumption changes affect disease and financial forecasts

“Consolidating forecasting models across countries and teams has given us key insights into market growth. “ – Vice President of Analytics

Learn more

Book a demo today to see how our powerful models and simple tools drive productivity and insight that build your competitive advantage.