Please show work or any excel formulas used for A-C. Thank you!

WEEK ACTUAL NO. OF PATIENTS 1 65 2 62 3 70 4 48 5 63 6 52 Clinic administrator Dara Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted-average-moving method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167 three periods ago. a. What is the value of your forecast? PX b. If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? Explain why. c. What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7