a$)$ Using this historical data, create a forecast from April $$ Dec using a three$-$ month weighted moving average using weights of $5,4$ and $3.$ All answers rounded to whole numbers $(2$ marks$)$

b$)$ Using this historical data, create a forecast from Apr $-$Dec using exponential smoothing and an opening forecast for March of $1600$ units and an alpha of $\mathrm{.}30$ All answers rounded to whole numbers $(2$ marks$)$

c$)$ Create a line chart and plot the actual demand as well as the April $$ Dec forecast from part a$.$ and the Apr$-$Dec forecast from b$.(5$ marks$)$

d$)$ If you were responsible to forecast these items, what factors would you take into consideration in addition to using historical data and time series analysis? Use a text box for your answer. $(3$ marks$)$

Be sure to label each column and use formulas in order to receive the marks. Be sure to read the instructions below