****** I NEED THE EXCEL FORMULAS, FOR EXAMPLE =AVERAGE.... PLEASE SHOW EXCEL FORMULAS USED FOR ALL********

FlyingDiss. Inc. has also recorded the number of disc golf bags it has sold in each of the last 15 months of business. Use the recorded demand data below to develop a Simple Exponential Smoothing forecast with a =0.2 and a = 0.6 Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations 69 Week 1 2 3 4 5 Demand 55 50 57 60 58 Week 6 7 8 9 10 Demand 63 50 50 58 73 Week Demand 11 12 52 13 67 14 63 15 70 Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations 8) What is the forecast for week 16 using exponential smoothing with a =0.2? Assume that the forecast for week I was 55. The final forecast for period 16 should be rounded off to the nearest whole number. A) B) Less than or equal to 63.00 Greater than 63.00 but less than or equal to 66.00 Greater than 66.00 but less than or equal to 69.00 Greater than 69.00 but less than or equal to 72.00 Greater than 72.00 9) What is the forecast for week 16 using exponential smoothing with a = 0.6? Assume that the forecast for week I was 55. The final forecast for period 16 should be rounded off to the nearest whole number. A) B) Less than or equal to 63.00 Greater than 63.00 but less than or equal to 66.00 Greater than 66.00 but less than or equal to 69.00 Greater than 69.00 but less than or equal to 72.00 Greater than 72.00 10) What is the mean square error (MSE) for the forecast with a = 0.2 as of week 15? Do not use week one in your calculations. A) B) Less than or equal to 63.00 Greater than 63.00 but less than or equal to 66.00 Greater than 66.00 but less than or equal to 69.00 Greater than 69.00 but less than or equal to 72.00 Greater than 72.00 E)