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.
Pratical Tips to Improve Demand Planning
If you have experience forecasting demand for products or services, you know that obtaining consistently good forecast accuracy is a mix of science and experience.
- Advanced Sales & Operations Planning Capabilities Checklist
- Getting to S&OP Success
- Supply Chain Planning Components for Private Label Success
- The Inventory Optimization Handbook
- All Resources
With more than 1,250 customers worldwide, Logility is a leading provider of collaborative supply chain optimization and advanced retail planning solutions that help medium, large, and Fortune 500 companies realize substantial bottom-line results in record time. Logility Voyager Solutions™…
- Company Quicklook
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?