please provide solutions and how you got answer.

attached is 6.1. I need solutions and answers to 6.1 and 6.2 that relates back to 6.1. have to answer in Excel. thanks

6.2 Referring to exercise 1, develop a forecast for period 11 using exponential smoothing and three values of a: 0.05, 0.30, and 0.90. Plot the actual data and the exponential averages for the three values of a. What do you observe? 11 fo fore EXERCISES @ 6.1 Plot the following data and then calculate and plot a three- period moving average. Then calculate and plot a five- period moving average. What do you observe in comparing the plots of the three- and five-period moving averages? Period 1 2 3 4 5 6 7 8 9 10 Demand 60 52 55 42 57 33 26 42 35 31