Why Forecast?

Why Forecast?

What is the point of Forecasting?

This is a question asked by those who perceive no benefit or doubt the accuracy of the forecasts that they receive and sometimes, by the very people who are tasked with creating the predictions in the first place.

Of course, everyone creates, receives and uses forecasts, from the weather for today to the delivery time of yesterday's on-line order or from the latest expected pandemic infection rate to the overnight election results. You might be driving up to a traffic jam and wondering how long the delay will be or watching the last minutes of a tight sporting match and considering the likely result. So, we all forecast and often without realising or questioning it but formal, structured forecasts are business activity that can create very strong opinions.

Business forecasts abound. There are forecasts received from Customers to forecasts created for the City. There are forecasts from Sales & Marketing, Purchasing, Human Resources, Manufacturing, Inventory, Distribution, Finance and many more. These forecasts can be created from every hour to but once a year and storing, comparing and determining the best and worst is often difficult if not downright impossible. The Demand Forecast cycle might take a Month to produce, be based on biased data from another source and then be roundly abused or ignored by the receivers in Production... so why bother?

Demand Planning

Demand Planning is typically a process that creates a Demand Forecast that is then used by Buyers to create a Purchase Plan and Incoming Supply Plans, Manufacturing to create Capacity and Production Plans, Distribution to create Storage and Logistic plans, Marketing to update Product Introduction Plans, Sales to review against their Promotion Plans and Finance to create and validate against Revenue, Cost and Margin Plans.

In its most basic usage, a Demand Plan presents an expectation of what Customers will want (see point 2 in the diagram) but a Demand Forecast can do so much more! Imagine a Demand Forecast that can inform not just how many products need to be made but instantly advise the bias of Sales and Marketing and the trending accuracy of your last two Budgets as well as help define new production lines and propose locations for extra distribution centres.

In a corporate structure where planning is centre stage the Demand Plan will be created by experts who live and breathe your company data and that of your competitors. A sophisticated and innovative Demand Planning Team will be able to collect and manipulate the very latest data, collaborate with the most knowledgeable people in the business and forecast and re-forecast frequently and quickly.

Planning Maturity

How Mature is your company at forecasting? Do you have people, systems and processes that are compatible? Are your forecasts fast enough, accurate enough? used enough? Do you have a Planning Strategy? There are 4 basic stages of Planning Maturity:

  • Basic: Low maturity and little planning awareness.
  • Regular: Average maturity with growing planning awareness.
  • Strategic: High maturity and good planning awareness.
  • Innovative: Class-leading maturity with high planning awareness.
No alt text provided for this image

Find your Bias

Everyone has bias both conscious and unconscious and the same is true in your Forecasts. In planning, bias will be present in your forecast, for example the Marketing figures might be optimistic while Finances will be more pessimistic. Forecasts can also have structural bias - forecasts owned by Operations might be SKU orientated, Marketing by product group, Sales by channel, Finance by currency and so on.

Understanding bias will help you appreciate how well your Forecasts are created and consumed. Measure the accuracy and bias trends of you various forecast. How many Forecasts do you have? Who owns them? What bias do they carry? Calculate your Planning Maturity & create a Planning Strategy

The purpose of a Planning Strategy is to evaluate your maturity level and to improve it. The following areas of your business: People, Process, Technology, Information, Performance can be developed to increase maturity and enable your Company Vision. A Mature system and process requires mature resources and if your maturity is not fit for purpose, take the following steps:

  1. Create a Planning Community (internal). Either build a department or create a collaborative team. Your Business culture should dictate the format but never be lip service - this journey really can transform everything.
  2. Enable the Planning Community to gain greater understanding of Planning Principles & Learn Demand Planning skills. Discussion, Training, Brainstorm. Allow the Community to recognise the power and opportunities ahead.
  3. Allow the Planning Community to understand (and shape) the Company Supply Chain Planning Strategy.
  4. Make Planning part of The Corporate Culture. Bring the Planning Community representatives into the Board Room.
  5. Become part of the Planning Community (external). Schedule visits with neighbouring companies and competitors. Go to conferences and write white papers. Become planning leaders.

Measure your Bias

Capture and archive your forecast data and then measure the various forecasts against actuals for accuracy and bias. Compare the Statistical to the Sales Forecast to the Demand Forecast to the Budget. Even better, capture the forecasts in their raw state (before any overrides are applied) as well as their final state as this will allow you to identify if adjustments are adding value not. Consistent Bias should be identified and managed either through eradication by education or, if that proves too difficult, by adjustment.

