04_Demand Forecasting

Question 1

purpose of contents of operational planning level

-

Answer 1

• smoothing of seasonal variations of capacity requirements and available capacity
• determine master production schedule (which products in which quantities)
  - procurement planning: which quantities of input materials are needed for master scheduling

Question 2

chase demand vs level production strategy

pros and cons

Answer 2

**Chase demand: **
- low inventories, but high capacities
Level Production:
- high inventories, low capacities

Question 3

Demand forecasting

Definion and Types of time series

Answer 3

• prediction of future values of a time series (demand patterns) under uncertainty (based on historical values)
  Types of time series:
• Level Demand
• Linear Trend
• Seasonal Variation

Question 4

Analysis of the characteristics of a time series

Answer 4

• long term
• mid-term cyclical variations (eg economic cycles, product lifecycle)
• seasonal fluctuations (eg. annual seasons)
• random variations

Question 5

Procedure of time series based forecasting

5 Steps

Answer 5

1. Analysis of characteristics of time series
2. selecting appropriate forecast model
3. estimate coefficients of forecast model
4. apply forecast model
5. monitor and analyse forecast accuracy over time (tracing errors)

Question 6

Ex ante forecast values
vs
Ex post forecast values

Answer 6

• ex ante: forecast for following period
• ex post: previous forecast

Question 7

Forecasting Models

Answer 7

• Simple exponential smoothing (level demand time series)
• Exponential smoothing with trend adjustment (linear trend time series)

Question 8

Simple Exponential Smoothing

forecasting model for level demand time series

Answer 8

• random variations around a constant demand level
• initialization Po has to be determined (often yo is chosen)
• smoothing paramter alpha: determines the strenght of the smoothing effect
• the higher alpha the closer you get to observed demand (naive forecast)

Question 9

Formula Simple Exponential Smoothing

Answer 9

Pt+1 = alpha x yt + (1-alpha) x Pt

(weighting of previously observed demand and previous forecast adjusted for errors)

yt = observed demand in period t ; Pt = forecast period t

Question 10

Exponential Smoothing with trend adjustment

forecasting model for trend line time series

Answer 10

• assumed demand process: random variations around linear trend
• simple exponential smoothing causes systematic error
• introdruce trend adjustment (correction factor) to adjust for systematic lag
• Initialization: before first forecast determination adequate initial values a0 and b0 have to be determined, e.g. through linear regressen

Question 11

Exponential Smoothing with trend adjustment

Step by Step

Answer 11

1. update of level demand at end of period t (at)
2. update of trend at end of period t (bt)
3. Forecast determination