FDA 1st Opp- Nov -2018

QUESTION 3 Below data shows the sales for the year 2017 for SABMiller. You're busy forecasting for January 2018, using exponential smoothing, 0 .95. In December 2016, you have forecasted to sell 12 units in January 2017.

Below is the data:

Period 2017	Actual Sales	forecast a = 0.95	3-month moving average
January	10	12
February	12
March	16
April	13
May	17
June	19
July	15
August	20
September	22
October	19
November	21
December	19
January 2018

a) Calculate 3-month moving average [5 marks]

b) Calculate exponential smoothing and forecast for January 2018 [25 marks]

Subtotal 30 marks