How would you do this correctly on excel ?

The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week 1 2 3 4 5 6 AN Actual No. of Patients 87 89 96 80 86 93 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three periods ago. a) What is the value of your forecast? The value of the forecast is 88.50 patients (round your response to two decimal places). b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? O A. The value of the forecast will decrease. XB. The value of the forecast will increase. c*c. The value of the forecast will remain the same. c) What if the weights were 0.60, 0.20, 0.10, and 0.10, respectively? Now what is the forecast for week 7? The value of the forecast is 90.60 patients (round your response to two decimal places)