Demand Planning

CPG Demand Forecasting: Why Volume Forecasts Fail Without the P&L

CPG Demand Forecasting: Why Volume Forecasts Fail Without the P&L
10 min Reading time
17 November 2026 Date published

Your demand planners have signed off on next quarter’s forecast: 1.2 million cases, up 8% on last year. Supply chain is happy. Production is scheduled. Then finance asks the question nobody can answer quickly: what does that do to gross margin?

That question shows where most CPG demand forecasting falls short. The forecast is built in units. The business is run on money. In between are promotions, trade spend, price increases, channel and pack mix, and input costs that shift every month. Each one can turn a strong volume plan into a weak profit plan.

Read Demand Forecasting: Methods, Examples, and Best Practices

This article covers the basics of CPG demand forecasting, then looks at it from the CFO’s side of the table. It explains why volume forecasts fail when they’re cut off from the P&L, and what a connected demand-to-profit forecast looks like in practice.

What Is CPG Demand Forecasting?

CPG demand forecasting is the process of estimating how much of each product consumers and retail customers will buy over a given period. Consumer packaged goods companies use it to plan production, purchasing, inventory and logistics, and to set sales targets.

It’s harder in CPG than in most industries. Margins per unit are thin, portfolios run to thousands of SKUs, retailers hold a lot of negotiating power, and demand swings with seasons, weather, promotions and competitor activity. Many products also have short shelf lives, so overforecasting leads straight to write-offs.

Common Forecasting Methods

Historical time-series models use past sales to project trends and seasonality. They work well for stable, mature SKUs.

  • Causal or driver-based models link demand to drivers such as price, promotions, distribution points and marketing spend.
  • Machine learning models pick up patterns across many variables at once, including external signals like weather or macro data.
  • Collaborative forecasting combines statistical output with input from sales, key account managers and retail partners.

Typical inputs

  • Shipment (sell-in) and point-of-sale (sell-out) data
  • Promotional calendars and planned price changes
  • New product launches and delistings
  • Distribution and listing changes by retailer
  • Seasonality, holidays and events

Most of these methods are built to answer one question: how many units will we sell? That’s essential for the supply chain. For finance, it’s only the starting point.

Related

When the Spreadsheet Becomes the Tax: A CPG CFO’s Guide to Choosing an FP&A Platform

Read

The Disconnect: Units In One Plan, Money In Another

In most CPG companies, demand planning and financial planning live in separate worlds. The demand plan sits in a supply chain tool or a planner’s spreadsheet, built by SKU, customer and week. The financial plan sits with FP&A, built by brand, channel and month, in revenue and margin.

The two meet once a month, usually in an S&OP meeting, and someone reconciles them by hand. Volumes get exported, multiplied by an average price, adjusted for a trade spend assumption and pasted into the budget model. By the time finance has a margin view, the demand plan has already moved on.

This creates three recurring problems:

  • Two versions of the truth. Sales, supply chain and finance each defend their own numbers, and meetings turn into arguments about whose spreadsheet is right.
  • Margin surprises. A forecast that hits its volume target can still miss its profit target, and nobody sees it until month-end close.
  • Slow decisions. When a retailer asks for a deeper promo or a supplier raises prices, it takes days to see the impact on the P&L instead of minutes.

5 Reasons Volume Forecasts Fail Without The P&L

Sell-in isn't sell-out

CPG brands rarely sell to the consumer. They sell to distributors and retailers, who sell on. A forecast built on shipments (sell-in) can look healthy while stock piles up in the channel. When retailers stop ordering to clear that stock, revenue drops a quarter later.

A finance-led forecast tracks both. It compares sell-in with sell-out and channel inventory, so revenue is recognized against real consumer demand, not just orders. For distribution-heavy businesses, this is often where the biggest forecasting gap sits.

Related

The Real Cost of Tariffs for CPG: What CFOs Need to Model Before Prices Hit the Shelf

