December 25, 2020

Demand Forecasting and Demand Planning

#AtoZChallenge 2019 Tenth Anniversary blogging from A to Z challenge letter





Forecasts are vital to every business organization and for every significant management decision. While a forecast is never perfect due to the dynamic nature of the external business environment, it is beneficial for all levels of functional planning, strategic planning, and budgetary planning. Decision-makers use forecasts to make many important decisions regarding the future direction of the organization.

Forecasting techniques and models can be both qualitative and quantitative and their level of sophistication depends on the type of information and the impact of the decision. The forecasting model a firm should adopt depends on several factors, including forecasting time horizon, data availability, accuracy required, size of the forecasting budget, and availability of qualified personnel.

Various decisions in operations management like capacity creation and addition decisions, annual production plan decisions and more short term planning of work orders require forecasts of demand over various time horizons. Some forecasts of demand are made marketing and sales departments and operations management department uses them with appropriate transformation. Certain forecasts are done by the operations management department. 

Demand management exists to coordinate and control all sources of demand so that the productive system can be used efficiently and the product delivered on time. This activity requires demand forecasts. Demand can be either dependent on the demand for other products or services, or independent because it cannot be derived directly from that of other products.

Forecasting can be classified into four basic types:

Qualitative
Time series analysis,
Causal relationships, and
Simulation.


Qualitative techniques in forecasting can include grass roots forecasting, market research, panel consensus, historical analogy, and the Delphi method.  Qualitative forecasting is based on surveying and finding out intentions of people regarding use and purchase of a product. Similarly it is finding the opinion and forecast of sales persons.


Time series forecasting models try to predict the future based on past data. A simple moving average forecast is used when the demand for a product or service is constant without any seasonal variations. A weighted moving average forecast varies the weights, given a particular factor and is thus able to vary the effects between current and past data.

Exponential smoothing improves on the simple and weighted moving average forecast as it considers the more recent data points to be more important. To correct for any upward or downward trend in data collected over time periods to smoothing constants are used. Alpha is the smoothing constant, while delta reduces the impact of the error that occurs between the actual and the forecast.

Forecast errors are the difference between the forecast value and what actually occurred. All forecasts contain some degree of error, however it is important to distinguish between sources of error and measurement of error. Sources of error are random errors and bias. Various measurements exist to describe the degree of error in a forecast. Bias errors occur when a mistake is made, i.e., not including the correct variable or shifting the seasonal demand. Random errors cannot be detected, they occur normally.

A tracking signal indicates whether the forecast average is keeping pace with any movement changes in demand. The MAD or the mean absolute deviation also is a simple and useful tool in obtaining tracking signals. A more sophisticated forecasting tool to define the functional relationship between two or more correlated variables is linear regression. This can be used to predict one variable given the value for another. It is useful for shorter time periods as it assumes a linear relationship between variables.

Causal relationship forecasting attempts to determine the occurrence of one event based on the occurrence of another event.

Focus forecasting tries several rules that seem logical and easy to understand to project past data into the future.

Today many computer forecasting programs are available to easily forecast variables. When making long-term decisions based on future forecasts, great care should be taken to develop the forecast. Likewise, multiple approaches to forecasting should be used.

Forecasting needs to be done in various other areas of management like financial management, marketing management, personnel management etc. and the same techniques discussed in this article are used in those disciplines also.


Techniques of  Forecasting

Grass Roots
Market Research
Panel Consensus
Historical Analogy
Delphi Method
Time Series Analysis
Simple Moving Average
Weighted Moving Average
Exponential Smoothing
Forecast Errors
Sources of Error
Measurement of Error
Linear Regression Analysis
Decomposition of a Time Series
Causal Relationship Forecasting
    Multiple Regression Analysis.
Focus Forecasting
   Methodology of Focus Forecasting
   Web-Based Forecasting: Collaborative Planning, Forecasting,And Replenishment (CPFR)

Demand Planning


The demand planning is done based on Collaborative Planning, Forecasting,And Replenishment (CPFR). The demand planning also makes efforts to reduce bull-whip effect.

Demand Planning 2020 Articles

https://www.unioncrate.com/resources/21-best-practices-demand-planning-forecasting

https://www.gitacloud.com/blog/2020/2/16/demand-planning-challenges-in-make-to-order-mto-businesses

https://www.cio.com/article/3518771/moving-from-demand-planning-to-automated-demand-sensing.html

https://medium.com/analytics-vidhya/what-is-the-best-forecasting-model-for-demand-planning-part-1-a-model-review-90c6304d799b

https://blog.datasciencedojo.com/machine-learning-revolutionize-demand-planning/

https://www.supplychainbrain.com/articles/30774-new-developments-in-demand-planning-and-forecasting

https://blog.camelot-group.com/2020/04/how-to-master-demand-planning-in-covid-19-times/


Bibliography & References

Key to S&OP Success: Move from Forecasting to Integrated Demand Management
April 07, 2017
The Problem: Forecast Accuracy Remains a Challenge
http://www.supplychain247.com/paper/key_to_sop_success

http://www.focusforecasting.com/

Sales Forecasting
https://books.google.co.in/books?id=yCyvrHaR5cEC


Updated 26 Dec 2020
4.4.2019


No comments:

Post a Comment