The monthly sales (in millions of dollars) of Turner, Inc. for eleven months are given below.

Month	Actual Sales A
January	14
February	16
March	18
April	23
May	24
June	18
July	21
August	16
September	20
October	16
November	15
December	??

Using a 4-month moving average, forecast sales for December and compute MAD and MSE and write your answer below.

Your sales forecast for December:

MAD = MSE =

Using a 4-month weighted moving average, with the weights of 1, 2, 4, and 7, with 7 as the weight of the most recent month. Forecast sales for December and compute MAD and MSE and write your answer below.

Your sales forecast for December:

MAD = MSE =

Based on MSE, which model (moving average or weighted moving average) is a better model? Explain why.

Please show excel solutions and formulas and how you got to each answer.