Read

Promotions move volume and margin in opposite directions

Promotions are one of the biggest drivers of CPG demand and one of the biggest sources of forecast error. A promo can add a lot of volume, but it also brings price discounts, retailer funding, extra logistics cost and a post-promo dip as consumers stock up.

A volume-only forecast records the uplift and calls it a win. A P&L-connected forecast shows whether the uplift covered the cost of the promotion, and whether it just pulled forward sales from the following weeks.

Trade spend is a P&L line, not a footnote

For many CPG companies, trade spend is one of the largest costs after COGS. It covers listing fees, rebates, off-invoice discounts, promo funding and retailer marketing contributions. It’s usually agreed customer by customer and tied to volume tiers.

If the demand forecast doesn’t carry trade terms with it, finance has to apply a flat percentage. That hides which customers and promotions are profitable and which aren’t. Linking trade terms to the forecast turns gross sales into a realistic net revenue figure.

Price, mix and input costs change the answer

The same volume can produce very different margins. A shift from large packs to small packs, from modern trade to discounters, or from premium to value lines changes revenue per unit and cost per unit at the same time.

Input costs add another layer. Raw materials, packaging, energy and freight can move sharply within a single budget year. A forecast that doesn’t connect volume to a bill of materials and cost drivers can’t show how a price increase or a cost spike will land on gross margin.

One number isn't a plan

CPG markets don’t sit still. Retailers delist products, competitors launch promotions, and commodity prices swing. A single-point demand forecast gives the business one answer to a question that has several possible outcomes.

Finance teams need scenarios: what happens to margin if a key account cuts a range, if input costs rise 10%, or if a price increase lands two months late? That kind of scenario planning only works when volume, price, trade spend and cost sit in the same model.

Example: a Promo That Wins On Volume And Loses On Margin

Take one SKU at one retailer over a four-week period. The numbers are illustrative, but the pattern will be familiar to most CPG finance teams.

Line (€) Baseline (no promo) With promo
Volume (cases) 10,000 16,000
Gross sales at list 200,000 320,000
Promo discount 0 -80,000
Standard trade terms (5%) -10,000 -16,000

Retailer promo fee

0

−10,000

Net revenue

190,000

214,000

COGS

−120,000

−192,000

Gross margin

70,000

22,000

Gross margin % of net revenue

36.8%

10.3%

The demand forecast reports a 60% volume win and a 13% rise in net revenue. The P&L shows gross margin falling by €48,000.

It gets worse once you add the post-promo dip. If shoppers stocked up and the next four weeks drop by 2,000 cases, that’s another €14,000 of baseline margin lost (2,000 cases × €7 margin per case).

None of this means the promo is wrong. It may be needed to defend shelf space or win a listing. But that’s a decision finance and commercial teams should make with the margin impact in front of them, not discover at month-end.

Related

The Margin Math CPG CFOs Can’t Do in Excel Anymore

Read

What Connected Demand-to-P&L Forecasting Looks Like

The fix isn’t a better statistical model. It’s putting volume and money in the same model, so every change in the demand forecast flows straight through to revenue, trade spend, COGS and margin.

In practice, that means:

  • Driver-based planning at SKU and customer level. Volume, price, mix, trade terms and unit costs are drivers. Net revenue and gross margin are calculated from them, not typed in.
  • Sell-in and sell-out side by side. Shipments, consumer sales and channel inventory are tracked together, so you can see when the two drift apart.
  • Promotions with their full cost. Every promo in the calendar carries its discount, retailer funding and expected post-promo dip, so the forecast shows promo ROI as well as uplift.
  • Scenarios in minutes. Planners and finance can test a price increase, a cost spike or a lost listing and see the margin impact right away.
  • One shared plan. Sales, supply chain and finance work from the same numbers, so S&OP meetings focus on decisions instead of reconciliation.

How Farseer approaches it

