Please answer question 1 and show all work in Excell with formulas thank you!

You have been hired to the Planning team for the Alabama Golf Carts (AGC) company based in the new "Mecca" of golf, Augusta, Alabama. One of their newer products is a line of luxury, air-conditioned Golf Carts. During your first meeting, you were handed some demand data to work with and are responsible for helping the company match demand to production capacity. Complete the tasks below. Month Forecast Actual January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 3,500 3,500 4,000 4,500 5,000 5,500 6,000 5,500 5,000 4,500 4,000 5,000 2,900 3,200 3,700 4,500 5,400 6,000 6,200 5,400 4,600 4,000 4,000 5,200 Other possibly relevant information from the company: Product is produced two months in advance of sales. 1. Using the table above of 2021's monthly forecast and actuals, develop a forecast in January 2022. (a) Develop 2-month, 3-month, and 4-month moving averages to forecast demand in January 2022. (b) Forecast demand with a 3-month weighted moving average in which demand in the most recent month is given a weight of 3, 2 the prior year, and a weight of 1 the first month of the average. (c) Forecast demand by using an exponential smoothing constant of 0.4. (d) Would the exponential smoothing forecast method be good to use to set January's monthly forecast and why