Supply Chain Consultancy

How to Improve your Demand Planning

3 February 2023

Stay up to date with OP2MA

Receive monthly alerts to our new content straight to your inbox.

We will only use your email address to send you alerts of new content once a month. You can change your mind at any time by clicking on the unsubscribe link at the bottom of each email. Read our privacy policy for more info.

Demand forecasting and planning may have been designed and implemented in your business in some fashion, often aided by consultants, and backed by systems. Your business probably also spends a significant amount of time each month looking at forecasting as part of a monthly routine.

As that time of the month comes around again; a new ‘forecast’ must be generated, and you are sat in another meeting to agree it. Called the S&OP (Sales & Operations Planning), or, if you are up to date on terminology, the IBP (Integrated Business Planning) meeting; you must decide on the numbers or give your perspective on what they should be. There could be at least two scenarios that typically play out.

  1. It could be that a team has conducted statistical analysis and are presenting an unconstrained demand forecast that has been built on understanding trend, seasonality, cyclical patterns, and causal factors. The focus of discussions is on the inputs to the analysis; what data has been captured and used, what assumptions are relevant and are they valid. Once aligned on the assumptions that have shaped the analysis and you now look to agree on any actions needed to shape demand toward supply capacity and commercial objectives. Note, in this scenario, the demand forecast is not expected to match the financial budget, sales target, market share objective or any other ‘plan’.
  2. Or, alternatively, some statistical analysis has been done. This forms the statistical ‘baseline’ and, because it does not match a desired number, is generally either ignored or overridden by significant adjustments. Most, if not all, of the discussion about the statistical analysis, is on the output. The monthly ‘forecasting’ meeting is characterised by the pursuit of an aligned output; the ‘one number’ forecast all functions can agree on.

There are often lengthy justifications for the different functional inputs; Sales seeking to either lower the plan (to then overachieve) or boost the plan to ensure supply, Marketing to hit objectives and justify spend, Finance to ensure adherence to budgeted revenue and expenditure.

How to make demand forecasting a strength rather than a weakness

Demand forecasting is not easy; forecasts are bound to be wrong. It can be considered a thankless task but, done well, demand forecasting can drive revenue growth whilst reducing costs and capital. If your business is closer to the second scenario, and most are, then there are some important steps to take in making forecasting a strength rather than a weakness. Importantly, it is more about people and culture than it is about statistical wizardry.

The distinction between demand forecasts and demand plans is critical

This may sound basic, and indeed pedantic, but terminology is important. For clarity in this discussion, we will work with the following definitions:

  • Forecast - an estimate of future demand based on analysis of data and derived by application of statistical formula or algorithms.
  • Plan – a structured set of activities expected to create a defined demand. The component elements of the plan may be estimated by statistical analysis and/or the application of domain knowledge.

This distinction is critical; to drive improved accuracy and derive maximum benefit from a forecasting process, businesses need to be comfortable with, and value, estimates of demand that do not match plans, budgets or targets. The fundamental concept is that by creating an unconstrained forecast of demand, the business can apply a data-driven approach, using the ever-increasing amount of data available to gain dynamic insights, remove, or greatly reduce, bias in the generation of forecasts and plans and respond pro-actively to emerging demand, with coherent cross-functional actions.

Forecast error is a fact of life

There are some factors that compound it:

  • Bias – driving demand forecasts to hit a desired number
  • Consensus – achieving compromise by fudging a number
  • Disaggregation – working at a higher level in a product, regional or organisational hierarchy and then cascading this estimate to lower levels, wiping out any significant granular variations
  • False patterns and relationships – mistakenly identifying links and factors, allowing judgements of what could relate but does not.

We need to qualify the performance expected of a demand forecasting and planning process. There are two key dimensions:

  1. Supply chain tolerance; what is the degree of error that the activities across the supply chain can manage? We may wish for minimal error, but we need to be clear on when variance to forecast and plan starts to cause real disruption, drive up costs and draw in working capital.
  2. Forecastability- what are the demand characteristics of the products we are seeking to forecast? Are they high volume with stable sales patterns? Are they apparently erratic with spikes that are difficult to explain?