Farseer puts the demand plan and the P&L in the same model. Demand is planned in cases, operations in capacity and finance in euros, and Farseer converts between them automatically. Change a promo volume, a customer rebate or a raw material price, and you see the impact on revenue, margin and cash straight away.

Here’s what that looks like for two CPG businesses in Southeast Europe.

Delta DMD: one of the largest CPG distributors in Southeast Europe. Delta DMD distributes brands such as Nivea, Ferrero and SC Johnson to 6,000+ active customers across 10,000+ retail outlets. Planning used to run on complex Excel models fed by SAP, with version conflicts and weeks of manual consolidation.

Today, Farseer pulls actuals, price lists, customer agreements and marketing activity directly from SAP. Planners drill down from brand to customer group, channel, SKU, sales agent and outlet, and every plan automatically reflects rebates, pricing and customer terms. A preliminary sales plan, with margin-level results, takes about ten minutes. It used to take days.

 

"From our SAP ERP, Farseer pulls all the historical data, prices, and rebates automatically."

Marko Obradović Controlling Manager, Delta DMD

Violeta: one of the largest hygiene product manufacturers in the region. Violeta has 300+ products, four factories and annual revenue above €200M. A team of 35 sales reps and brand managers plans volumes, prices and rebates for 30 brands and individual key customers. In Excel, they couldn’t plan reliably at SKU level or see profitability by brand, key customer and business branch.

In Farseer, a single volume target is distributed across customers with quantities, prices and rebates already applied. Planners can override any figure and the rest of the plan recalculates around it. Profitability reports for any product segment, customer or partner take a few clicks, at a scale of hundreds of sales and distributor locations and tens of millions of time series. Violeta saves several weeks of planning work each year.

AI that works inside your model. Before the S&OP meeting, Farseer AI flags where demand exceeds capacity and which SKUs are at risk of excess stock or lost sales. Planners can ask in plain language what a promotion, price change or supply disruption will do to margin. Farseer’s AI agents, Analyst, Strategist and Modeler, explain variances, explore scenarios and help build model logic.

Every figure is calculated by Farseer’s engine on your own data, not generated by a language model. AI answers trace back to the model, so finance can trust the number it’s signing off on.

Conclusion

A good CPG demand forecast tells you how many cases you’ll ship. A good business forecast tells you what those cases are worth. When the two are built separately, margin problems hide inside volume wins until it’s too late to act.

Connecting demand forecasting to the P&L gives finance, sales and supply chain one plan to work from. It shows which promotions pay off, which customers are profitable, and how cost and price changes will land before the quarter closes.

FAQ

What is demand forecasting in CPG?

Demand forecasting in CPG means estimating future sales of consumer packaged goods by SKU, customer, channel and period. Companies use it to plan production, inventory, logistics and sales targets.

What's the difference between sell-in and sell-out forecasting?

Sell-in is what a CPG brand ships to distributors and retailers. Sell-out is what those retailers sell to consumers. Forecasting both shows whether stock is building up in the channel, which affects future orders and revenue.

Why do CPG demand forecasts miss margin targets?

Most demand forecasts are built in units and leave out promotions, trade spend, price and mix changes, and input costs. A forecast can hit its volume target while gross margin falls.

How do promotions affect CPG demand forecasting?

Promotions increase volume during the promo but add discounts and retailer funding costs, and often cause a dip in sales afterwards. Accurate forecasting needs to account for uplift, cost and the post-promo dip together.

What role should finance play in CPG demand forecasting?

Finance should turn the demand forecast into revenue, trade spend, COGS and margin, and run scenarios on it. That works best when demand and financial planning share one driver-based model instead of separate spreadsheets.

About Author

Martina Pranjić is a Senior Content Manager with a knack for turning complex ideas into engaging stories. With experience across industries and a strong foundation in finance, she blends creativity with strategy - especially when it comes to SEO. Travel buff. Bookworm.