Scenario Planning in Sales & Operations Planning
We see trends such as global changes in supply and demand, higher volatility in demand patterns and more focus on customer centricity. Because the world is changing and we are moving towards a “new normal” state, we need new perspectives on planning, supply chain management and risk. In the figure below, we have summed up the most significant trends that we see in global supply chains. Sales & Operations Planning (S&OP) processes and supply chain risk management (SCRM) have become increasingly important when developing a shared view on how to run a company. S&OP processes and SCRM provide companies with the opportunity to be proactive and in better control of the future.
As a result of this “new normal” world, we are experiencing that forecasting and planning become difficult, and we need new ways of working to:
In uncertain business environments where planning cannot be performed in a steady state, scenario planning can help improve the dialogue and decisionmaking process and ideally work as a competitive advantage to the company. The different objectives, higher efficiency and lower costs versus a resilient and agile supply chain can be supported by a well-implemented global S&OP process with scenario planning as a vital part.
The increasing uncertainty and volatility in supply and demand make forecasting challenging. Decision-making becomes harder when planning is not in a steady state. A high level of uncertainty is created by new products, tenders and high growth rates combined with traditional long-term planning that makes the forecasting process even more challenging. Therefore, a different approach, which is based on qualified assumptions rather than historical data, is required, and a structured process for scenario planning is needed. We need to understand what drives uncertainty and the root causes of risk. Then we will be able to define the relevant scenarios and options to solve the issues in those scenarios. The overall goal is to create the best possible decision proposal to support the S&OP process and, more importantly, the business strategy. An S&OP process with scenario planning will contribute to decisions about new opportunities, growth or gap closures. It will also provide reliable and high-quality decision proposals for contributing to and supporting the management’s focus on the strategic goals.
Scenario planning enables you to be one step ahead of coming events; risks as well as opportunities. Moreover, scenario planning helps to create strong and reliable decision proposals to counter and/or exploit upcoming events in order to support the overall strategy of the company. It is important to highlight the fact that scenario planning can also be used to evaluate future opportunities to secure successful exploitation. Scenario planning is a great discipline for supporting the dialogue and decision-making at S&OP meetings in a complex and volatile environment where emerging markets and long supply lead time continue to be an increasingly important factor. Scenario planning provides a structured approach to identifying drivers, scenarios and possible outcomes.
When working with scenario planning, we focus on those risks where the consequence is high, meaning that risk events with low consequences are not important to deal with from a planning perspective, as they should be part of the natural uncertainty and flexibility within the base case plan. We distinguish risk events from the structural supply chain vulnerability and impact. In order to be able to work with scenario planning in a structured way, we have defined the 5 steps illustrated in the figure below.
Scenario planning entails a number of advantages. First, risk management becomes the key focus of the decisionmaking process. It also improves the forecasting quality in a highly uncertain environment. Moreover, it shifts focus to the consequences for the business (cost, utilisation, service levels, lead time). It also allows for addressing opportunities rather than discussing bias.
First, we need to understand which factors can or will trigger a new scenario. We normally work with 4 types of triggers for scenarios, as shown to the right.
When the drivers have been evaluated, they can be linked together into a meaningful framework, usually with 5 – 10 logical groupings of drivers.
When we have identified and understood our scenario drivers, the next step is to identify and describe the different scenarios – the most important thing is to ensure that each reasonably foreseeable scenario has been identified and considered. It is important to investigate and understand if the different scenarios are interlinked. The goal is to have 2 – 3 realistic core scenarios with a clear probability and consequence assessment, but we also need to consider the speed of change or the speed with which we need to make a decision.
When searching for potential options to risky scenarios, doing a brainstorming is often the best idea. However, the brainstorming session benefits from a set of guiding option alternatives, which can be brought to the table after the initial brainstorming.
The next step is to design and describe the option ranges of the core scenarios. When the options have been described, the “game board” can be designed. The game board is a combination of scenarios and options with a clear link between the different scenarios. If the scenarios are not interlinked, you can advantageously create a game board for each group of scenarios.
As shown below an example of possible options that have been identified.
When a list of options has been found, the next step is to identify the upside and downside of each suggested option. This assessment is conducted by creating a matrix showing the three most critical scenarios in the upper row and the three best option alternatives in the first column.
A group discussion that clarifies the upside and downside of the option to each scenario will help everyone see the possible risks of and gains by selecting a specific option or doing nothing at all. Finance should be involved to estimate the financial implications. Below, an example of a risk and impact matrix is shown.
The final step is to evaluate the speed of decision based on well-defined decision horizons for typical options. Do we need a decision now or can we consider the scenario analysis as an early warning? If we need to act on the risk, it is time to create a one-page decision proposal per scenario to support the dialogue and decision-making at the S&OP meeting. The one-pager should include:
Scenario planning enables a company to discuss and evaluate the early warnings of a wide range of risk events.
The scenarios that have been assessed as early warnings need to be monitored to see how they have evolved and most likely will evolve.
Black swan events as defined by Taleb are characterised by:
In many large organisations, the ability to execute a structured S&OP process, including scenario planning, and to implement the consequential decisions is a major challenge. Many departments that each supply their own data and calculations are involved, and executing the conclusions reached will often be an intricate set of interlinked actions across the whole business unit. To battle this challenge, SAP provides a strong S&OP tool via Integrated Business Planning based on the S/4HANA database technology. The major advantages include:
Traditional forecasting techniques often fail to predict significant changes in the environment that companies operate in, especially in case of rapid changes or when information is limited. Consequently, severe challenges or great opportunities may be overlooked, and the company’s overall performance and strategy may suffer. Scenario planning supports different strategies, e.g. growth or improved profitability, but there are also several other benefits to be gained:
Enter into an honest dialogue on strengths, weaknesses, opportunities and threats
The key factor in implementing a successful scenario planning process is to get broad and meaningful involvement of key stakeholders, enter into an honest dialogue on strengths, weaknesses, opportunities and threats to the company and find a balance between plausibility and spread this kind of thinking throughout the entire company.
The monthly Sales & Operations Planning process showed significant under-capacity for the coming 12 months for one production line. It would be very difficult for production to react to any unexpected issues or market opportunities. The target is to have 10 % capacity surplus to manage monthly variations, product mix changes and demand uncertainty. The base plan showed 5 % capacity surplus. Hence, capacity-enhancing activities were needed.
In parallel, the forecast was evaluated as being too low compared to the strategic targets and, moreover, the utilisation assumptions behind the capacity plan were evaluated as being too optimistic. Both of these factors had a negative impact on under capacity compared to the base plan. In order to understand the severity and additional risk of this situation, scenario planning was applied.
Step 1 – drivers: The key drivers of uncertainty were already identified as bias in the demand forecast as well as the level of utilisation.
Step 2 – scenarios: Demand scenarios included a best-case and a worst-case scenario. The best-case scenario was based on the strategic target of growth in the company transformed into target volume increases (+y % compared to last year). The worst-case scenario was based on the current forecasts in SAP (+x % compared to last year).
Supply scenarios also included a best-case and a worst-case scenario. The best-case scenario was based on the optimistic utilisation assumption, which was included in the base plan (index 100 %). The worst-case scenario was based on the average of historic utilisation in the last 12 months (index 94 %). These combinations and their impact on the capacity surplus were illustrated by a 2 x 2 diagram.
Scenario planning has enabled us to be more proactive in understanding risk and making decisions in due time.
Step 3 – option scenarios: Short-term capacity extension to create more surplus. However, this is not included in the risk assessment, but is part of the final recommendation.
Step 4 – risk and impact: Probability was estimated for each of the 4 quadrants in the 2x2 diagram, and the most likely outcome was evaluated as “high demand and low utilisation”, which has the worst possible impact on capacity surplus and emphasises that capacity needs to be extended by approx. 10?%.
Step 5 – recommendation: A decision proposal was created, and key messages included:
A quick decision-making situation leading to a significant increase in short-term capacity at the factory, thereby avoiding potential delivery issues and lost sales. All cross-functional departments understood the situation and were proactive in relation to risks (and opportunities) and making the extension happen.
This article was co-authored by Maja Sandberg Biltoft.
New features of SAP IBP 1905
The great digital customer experience
– and see things with new eyes
How to ignite your digital transformation journey
To automate, or not to automate, that is the question
An interview with Carsten Tirsbæk Madsen, Executive Vice President, Retail Banking, Jyske Bank.
Align your decision-making with SAP IBP
An interview with Torsten Hagen Jørgensen, Bank Director and COO of the Nordea Group, on the cultural foundation for Nordea's business transformation.
An interview with Totalkredit’s CEO Camilla Holm on the topic of trust in the financial sector.
An interview with Thomas Erichsen, CTO of Topdanmark, on going from strategy execution to strategic execution.
Short and fat projects will save your bottom line
Implement Consulting Group