please solve using excel and include the answers and each step in solving them. The table named "Sales" to the right, shows the sales of a supermarket $($in thousand dollars$)$ in the last $12$ months.

Note: to facilitate answering the questions in the next two sheets, use Excel Data Analysis Tool Pack $($except for questions $1$b and $2$d$).$

a$)$ Use $=\mathrm{.}2$ to compute the exponential smoothing forecast for the supermarket sales.

b$)$ Use $=\mathrm{.}3$ to compute the exponential smoothing forecast for the supermarket sales.

c$)$ Use $=\mathrm{.}4$ to compute the exponential smoothing forecast for the supermarket sales.

d$)$ Does a smoothing constant of $\mathrm{.}2,.3$ or $.4$ appear to provide more accurate forecasts based on MSE? Explain.

Note: show your MSE calculations.Please solve using excel