A good starting point to understand forecastability is to determine how variable demand is for a product and compare this to sales volume. This will allow products to be segmented based on their demand patterns. A pragmatic segmentation of products is likely to include:

  • High volume/Low variability:
    • Strong patterns and clear causal factors should make for accurate forecasting
    • Can form the baseload for efficient supply chain operations
  • High volume/High variability:
    • Likely to be event driven, so understanding event triggers and capturing data and information becomes the focus of forecasting efforts
    • Supply chain design will need to support flexibility
  • Low volume/High variability:
    • Forecasting effort will need to be gauged based on the profitability of items in this category. Again, understanding what prompts demand will help identify if further data capture will support forecasting
    • Likely to be managed by either buffer inventory or designing the supply chain to respond in a timely manner
  • Low volume/Low variability
    • With steady demand patterns, an automated approach should release resources for focus elsewhere
    • Managing production and inventory of these items will need to balance quantity and frequency of replenishment. These items could be part of a ‘rhythm wheel’ approach where they play a fill in role to support asset utilisation.

Understanding the relative weight of the demand segments in your business should feed into thinking about supply chain design. Higher predictability supports lean operations, high variability requires responsiveness and the ability to adapt supply chain flows to actual demand.

With a picture of demand characteristics and an understanding of how forecast error impacts the efficiency and effectiveness of supply chain operations, suitably tailored performance measures can be set for forecasting. The focus for a programme to improve forecast accuracy can also be defined by understanding variability and assessing the data that needs to be captured and analysed to inform the core forecasting equation, namely: trend, seasonality, cyclical patterns, causal factors, randomness and unexplained variance.

Trend, seasonality, and cyclical patterns are the mainstay of standard statistical approaches to forecasting and rely on robust sales history. Applying regression techniques to determine causal relationships with factors such as price, marketing, sales promotions, and competitor activities is an area of significant opportunity as more data is captured and shared. The technology and skillsets to combine these techniques requires investment and should be gauged on the specific circumstance and needs of the business.

Changing mindsets is critical business success

We are increasingly awash with data. As Artificial Intelligence (AI) is applied to process and sift vast datasets in more sophisticated ways, businesses can start to access the analytical tools needed to take demand forecasting capabilities to new levels. Many businesses, however, show a marked tendency to believe that investing in technology alone will solve a problem or radically improve performance. Supply chain improvement initiatives, in particular, are often predicated on new systems. In the scenarios we visited earlier, adding new analytical software to a situation where demand forecasts are vetted against personal interest will simply negate return on investment or even create a negative outcome.

Whilst technology can play an important role, the approach and mindset of the people that prepare and confirm the demand forecasts and plans for the business is critical to successful, sustaining improvement in forecast accuracy. The two scenarios painted at the beginning are fundamentally about mindset. To take a data-driven approach to demand forecasting, businesses need to:

  • understand the statistical techniques increasingly available, both the opportunities and the limitations, with senior leaders critical to the positioning of analytics in planning processes
  • engage functional teams with a focus on how they contribute to and shape the inputs to forecasting
  • measure inputs to the process on the basis of the how they add to forecast accuracy
  • clearly define forecast performance expectations that reflect product and market dynamics as well as supply chain operating capabilities
  • work collaboratively to share insights and information based on domain knowledge.

Changing behaviours takes time. Incentives and key performance indicators should be developed that foster new ways of working and reduce the potential for bias and conflicting objectives. The potential offered by a data driven approach to forecasting is significant; speeding up the translation of actual demand signals into coherent demand plans (and hence supply) with unconstrained forecasts can change the whole dynamic of the process. Demand forecasting in this context is no longer a monthly chore, but a core competence that can bring competitive advantage.

Now more than ever, in a digital age, there is an opportunity to transform demand forecasting with abundant data and technology that brings analytics within the grasp of many businesses. Combining these technical advances with a culture and way of working that is data-driven, businesses can reap the benefits that improved forecast accuracy brings.

If you'd like some advice on improving the demand forecasting for your business, you can book a free discovery call with one of our experts.

Share this article
Click here to Follow our LinkedIn page for more content