Hello PLEASE show work on how this problem is completed in Excell thank you

MINI-CASE Forecasting Air-Conditioned Golf Cart Demand 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. The last month of actual demand (Dec 2021) was recently received. The V.P. of Sales and Marketing receives an end of the year $20K Bonus if his forecast accuracy for the year is within + or -10%. Compute his forecast error for the year deriving a number for the MAD and the MAPE. Will the V.P. be receiving a Bonus this year