The table named "Sales" to the right, shows the sales of a supermarket (in thousand dollars) in the last 12 months. Sales Month Sales Note: to facilitate answering the questions in the next two sheets, use Excel Data Analysis Tool Pack (except for questions 1b and 2d). 125 141 125 123 126 50 VOUTAWNY 145 147 162 155 10 158 11 147 12 159a) Develop the 2month and 3-month moving averages for the supermarket sales. Note: use data analysis tool paclc b) Which moving average appears to provide more accurate forecasts based on MAE? Explain. Note: show your MAE calculations. a) Use a = .2 to compute the exponential smoothing forecast for the supermarket sales. b) Use a = .3 to compute the exponential smoothing forecast for the supermarket sales. c) Use a = .4 to compute the exponential smoothing forecast for the supermarket sales. d) Does a smoothing constant of .2, .3 or .4 appear to provide more accurate forecasts based on MSE? Explain. Note: show your MSE calculations