Baseline Sales Analysis

Consumer Packaged Goods

The Challenge

The Client is a leading manufacturer of cosmetics, skincare and haircare products.  They approached Management Science Associates, Inc. (MSA) wanting us to analyze the performance of their trade promotions.  One of their reasons for coming to MSA was that they were specifically not satisfied with the base vs. incremental sales volume estimates they were receiving from their syndicated sales data provider.  These baseline sales estimates were often higher than total sales volume, resulting in unrealistic, negative incremental sales estimates.

Members of their Trade Promotions Team felt they were wasting a lot of time on trying to come up with alternative calculations for better estimates of base sales volume.  They knew more accurate baseline vs. incremental sales volume estimates would result in better ROI calculations of their trade promotion investments.

What Did MSA Do

MSA’s goal was to provide the Client with a consistent, accurate approach for measuring sales volume driven by trade promotions (i.e., incremental), while excluding brand marketing and temporal factors (i.e., base).

MSA tested and compared the results of several modeling methodologies to determine which approach would be best for the three years’ worth of weekly data available for the Client.

In the end, MSA used a model-based approach that decomposed sales into short-term incremental volume vs. base volume driven by loyalty/momentum, seasonality and marketing factors.  For the modeled baseline estimates, MSA also considered trend and cyclical patterns, as well as factors related to distribution and competition.  The models produced estimates by sub-brand and account.

The Results

  • MSA shared the modeled results with the client, who compared them against estimates from a syndicated sales data provider.
  • The client found MSA’s baseline estimates to be more consistent over time.
  • The client also felt MSA’s results were more intuitive and easier to understand.
  • MSA’s modeling solution is highly flexible, allowing “baseline” and “incremental” definitions to be customized by industry and product category, such as including FSIs in incremental volume alongside trade promotions.

For more information on this MSA solution, please contact Kevin Mason (kmason@msa.com), Vice President.

MSA’s solutions transform complex challenges into measurable results through real-world client success stories.

Ready to work with us?

Let’s Talk
case studies

See More Case Studies

Twitter Segmentation

A beauty company wanted to communicate more effectively with their customers and direct sales reps. They felt they could enhance the effectiveness of their Twitter feeds through a better understanding of their followers. They wanted to know more about their lifestyles, interests, and who else they were following. MSA delivered this, and more, to them.

Learn more

How Wesleyville Used Savvy Citizen to Keep Residents Safe During a Historic Snowfall

Wesleyville is a quaint borough with beautiful neighborhoods located in Erie County, Pennsylvania. As a City of Erie suburb, it is located less than two miles south of Lake Erie.

Wesleyville, like other municipalities in Erie County, has the resources and experience to handle snow. The Borough averages roughly 107 inches of snow a year as compared to the state of Pennsylvania which averages only 40 inches annually. Recently, Wesleyville endured a snowfall that tested its resolve.

Learn more