Implementing Range-Based Forecasting

Leah Hoffmann

A F500 pharma company’s pricing group was moving from point to range based forecasting. As the team began to update their models, they realized they needed an expert to validate plans and processes.

Previously, the team relied on a complicated Excel spreadsheet to predict annual drug unit sales for the next 20 years. Business Talent Group’s pricing expert helped them build a SQL database to house relevant internal and market data. He then created a sophisticated forecasting system that calculated statistical confidence intervals for each projection. This system also made it easier for the team to evaluate the accuracy of its predictions and update analytical inputs. The result: a powerful, easy-to-use tool for making accurate sales predictions.


Previous Article
Centralizing Operational Excellence
Centralizing Operational Excellence

A global pharmaceutical company’s internal consulting group took responsibility for enterprise-wide transfo...

Next Article
Re-engineering Sales Operations
Re-engineering Sales Operations

The VP of Sales at a multi-billion dollar data giant was concerned about inefficiencies in the company’s gl...


Talk with BTG to learn more about our on-demand talent.

First Name
Last Name
I would like to receive the latest expert insights and news from Business Talent Group.
By registering, you agree to the processing of your personal data by Business Talent Group as described in the Privacy Statement.
View our Privacy Policy and Cookie Policy
Thank you! We will be in touch shortly.
Error - something went wrong!