solve b,c,d,e,f,g using excel plz and add some explaintion so i can understand

4. Observed weekly sales of certain hammers at the town hardware store over an eight-week period have been 14, 9, 30, 22, 34, 12, 19, and 23. a) Use the three-week moving averages to forecast the sales for the weeks 4 through 8. b) Use the exponential smoothing method with a=0.15 to find the forecasts for the weeks 4 through 8. Use the forecast for week 4 found in (a) to get the forecast started. c) Based on MAD, which method did better? Comment on the results. d) What is the exponential smoothing forecast at the end of week 6 for week 12? e) Determine the value of a that should have been used to correspond to N=3. f) Simulate different values of a (from 0.05 to 0.95 in increments of 0.05) on the computer to find the best value with respect to MAD. g) Determine the value of a that results in a variance of forecast errore, 10% higher than the variance of each observation o. MA ir to commute it each time a new demand is