Please show work

Question 2: Actual sales in dollars for the past 12 months at a computer store are as follows: Aug Sales/Mo Jan Actual 3000 Forecast Feb 3400 Mar 3700 Apr 4100 May 4700 Jun 5700 Jul 6300 Sep 6400 Oct 4600 Nov 4200 Dec 3900 7200 Start all error measurements in Apr (Period 4). Use OM Explorer Solver "Time Series Forecasting". a.) Develop a 3-month moving average for forecasted sales for Apr through Dec. b.) Develop a 3-month weighted moving average for forecasted sales from Apr through Dec. Use weights of (4/8), (3/8), and (1/8) giving more weight to the most recent data. c.) Develop an exponential smoothing forecast for Apr through Dec using an alpha = 0.6 and an initial forecast in Jan of $3200. d.) Develop a trend projection forecast method to develop forecast sales for Apr through Dec. e.) On the basis of MAD, which method provides the best forecast (e.g. least MAD)? f.) On the basis of MAPE, which method provides the best forecast (e.g. least MAPE)