Most demand forecasting projects in consumer goods produce a beautiful dashboard that nobody opens twice. The model is accurate on paper. The charts are clean. And the sales rep walking into a quarterly negotiation with a retailer ignores all of it and quotes a number from memory, because the forecast never spoke their language. That gap, between a technically correct model and a number a human will defend across the table, is the whole problem. It is also where almost every demand forecasting effort quietly fails.
So I want to talk about two pieces of work our team did for a consumer-goods company, because together they show what it takes to make forecasting and trade promotion optimization land where the money is decided, not in a slide deck.
Why most demand forecasting never reaches the negotiation table
A trade promotion is a deal. A brand asks a retailer for shelf space, facings, a position near the checkout, maybe a branded cooler. In return the brand funds a discount. Both sides argue about how much volume that support will actually move. Whoever has the better answer to "how much sell-out does this drive" wins the terms.
Here is the thing nobody admits. A central demand forecasting model usually answers a different question. It predicts total category volume, or a smoothed monthly trend, or an aggregate that looks right at the company level and is useless at the level a single rep is negotiating. The rep needs to know what happens to one product, in one channel, with this much discount depth and this many facings, next quarter. If the model cannot answer that, the rep falls back on gut feel and the forecast becomes a reporting artifact.
The fix is not a bigger model. It is matching the unit of prediction to the unit of decision. The decision is quarter-level, product-level, tied to the specific promo support being negotiated. So that is exactly what the forecast has to predict.
Building sell-out forecasts the sales team trusts
The first piece of work was a set of sell-out prediction models. Instead of forecasting an abstract aggregate, they scored quarter-level volume directly from the things a sales rep can actually negotiate: product type, the level of promo support, the number of facings, and whether the product got secondary equipment placement like a branded cooler or an end-cap display.
That choice of inputs is the point. Every variable in the model maps to a lever on the negotiation table. A rep can look at the output and say, if we move from four facings to six and add a cooler, the model expects this much more sell-out this quarter. That is a sentence you can say to a retailer. It is grounded, it is specific, and when the quarter closes you can check whether it held.
We did not chase a vanity accuracy number. We built the model around the variables that change in a negotiation, because a forecast that is slightly less precise but speaks in the rep's terms gets used, and a forecast that is marginally more precise but answers the wrong question gets ignored. The outcome that mattered was not a metric on a holdout set. It was that the sell-out forecasts ended up in the sales team's hands and got pulled into real trade-promo negotiations.
That is the bar I hold demand forecasting to now. Not "is the error low" but "did a human use it to make a decision they had to defend." Most models fail that bar. This one passed it because we designed backward from the conversation it had to support.
Trade promotion optimization is a budget problem, not a prediction problem
Forecasting tells you what will probably happen. It does not tell you what to do. The second piece of work was about the decision: given a fixed discount policy and a limited budget, which promotions should run, how deep, and when.
This is where trade promotion optimization stops being a forecasting question and becomes a constrained-optimization one. Planners at the company were building promo calendars by hand. Each planner balanced revenue, profit, and budget in their head, under the constraints of the discount policy, one product at a time. It is the kind of task humans are bad at, not because they lack skill but because the search space is enormous and the trade-offs fight each other. Push discount depth to drive revenue and you burn budget and erode profit. Protect profit and you may lose the volume the retailer expects.
We built a constrained-optimization engine that took the same inputs a planner used, sales history, prices, promo calendars, price elasticity, and searched for the plan that best balanced all three goals at once, inside the discount-policy constraints. Then we did the honest comparison. We put the optimized plan next to the manual plan on the same demonstrated set and looked at what each delivered.
What the promo optimization engine actually delivered
The result was specific and, I think, more convincing than a flashy headline. The optimized plan matched the manual plan's revenue at 12% lower promo budget, and produced 9% higher profit on the demonstrated set.
Read that carefully, because the shape of the result matters more than the digits. The engine did not promise a revenue miracle. It held revenue flat, the number the commercial team cared most about protecting, and found the same outcome using less promotional money while lifting profit. That is a credible promo optimization result. It says the manual plans were leaving budget and margin on the table, not that the model conjured demand out of nowhere.
I trust this kind of result far more than a "2x your sales" claim. A consumer-goods commercial team has run promotions for decades. They are not sitting on a doubling. What they are sitting on is inefficiency, money spent on discounts that did not need to be that deep, calendar slots that cannibalized each other, budget allocated by habit. A promo optimization engine that matches revenue at lower spend is attacking exactly that inefficiency, and it does so without asking anyone to believe an unbelievable number.
How the two pieces fit together
Forecasting and optimization are often sold as the same thing. They are not, and treating them as one is why so many projects underdeliver. The sell-out models answer "what will this promotion drive." The optimization engine answers "given everything we could run, what should we run." You need both, and you need them connected, the elasticity and volume signals from the forecasts feeding the constraints the optimizer searches within.
The deeper lesson across both is the same one from the start. Demand forecasting in consumer goods is not won by the most sophisticated algorithm. It is won by matching the model to the decision a human has to make and defend, the rep in a negotiation, the planner building a calendar. Get that match right and the model gets used. Get it wrong and you have built another dashboard.
This pattern, prediction tied to the real lever and optimization that respects real constraints, is the same one our team has carried through retail, pricing, and supply-chain work across more than a hundred enterprise projects. You can see more of that work in our case studies, and the broader retail and supply chain approach sits alongside it.
If you run trade promotions and your forecasts are not reaching the negotiation table, that is the problem worth fixing first. Book a call and we will look at where your current planning is leaving budget and margin behind.