Why Forecast?

You Forecast to reduce uncertainty, predict future demand, gain maturity, remove bias and obtain significant benefits such as reduced excess inventory and increased responsiveness.

You Forecast to anticipate change by planning for potential futures whether environmental, competitor activity or simply life cycle management. Scenario planning can start with optimistic & pessimistic versions of your existing plans and develop into a specialist Predictive Team using latest data, technology and techniques.

You Forecast to increase communication between all departments and partners and increase knowledge in everything from production capacity, to future costs and revenues. You Forecast to derive and drive Company Strategy, to grow revenues and improve margins! That's why.

Articles in this series are:

Why Forecast?

How to Forecast?

When to Forecast?

What to Forecast?

Where to Forecast?

Who Forecasts?

If you have any questions, thoughts, additions, queries or contentions about Demand Planning, Oracle Solutions or even grammar reflections please get in touch.

Cristina Ilie

Business Development Manager at H.Essers <It's Transpossible!> | Chemicals - Pharma | Logistics - Supply Chain |

4 年

Thank you for such a great article on good concepts and good practices, cutting through any fluff. Compelling reading about forecasts as business activity, not a supply chain 'nice-to-have'. And you are one of (quite) few I know having more than a 'technical dry approach on the matter, talking in clear words about structural bias: "Understanding bias will help you appreciate how well your forecasts are created and consumed. Measure the accuracy and bias trend" - brilliant.

Crispin Dobson

Supply Chain Leader with 20+ years driving innovation and optimisation at global organisations | Former Supply Chain Director | Expertise in transformation, integrated business planning, and operational excellence

4 年

Thanks #simonjoiner for a clear no nonsense discussion. Personally, I would like to see the so-called sales forecast accuracy and bias generated by finance teams reported against what the demand planners performance.

James (JJ) Porter

Global Data Quality & Integrity Manager at Nufarm

4 年

Agree knowing your data and being honest about your planning maturity are key

要查看或添加评论,请登录

Simon Joiner的更多文章

  • Still Planning in Spreadsheets?

    Still Planning in Spreadsheets?

    Spreadsheets are good! I must have 1000's of Excel, Sheets and Numbers files and I bet you do to. I've used them for…

    4 条评论
  • Cars & Forecasting: Speed or Accuracy?

    Cars & Forecasting: Speed or Accuracy?

    During 2020 lockdown I discovered a specialist television channel called Motor Trend which presents lots of shows about…

    8 条评论
  • Tuning a Statistical Forecast Part 3: Strategic Elements

    Tuning a Statistical Forecast Part 3: Strategic Elements

    Strategic Elements The key pillars of a statistical tuning program are Data & Information, Systems, Methodology…

  • Tuning a Statistical Forecast Part 2: Methodology

    Tuning a Statistical Forecast Part 2: Methodology

    Forecast Tuning Methodology. In this second article I will explain the methods that can be used to tune a statistical…

    3 条评论
  • Buy-In & Sell-Out

    Buy-In & Sell-Out

    Terminology & Significance Jargon Buy-In & Sell-Out are the terms used in Retail Supply Chain to describe the…

    3 条评论
  • Forecasting Strategy

    Forecasting Strategy

    In many of my previous articles I have talked about Planning or Forecasting Strategies. What is this Forecasting…

    5 条评论
  • Tuning a Statistical Forecast Part 1: Resources

    Tuning a Statistical Forecast Part 1: Resources

    Are the results of your Statistical Forecast not good and getting worse? Then your Statistical Engine needs tuning!…

    2 条评论
  • Demand Planning Panaceas

    Demand Planning Panaceas

    Planner, Heal Thyself! Demand Planning Pain Points are legion and can be found described in some detail in the article…

    2 条评论
  • Oracle Demantra v Demand Management Cloud: Structures.

    Oracle Demantra v Demand Management Cloud: Structures.

    This is the second in a series of articles that will compare the Oracle Demand Planning Solutions of Demantra and…

    7 条评论
  • Demand Planning Pain Points

    Demand Planning Pain Points

    There are dozens of Demand Planning Pain Points and each of them can have multiple irritations. From Information…

    9 条评论