Assignment:
Question 1: For the same actual demand data above, perform a forecast using:
- Moving average of 3 periods.
- Exponential smoothing of (a-0.2). Make the first forecast value equal to the actual demand.
- Sketch your results on an excel sheet (period vs. Demand and vs. forecast values)
Question 2: The demand on Samsung TVs at Xcite stores for the past 3 years is given in this table in units/season
Year 1 Year 2 Year 3
Spring 1500 1650 1550
Summer 1000 900 850
Fall 500 600 550
Winter 200 50 220
Use seasonality indexing to forecast the values of the 4" year. Sketch both actual and forecast values using Excel.