Articles

Why Forecasting Retail Sales, Then Shipments is a Best Practice 

Shipments and retail sales are different things. In CPG sales planning, the lowest common denominator is shipments.  They are needed to operate.  In some cases, retail sales are planned.  But in most, it’s used as a backward-looking key performance indicator (KPI).   

When it’s not planned, sales and spending forecasting and analysis opportunities are left on the table:    

Alignment With Your Customers. Retail Sales are your (retail) customer’s language.  A forecast of retail sales will help create alignment on expectations for promotion performance.  

Proper Definition and Use of Base & Incremental Volume.  Base and Incremental sales are fundamentally retail sales metrics. Base volume is the level of retail sales you expect when promotions are not present. Incremental volume is retail sales that are attributed to price reductions, advertising, displays and other promotion tactics.  When you forecast retail sales base volume, you create a plan that is directly comparable to the actuals you acquire from retailers and syndicated data vendors.

Understanding Promotion Effectiveness. You run promotions to incentivize shoppers to purchase your product (retail sales), not to incentivize your customers to ship product.  When you forecast & actualize retail sales, and learn from results, you can continuously fine tune the offers you make to shoppers. This helps you build credibility with your customers.  

Improve the Accuracy of Spending Forecasts.  Scan allowances are driven by retail sales. When you forecast retail sales and shipments, you can more accurately forecast spending by calculating billbacks and OI with shipments forecast, and scans on retail sales. 

Understand Forward Buy Volume & Spending.  Forward buy when there is an OI or billback deal is not desirable.  You do not optimize profit on non-promoted sales because the product was purchased on deal.  If you forecast both retail sales and shipments, you can differentiate the two types of volume and improve the accuracy of volume & spending forecasts.  

For example, you may have a promotion for which you expect to sell 5,000 units/500 cases.  But… a) the customer has existing inventory and will only order 400 cases, or b) the customer has a tendency to forward buy and will order 600 cases.  Having discreet retail sales and shipment forecasts enables more accurate volume and spending projections.  

Best Practice in Sales Forecasting 

While retail sales forecasting is desirable for all of the reasons presented above, it usually isn’t practical for all customers.  The retail sales & shipment forecasting practice we see most often is based on customer segmentation.  Identify where forecasting accuracy improvement, better promotion effectiveness, and client alignment will have the biggest impact.  This is usually a group of “strategic” customers.  Develop a strategy to create a process in which both retail sales and shipments are forecasted and actualized.  Forecast and actualize scan promotion spending with retail sales, and OIs and billbacks with shipments.   

Retail Sales and Shipments in BluePlanner

To support this practice, UpClear’s BluePanner platform is designed to: 

  1. Manage shipment and retail sales as independent metrics.  We refer to this as “Sell-In” (shipments), and “Sell-Out” (retail sales).  Furthermore, the platform differentiates direct shipments and indirect shipments (when retailer is supplied by a distributor).   
  1. Forecast both retail sales and shipments.  The final forecasts are always determined by the user given that permission, but we offer AI that automates and predicts volume. “SmartBase,” an UpClear Data Enabler, is BluePlanner’s retail sales-based predicted base volume. BluePlanner TPO has volume lift predictions that are based on the pricing and promotional offers planned in promotion simulations and scenarios. That lift factor is used to calculate the incremental volume forecast. 
  1. Automatically populate the shipment forecast from the retail sales forecast.  BluePlanner can automatically convert and populate the retail sales (sell-out) forecast to shipments (sell-in) for both base and promotion volume. This is often the desired starting point.  From there, the user is able to make adjustments to account for existing inventory or forward buy.  
  1. Import actual shipments and retail sales.  We work with your team to understand the data landscape and design the methods by which we import data from different sources.  This can include a completely turn-key process that automatically loads retail sales daily.  
  1. Integrated forecast, projected, and actual performance metrics. Manufacturer profitability statement and ROI with “return” (incremental profit) driven by retail sales volume and price. Retailer revenue and profits metrics with every promotion.  Retailer cost metrics that use upcharge-inclusive distributor prices.    

About UpClear 

At UpClear, our mission is to empower Consumer Goods brands to maximize revenue performance and trade investment returns through intelligent, collaborative software—providing a single source of truth, streamlined automation, and actionable insights. 

BluePlanner Revenue Management software supports end-to-end processes, from Annual Operating Planning to Account Planning and Execution

Join our Sales Planning Share Group

See Blueplanner in action

Save the Date:

Want more resources like this?

Follow UpClear on LinkedIn.

More Resources

Bissell & UpClear : Powering Smarter Growth 

Bissell Homecare, a family-owned leader in home cleaning solutions since 1876, is renowned...

UpClear’s Annual Elevate NYC Event: Largest Yet 

On Thursday, May 15th UpClear welcomed over 30 representatives from leading Consumer Goods...

Nichols Plc. and UpClear: Partners for Trade Promotion Management in the UK

Nichols Plc is a UK-based international soft drinks brand with a portfolio that includes i...

Unlock growth with clarity and confidence with BluePlanner by UpClear

We're here to help.
[email protected]

UpClear Logo
UpClear © 2025
Privacy Policy
website design new york city