Case Study: Demand Forecasting
The level at which forecasting takes place (finished product, components or raw materials) is mainly dependent on the production environment. In a company pro-ducing for stock (Make to Stock) the finished products are forecast, and in a com-pany producing to customer order (Make to Order) the necessary raw materials, bought-in parts and production capacities must be forecast. A third variant is a pro-duction environment in which products are principially assembled the same way but the products are only fitted after the customer has made the order (Assemble to Order). In this case, frequently used components are forecast.
In this case study we will look more closely at the application of various forecasting methods.
German Version
Nachfrage und Bedarfsvorhersage PDF
Attachment
Nachfrage und Bedarfsvorhersage XLS
English Version
Attachment
Course sections and their intended learning outcomes
Course 10 – Demand Planning and Demand Forecasting
Intended learning outcomes: Produce an overview of forecasting techniques. Explain history-oriented techniques for constant demand in detail. Identify history-oriented techniques with trend-shaped behavior. Describe three future-oriented techniques. Disclose how to use forecasts in planning.
10.1 Overview of Demand Planning and Forecasting Techniques
Intended learning outcomes: Produce an overview on the problem of demand planning. Present the subdivision of forecasting techniques. Disclose principles of forecasting techniques with extrapolation of time series and the definition of variables.
10.2 Historically Oriented Techniques for Constant Demand
Intended learning outcomes: Describe the moving average forecast. Explain the first-order exponential smoothing forecast. Differentiate between the moving average forecast and the first-order exponential smoothing forecast.
10.3 Historically Oriented Techniques with Trend-Shaped Behavior
Intended learning outcomes: Explain the regression analysis forecast and the second-order exponential smoothing forecast. Describe the Trigg and Leach adaptive smoothing technique. Produce an overview on seasonality.
10.4 Future-Oriented Techniques
Intended learning outcomes: Explain the trend extrapolation forecast and the Delphi method. Describe scenario forecasts.
10.5 Using Forecasts in Planning
Intended learning outcomes: Produce an overview on the choice of suitable forecasting technique. Describe consumption distributions and their limits, continuous and discontinuous demand. Explain demand forecasting of variants of a product family. Present safety demand calculation for various planning periods. Disclose the translation of forecast into quasi-deterministic demand.
10.6 Summary
.
10.7 Keywords
.
10.8 Scenarios and Exercises
Intended learning outcomes: Choose an appropriate forecasting technique. Calculate an example for the moving average forecasting technique and for the first-order exponential smoothing technique. Differentiate between the moving average forecast and the first-order exponential smoothing forecast.
10.9 References
.
Case [Course 10]
.
