Question #$1$

Use the attached sales data to do a $4$ month and $6$ month moving average using Excel. Present your data in both table form and using a graph.

a$)$ What differences do you see in the two curves?

b$)$ Calculate the expected error $($MAD$)$ in the curves. What is the difference and how would affect your decisions on the two forecasting models?

Question #$2$

Use the same data to perform an exponential smoothing, using an alpha of $\mathrm{.}3$ and $\mathrm{.}6.$ Present both tables and graphs of your data.

a$)$ How does your answer change with the differing alpha$$s$?$ Which model would you choose and why?

b$)$ What is the difference in using either model for your forecasting?