Demand Planning Beyond the Spreadsheet

In an industry that prides itself on operational efficiency, there's a striking irony: the majority of FMCG companies still run their demand planning on spreadsheets. Not as a supplement to a planning system, but as the system itself.

Excel files passed between commercial, supply chain, and finance teams. Manual adjustments layered on top of statistical baselines. Version control managed by file naming conventions. Forecast accuracy debated in meetings where everyone has a different number.

It's not that these companies don't know better. It's that the cost of poor demand planning is diffuse. It shows up as excess inventory here, a stockout there, a margin miss at quarter-end. It's hard to attribute, easy to explain away, and expensive to fix without a clear picture of what's broken.

The True Cost of Immature Demand Planning

Poor demand planning in FMCG doesn't announce itself with a single catastrophic failure. It erodes value quietly across the entire operation:

• Excess inventory and waste: Over-forecasting ties up working capital in finished goods that may expire, require markdowns, or simply sit in warehouses consuming space and cost.
• Stockouts and lost sales: Under-forecasting means empty shelves, missed promotions, and customers switching to competitors. In retail, recovery from a stockout can take weeks.
• Production inefficiency: When the factory doesn't trust the forecast, it over-produces to buffer. Changeovers increase. Scheduling becomes reactive. OEE suffers.
• Margin erosion: Expedited shipments, last-minute raw material purchases, overtime shifts: the downstream costs of forecast inaccuracy flow straight to the P&L.
• Team misalignment: When commercial and operations don't share a common demand signal, every decision is a negotiation. S&OP becomes a political meeting rather than a planning process.

The cost of a bad forecast isn't the forecast itself. It's every decision downstream that was made on wrong assumptions.

What Maturity Looks Like

Demand planning maturity isn't binary. It's a spectrum, and most FMCG companies sit somewhere in the middle: not entirely broken, but far from optimized. Here's how the spectrum typically breaks down:

Level 1: Reactive

Planning is driven by historical shipments and gut feel. There's no formal demand sensing. The forecast is a spreadsheet that sales fills in monthly. Accuracy is rarely measured, and when it is, nobody owns it.

Level 2: Structured

A basic S&OP process exists. Statistical baselines are generated, but manual overrides dominate. Forecast accuracy is tracked but not systematically improved. Commercial and supply chain teams meet, but consensus is rare.

Level 3: Integrated

Demand planning is connected to supply and financial planning. Forecast accuracy is a KPI with accountability. Demand sensing incorporates POS data, promotional calendars, and market intelligence. The S&OP process drives real decisions.

Level 4: Advanced

Machine learning models augment statistical forecasting. Real-time demand signals feed into planning. Exception-based management replaces manual review. Planning horizons extend with scenario modeling. The organization plans demand, not just forecasts it.

Most FMCG companies aspire to Level 3 or 4. Most operate at Level 1 or 2. The gap isn't technology. It's process maturity, data quality, and organizational alignment.

Why Technology Alone Won't Fix It

The temptation is to solve demand planning with software. Buy a better planning tool, implement an IBP platform, layer on some AI. And those tools can be transformative, but only if the foundation is ready.

We've seen companies invest heavily in demand planning technology and end up with an expensive system that produces the same bad forecasts, just faster. The tool can't compensate for:

• Data that's inconsistent across channels and systems
• Processes that don't enforce forecast accountability
• Commercial teams that override statistical baselines without evidence
• S&OP meetings that review history instead of making forward-looking decisions

Technology is an enabler, not a solution. The solution is maturity, and maturity needs to be assessed before it can be built.

The Framework Approach

Optima Demand is our proprietary framework for assessing demand planning maturity across FMCG and retail businesses. It evaluates the full planning cycle, from demand sensing and statistical forecasting to S&OP process effectiveness and cross-functional collaboration.

The assessment produces a quantified maturity score across each dimension, identifies the highest-impact gaps, and delivers a phased improvement roadmap. Not a technology recommendation, but a capability roadmap that tells leadership exactly what to build, in what order, to improve forecast accuracy and reduce the downstream costs of planning immaturity.

The Bottom Line

In FMCG, demand planning is the bridge between what the market wants and what the supply chain delivers. When that bridge is built on spreadsheets and gut feel, everything downstream suffers: inventory, production, service levels, margins.

The companies that win in this environment will be the ones that treat demand planning as a core capability, not a back-office function. And that starts with an honest assessment of where they stand today.