please include excel formulas for the calculations

A. Compute a three-month moving average forecast of demand for months 4-8. (3 pts) B. Compute a weighted three-month moving average forecast for months 4-8. (3 pts) C. Assign weights of 0.55, 0.33, and 0.12 to the months in sequence, staring with the most recent month. (2 pts) D. Compare the forecasts using MAD. Which forecast appears to be more accurate? (2 pts) *** There is an extra credit opportunity...if you complete the Exponential Smoothing calculations, you can get up to an extra 3 points* Table: Month Demand January 100 February 50 March 85 April 90 May 110 June 90 July 75 August Unknown H N 10 Weighled Mong Average Weight Weighted Moving ABS Emor Averbo Exponential Smoothing ABS Echo 30 ABS Eno Error JOH MAD D Exam Number of Demand Periodis Forecasting Alha Problem 3-Anth Moving Month Demand Average En January 100 February 50 March 35 April 90 May 110 June 00 JU 75 August Exponeri Smoothing 30 MAD - Wege MAD Demand 120 100 GO -Der 40 28 29 30 31 32 33 34 35 O 4