Advanced Planning Tool, ERP, or Spreadsheet?

As mid-sized companies scale, the systems that once “worked just fine” start to fail quietly—and then suddenly. What began as a few tabs in Excel grows into a web of spreadsheets that don’t talk to each other. ERP planning modules, once seen as a one-stop shop, begin to show their limits under the strain of variability, global sourcing, and customer service demands.

So what’s the right planning strategy? Stick with spreadsheets? Upgrade the ERP? Or invest in an advanced planning tool?

This blog breaks down each approach and offers a practical guide to help you choose the right path for your business, backed by industry data and real-world examples.

---

Option 1: Spreadsheets

Still common—but a risk under pressure

Spreadsheets remain the dominant planning method for small to mid-sized supply chains. Why? They’re flexible, familiar, and don’t require new software investment. But as the business grows, so do the limitations:

• • 68% of supply chain planners still use spreadsheets as their primary planning tool (Gartner, 2023), but most cite them as a source of errors, lack of visibility, and poor responsiveness.

• • Spreadsheets don’t support real-time collaboration, which leads to siloed decision-making and version control nightmares.

• • They are reactive, not predictive—there’s no built-in ability to simulate changes, model risk, or proactively plan across functions.

The result: Poor service levels, excess inventory, fire-drill planning, and missed opportunities.

Option 2: ERP-Native Planning

Convenient, but not built for agility

ERP systems often include planning modules—whether it’s SAP IBP, Microsoft Dynamics, Oracle NetSuite, or others. These tools are fine for basic needs but tend to fall short as supply chain complexity increases.

Common limitations:

• • Slow data refresh cycles – no real-time visibility into shifting demand or supply

• • Hard-coded logic – little flexibility to model unique business processes

• • Limited scenario planning – often require separate tools for “what-if” analysis

• • Poor usability for planners – workflows often built for finance, not supply chain users

According to a study by McKinsey, “ERP-native planning modules often fail to support today’s volatility, especially in organizations with multi-tier or global networks” (McKinsey, 2022).

ERP works well for execution—but planning is a different game. When you need to model trade-offs, mitigate risk, or react quickly, it often becomes a bottleneck.

Option 3: Advanced Supply Chain Planning Tools

Solutions like Kinaxis Planning One, ketteQ, and others are purpose-built to handle today’s supply chain volatility—particularly for growing mid-sized companies that want enterprise-grade capabilities without enterprise bloat.

Key capabilities:

• • Concurrent planning – Align supply, demand, and inventory in real time

• • What-if scenario modeling – Assess the impact of changes before they happen

• • Collaboration across silos – Sales, operations, and finance can work together

• • Integrates with your existing ERP – Extends rather than replaces your tech stack

According to Gartner, companies that adopt advanced planning tools reduce inventory by up to 20% while improving service levels by 10–15% (Gartner Supply Chain Planning Guide, 2023).

Mid-market advantage:

Platforms like Kinaxis Planning One are designed specifically to bring advanced capabilities to mid-sized enterprises, with:

• • Faster time to value

• • Lower IT overhead

• • Subscription-based pricing

• • Cloud-native delivery

Real-World Indicators You’ve Outgrown Your Current Planning Approach

sk yourself:

• • Are we relying on tribal knowledge to fill data gaps?

• • Can we see the impact of supplier delays or demand spikes instantly?

• • Are planners spending more time cleaning up than planning ahead?

• • Is our service level performance tied to manual effort?

If the answer is “yes”

You Don’t Have to Rip and Replace

A common fear in the mid-market: implementing advanced planning will be too disruptive or expensive.

In reality, modern planning platforms are designed for phased adoption—a crawl-walk-run approach that lets you start with what matters most: visibility, collaboration, or inventory optimization.