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

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
The Advanced Inventory Optimization Handbook
Eight Methods to Improve Forecast Accuracy in 2019
More Logility

Latest in Supply Chain

How Businesses Can Strengthen Their Supply Chains & Build Future-Ready Supply Networks
The Elusive AI Based Supply Chain Control Tower Platform
Global Trade Trends Overview with S&P Global Market Intelligence Head
When It Comes to Digital Transformation You May Not Be Doing What You Think
Discover How Procurement is Driving Sustainability
Online Sellers Find Excellent Opportunities to Win More Customers this Easter
How Chief Operating Officers are Achieving Results with Supply Chain Software
More Supply Chain
Best-of-breed
Collaborative
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

How Roaming Shuttles Improve Order Fulfillment Operations
How Roaming Shuttles Improve Order Fulfillment Operations
Implementing this goods-to-person automated storage and retrieval technology improves customer experience, optimizes operations, and maximizes profitability.
Warehouse Contingency Planning Template
Warehouse Contingency Planning Template
We’ve taken the guesswork out of warehouse contingency planning with this downloadable editable template; from performing a risk assessment to testing...

AlixPartners 2023 Disruption Index A Bias for Action Sets Growth Leaders Apart
AlixPartners 2023 Disruption Index A Bias for Action Sets Growth Leaders Apart
In their 4th annual AlixPartners Disruption Index, business leaders cite this as the central dilemma, with 85% of CEOs telling us that it...
2023 Digital Transformation Report
2023 Digital Transformation Report
In this 2023 Digital Transformation Report, we share insights gained from our annual research on technology trends and digital transformation and explore the...
The State of Digital Transformation
The State of Digital Transformation
This White Paper Report combines our research findings with insights into what transformation truly entails – plus, guidance from our data and digital...