Assignment 3 Instructions - Forecast Planning The table below shows the demand for a printer in a department store in each of the last twelve months. Answer the 4 questions below. EMA = Period 12345678910111213 MonthJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuary Demand12 15 19 23 27 30 32 33 37 41 49 58 ??? ANSWERS

1) Calculate the four month moving average for months 4 to 12. What would be your forecast for the demand in month 13? (4 marks)

2) Apply exponential smoothing with a smoothing constant of 0.2 to derive a forecast for the demand in month 13. (4 marks)

3) Which of the two forecasts for month 13 do you prefer and why? (4 marks)

4) What other factors, not considered in the above calculations, might influence demand for the printer in month 13? (3 marks)