S&OP Myths Part 4 – Spreadsheets are King

The topic of today's post is one we hear often and industry research shows it is not going away fast enough, the reliance on spreadsheets and other less sophisticated solutions to manage the S&OP process.

Myth: “You Don’t Need Software to Operate your S&OP Process”

Implementing a repeatable S&OP process that delivers results is not simple. If it was supply chain professionals would not still struggle with this process some 30 years after it was first introduced.

This myth has been partially perpetuated by a few S&OP consultants who advocate that an effective S&OP process can be managed using spreadsheets or a spreadsheet-based tool. If all you have is a hammer everything looks like a nail.

The use of spreadsheets could support a pilot S&OP process and might even work for a very small, relatively simple business. However, spreadsheets were not designed to provide the flexibility and functionality required to operate a typical S&OP process.

Reality: “Lack of a Robust Planning Solution Leads to Disappointment”

While a limited scope S&OP pilot process can be adequately managed using simple tools like spreadsheets, email, and PowerPoint a high-value S&OP rollout cannot be achieved without implementing a dedicated solution designed to facilitate the S&OP process. (See also: Is the Crisis in Demand Management Being Exacerbated by Spreadsheet Dependency?)

Aberdeen reported that 65% of the time spent on a S&OP process run on spreadsheets is spent on gathering data. It is probably even worse than that because there is also significant time spent collating that data, manually analyzing it and then creating graphs and tables that are used in presentations and reports.

It is very difficult to conduct multiple “what-if” scenarios using spreadsheets and if you do they would be very basic and most likely unconstrained from a supply standpoint.

Another time intensive component of running a S&OP process is the facilitation of the process itself, sharing data in the right format, aggregation, units for each key user, getting feedback back from each user in a timely fashion, and running the series of coordination and consensus meetings required to get to a balanced and aligned plan.

Spreadsheets can’t help facilitate the process and using email is very cumbersome. Whereas a dedicated S&OP solution can streamline and automate the process through embedded collaborative workflow and rules-based exception messaging.

The checklist below highlights the critical solution capabilities required to support a comprehensive high-value S&OP process. You would be hard pressed to associate these capabilities with a spreadsheet.

S&OP / IBP Solution Capabilities Checklist:

  • Integrate S&OP and Long-range strategic planning under one comprehensive planning platform
  • Perform fast simulations, comparisons and What-if scenarios
  • Compare actual performance to plan
  • Develop financial and volumetric plans with multiple currencies
  • Plan across global, regional and multi-divisional organizations
  • Assess timing, impact and risk of new product introductions
  • Visualize operational risk and develop risk management plans
  • Assess risks around key components and vendor capacity
  • Model multiple scenarios over multiple time horizons
  • Translate between detailed and aggregate plans easily
  • Support alternate product aggregations
  • Include transportation plans and costs
  • Build on existing planning and execution systems

What myths or untruths have you heard about S&OP?

Related: Sales and Operations Planning Myths - Part 3

Article Topics

Logility News & Resources

Logility makes entrance into supply chain-focused AI, with acquisition of Garvis
Logility Acquires Generative AI Supply Chain Planning Firm Garvis
Supply chain software platforms help to level the playing field
Logility to acquire supply chain network optimization vendor Starboard Solutions
Logility partners with Körber to expand capabilities
How Does IKEA’s Inventory Management Supply Chain Strategy Really Work?
This is Not Your Father’s Inventory Optimization
More Logility

Latest in Supply Chain

Investment Triggers a Manufacturing Supercycle
Supply Chains Struggle to Access Reliable Emissions Data from Suppliers
Artificial Intelligence to Drive M&A Activity in Supply Chain
Cleo Announces New Supply Chain Management Tools for Integration Cloud Platform
ASCM Honors Supply Chain Management Leaders with Awards of Excellence
US Container Traffic Boosted by Back-to-School Rush
Bank of America Introduces Digital Supply Chain Finance Platform
More Supply Chain
Optimize Service Levels

With more than 1,300 customers worldwide, Logility is a leading provider of collaborative supply chain optimization and advanced retail planning solutions that help small, medium, large, and Fortune 500 companies realize substantial bottom-line results in record time. Logility Voyager Solutions™ is a complete supply chain management and retail optimization solution that features advanced analytics and provides supply chain visibility; demand, inventory and replenishment planning; Sales and Operations Planning (S&OP); Integrated Business Planning (IBP); supply and inventory optimization; manufacturing planning and scheduling; retail merchandise planning and allocation.

View Logility company profile


Featured Downloads

Becoming a Shipper of Choice
Becoming a Shipper of Choice
C3 solutions' scheduling software streamlines the shipping process.
Thinking Differently About Supply Chain Planning
Thinking Differently About Supply Chain Planning
Political landscapes shift overnight, global trade is constantly changing, consumers demand increasingly personalized service and smaller day-to-day challenges hit without warning. If...

Rapidly Improve the Performance of Your Warehouse Logistics
Rapidly Improve the Performance of Your Warehouse Logistics
The Rapid Performance Evaluation identifies opportunities and potential improvements in every aspect of warehouse logistics operations; performance, productivity, service, quality, and systems.
Resource Management System (RMS): How to Effectively Leverage Your Assets
Resource Management System (RMS): How to Effectively Leverage Your Assets
This guide provides an in-depth analysis of the potential of various resources available in a warehouse and how they can be utilized...
Sustainable Supply Chain Insights From PITT OHIO
Sustainable Supply Chain Insights From PITT OHIO
A whitepaper on supply chain insights gleaned at the LEED-certified gold Cleveland transportation and sustainability summit.