Updating prices, please wait...

How to do demand forecasting in the supply chain?

Demand forecasting is important for your organisation, discover why.

What is demand forecasting?

Demand forecasting in the supply chain is a process used to determine potential future requirements of your customers. For example, the future demand of a particular product or service. Forecasting figures are usually determined by analysing historical sales data and trends based on sales and marketing activity. It’s important to be aware of market variations such as new trends, seasonal variations, and new products; all of which can impact customer demands and therefore your demand forecasting.

So why do we need to forecast future demand?

In the supply chain, demand forecasting helps to avoid the ‘bullwhip effect.’ The bullwhip effect is the distortion of demand that travels upstream in the supply chain. This is caused by:

  • Excessive inventory quantities
  • Poor customer service
  • Cash flow problems
  • Stock outs
  • High materials costs
  • Overtime expenses
  • Transport

Demand forecasting helps to reduce the risk associated with the bullwhip effect and deters this from happening.

RespImage_ihub_opmanagement_forecasting

Does sales forecasting play an important part?

The sales team are a key stakeholder in the forecasting process, as are the marketing team. They must be consulted before any forecasting figures are generated. The sales team will often be in discussion with end-users to understand customer order patterns, future requirements and potential timelines to orders being placed. Sales forecasting will feed into the demand forecasting for horizon scanning. Historical sales figures also play a key part in determining the potential accuracy of future projections on demand.

Marketing also plays a critical role in the forecasting process. Marketing often has an awareness of upcoming promotions and marketing campaigns that will deliver a potential “rush” on inventory levels when this increase in demand could occur.

How does demand forecasting link to the production process?

Demand forecasting is a vital part of the production process and contributes to the efficiency of the production area. The steps below show how demand forecasting is used within the production process.

  • Historical sales data, trends, seasonal variances, market activity and future forecast of demand are quantified
  • Demand figure is determined per inventory SKU
  • The figure is then validated by the forecasting team
  • The figure is populated into a planning system (MRP/ERP system or it can be as simple as an excel spreadsheet)
  • Production planners will use this figure to determine when and how much inventory to manufacture through the production plant

What are some forecasting techniques?

A key area to consider when forecasting is choosing whether you want to use qualitative or quantitative techniques. Examples of qualitative techniques include expert opinions and market surveys. Quantitative approaches include time series modelling which relies on ‘hard’ information.

Qualitative techniques

Advantages: Flexibility, Intuition
Disadvantages: Bias, human error, heavily reliant on opinion

Quantitative techniques

Advantages: Access to historic data, clear patterns
Disadvantages: Lacks detail, expensive method

Another technique is the Delphi method, which is based on multiple rounds of questionnaires sent to a panel of experts. This is a combined qualitative and quantitative technique and is useful when there is no historical information present.

Operations Management?

What is operations management?

Operations management is a key area within any organisation. It plays a key role in keeping supply chains operational in today’s challenging environment. Discover the key to success when thinking about operations management

Find out more about Operations Management

Listen on demand and get the latest practical insights from our panel of procurement and supply experts.

Become a CIPS member

Achieve your potential by becoming a member today. Whether you want to become a studying member or want to upgrade your membership to MCIPS, you’ll receive support and guidance whatever career level you’re at.

Sign up now

Access the latest research, whitepapers and tools across a range of key procurement and supply topics.

Member only accesslock

Bullwhip effect guide

Member only accesslock

Pareto analysis and supply chain management

Member only accesslock

Demand planning guide

Member only accesslock

Just-in-Time guide

Expand your value creation skills

"value-creation-skillstraining.jpg"

Procurement Skills Training

Accelerate your learning and keep your knowledge and expertise up to date with our Value Creation training courses.

Value Creation Training

 

expand_circle_right
  • What is demand forecasting
  • So why do we need to forecast future demand
  • Does sales forecasting play an important part
  • How does demand forecasting link to the production process
  • What are some forecasting techniques
  • Access the latest research
  • Expand your value creation skills