Develop a forecast for the Month of October using

a) 4-months moving average

b) 12-months moving average

c) 3-months weighted moving average. Weight for the most recent month is .5, the second most recent is .25, and the third is .25

d) Exponential smoothing and assuming alpha of .3 and forecast for September this year of 375.

e) Linear regression

If the actual sales in October were 440, which model is the most accurate in predicting Octobers demand?

LAST YEAR This Year \begin{tabular}{lll} \hline January & 300 & 275 \\ February & 400 & 375 \\ March & 425 & 350 \\ April & 450 & 425 \\ May & 400 & 400 \\ June & 460 & 350 \\ July & 400 & 350 \\ August & 300 & 275 \\ September & 375 & 350 \\ October & 500 & \\ November & 550 & \\ December & 500 & \\ \hline \end{tabular}