For years, Excel has been the backbone of supply chain planning and S&OP. Flexible, familiar, and available in every organization. When planners need to react quickly to changing forecasts, supply disruptions, promotions, or operational exceptions, spreadsheets are often the most intuitive way to adjust.
And to be fair, Excel still solves a lot.
The challenge is that as companies grow, planning complexity grows even faster.
More products. More constraints. More stakeholders. More pressure to align supply chain, operations, sales, and finance around the same decisions.
That is often where spreadsheets start reaching their limits. Not because Excel suddenly stops working, but because the business starts demanding a level of planning maturity spreadsheets were never designed to support.
Why companies still use Excel for Planning
Excel is already available across the organization. There is no implementation project, no dependency on IT, and no waiting time before planners can start building logic around operational reality. That flexibility matters. Especially in industries dealing with promotions, seasonality, shelf life, supply volatility, or customer-specific exceptions. Planners value the ability to quickly override assumptions, rebalance supply, adjust volumes, and respond under pressure.
Excel also fills an important gap left by many ERP systems. ERP systems are designed for execution and transactions. Planning requires evaluating trade-offs, comparing scenarios, and aligning functions under uncertainty.
That is why spreadsheets often become the unofficial planning layer on top of the ERP landscape.
And for a while, that works.
Where Excel starts breaking down
Excel works well until planning complexity starts exceeding what spreadsheets can realistically support. As companies grow, supply chains become more interconnected, constrained, and volatile. Planning complexity grows faster than spreadsheet governance.
That is where the limitations start becoming visible.
Scenario Planning becomes too slow
Planning today increasingly depends on evaluating alternatives continuously. In Excel, managing multiple scenarios often means duplicating files, changing assumptions manually, and consolidating outputs afterward. That process quickly becomes labour-intensive.
What we often see is that only one planner fully understands how all scenario logic fits together. The result is slower decisions, more planner dependency, and increasingly reactive planning.
And by the time a second or third scenario is completed, the business question has often already changed.
Excel does not scale with planning complexity
Most spreadsheet models work reasonably well at small scale. But supply chains rarely stay simple:
SKU portfolios expand, networks become more global, constraints tighten, promotions increase and financial pressure grows.
Suddenly, planners are no longer managing isolated numbers. They are managing interdependencies across demand, supply, inventory, production, sourcing, shelf life, and financial targets. This is where spreadsheets become increasingly fragile.
In many organizations, planning logic becomes fragmented:
- separate files per plant
- separate assumptions per category
- separate versions per planning cycle
Locally, each plan may appear feasible. Globally, nobody sees the complete picture.
Local optimization does not guarantee network feasibility.
Version control becomes decision friction
Most planning organizations recognize this situation immediately:
"Can someone send me the latest version?"
Multiple spreadsheets circulate simultaneously across supply chain, finance, sales, and operations. Different teams work with different assumptions. Nobody is fully certain which numbers are correct anymore. As a result, alignment meetings gradually become reconciliation exercises instead of decision-making sessions.
The issue is not that Excel cannot calculate. The issue is that spreadsheets struggle to create one shared operational reality across functions.
The hidden risk: planner dependency
Many planning environments rely heavily on custom spreadsheets built over years. Eventually, critical planning knowledge exists inside one spreadsheet maintained by one person. That creates a significant organizational bottleneck.
If that planner becomes unavailable or leaves the organization, the planning process itself becomes vulnerable. What initially feels flexible gradually becomes difficult to maintain, difficult to improve, and difficult to scale.
Final thought
Excel remains an extremely powerful personal productivity tool. But spreadsheets were never designed to support complex planning processes across growing organizations operating under constant volatility.
As companies grow, spreadsheets become increasingly difficult to govern, align, maintain, and scale. The issue is not whether Excel works. The issue is whether it still supports the planning maturity the business requires.
As planning complexity grows, manual processes and fragmented planning logic increasingly become bottlenecks.
.jpg)
