Year Month Sales MA(1) Absolute Deviation MA(2) Absolute Deviation 2020 January 14,950 2020 February 16,525 2020 March 17,600 2020 April 16,300 2020 May 20,075 2020 June 24,000 2020 July 21,775 2020 August 22,575 2020 September 23,925 2020 October 22,600 2020 November 25,025 2020 December 28,750 2021 January ? MAD for MA(1) MAD for MA(2) Q1: The monthly volume for dress shoes sold by Kennedi Myles Styles, Inc., based in Hawthorn Woods IL, about 40 miles northwest of Chicago, is given above: (10 points) a. Use Moving Average over one period, i.e., MA (1), to forecast the sales for January 2021. Please provide your answer in bold in the blue highlighted cell. (20 points) b. Compute mean absolute deviation (MAD) for the MA (1) forecast calculated in sub question 1a. Please provide your answer in bold in the gray highlighted cell. (10 points) c. Use Moving Average over two periods, i.e., MA (2) to forecast the sales for January 2021. Please provide your answer in bold in the orange highlighted cell. (20 points) d. Compute mean absolute deviation (MAD) for the MA (2) forecast calculated in sub question 1c. Please provide your answer in bold in the green highlighted cell. e. Between the two forecasts calculated above, MA(1) and MA(2), which one is more accurate? How (10 points) did you make that determination? Please provide your answer in bold in the yellow highlighted cell PLEASE DO NOT FORGET TO ANSWER THE SECOND SET OF QUESTIONS IN THE NEXT EXCEL TAB