Demand Forcasting in Excel

i am attaching an example on how to do this...and power point instructions if necessary. its mainly about replacing the info and updating the formulas. not that many sheets required, only a few to answer the questions below. Turn in a single MS Excel file containing your answers. Sales Yr 1 Yr 2 Yr 3 Yr 4 Yr 5 Jan 2000 2706 3214 3537 3800 Feb 5000 6323 8105 9184 9978 Mar 7000 9494 10361 12666 13238 Apr 11000 15216 16860 18789 21028 May 14500 18000 21298 25576 30828 Jun 19000 25264 29086 30954 37167 Jul 26000 36449 38057 47982 50933 Aug 15000 18503 23695 28530 28663 Sep 10000 13053 15037 17091 21534 Oct 5000 6478 7711 8635 9654 Nov 4500 5665 6874 8531 8876 Dec 3000 4003 4660 4974 5731 *Hint: you'll probably want to make these demand numbers a single column! Using the table of sales figures listed above, do the following: 1) Moving average forecasts for year 6 using "p+1" as the number of periods to include. 2) Four-month weighted moving average forecasts for year 6, with the weights of 10%, 20%, 30%, and 40% (most recent month last). 3) Simple exponential smoothing forecast for year 6 with an alpha = 0.15. 4) "Static" deseasonalizing method forecast for year 6. 5) Use Winter's method of trend and seasonality corrected exponential smoothing to forecast year 6. Use solver to find the optimal alpha, beta, and gamma. 6) Compare the MAD, MAPE, and MSE for each of the forecasting methods used above. Which method works best? To be clear, I want you to create something that resembles the "Tahoe Salt" example analysis in Excel.