But forecasting trade promotions isn’t the same as forecasting total sales.
Here’s an overview of how they differ and why getting each strategy right, matters.
Trade promotions refer to temporary discounts, coupons, rebates, and other incentives that brands offer to retailers to boost product sales.
Forecasting for trade promotions involves predicting the expected incremental sales lift during a promo period. Key inputs include:
The output is the estimated units or dollar value goal the brand expects to hit during the promotion.
This incremental forecast feeds into the overall sales forecast and helps set trade promotion budgets.
The total sales forecast projects the overall expected revenue/units for a brand across regions, products, channels, etc. Key inputs include:
Total sales forecasting assembles inputs from trade promotion plans, historical data, macro trends, leadership goals, and more. It requires modeling and extrapolating a wider range of variables.
Sales forecasts serve an important purpose in validating and fine-tuning demand plans.
Demand planning uses historical shipment and consumption data to project expected sales by product.
Sales forecasts can verify if these demand projections make sense for the upcoming period based on qualitative insights like:
By comparing demand plan outputs versus sales forecast numbers, planners can:
In this way, sales forecasts add an invaluable qualitative overlay to demand planning. They incorporate forward-looking insights that spreadsheets and algorithms miss.
Rather than wholly replacing demand plans, sales forecasts provide an additional lens to verify accuracy and uncover blind spots. This leads to superior demand planning and better sales execution.
Aligning demand planning, sales forecasting, and trade promotion strategies produces the most accurate view of the future. CPG brands that connect these capabilities will gain a winning edge.
Ideally, the incremental trade promotion forecasts will roll up seamlessly into the total sales forecast.
If promotions are forecasted too aggressively, it can skew the total forecast higher than reasonable. Make sure to incorporate ongoing checks into your process to help validate that both forecasts are always aligned!
Forecasting in Excel is tedious, time-consuming, and error-prone.
Take the guesswork out of forecasting. Vividly automates the entire sales forecasting process and updates any changes in real-time.
See how industry leaders like Liquid Death and Perfect Snacks benefit from Vividly’s intelligent forecasting.