Q. 16.2. Sales Forecasting ( Reference: Table 16.9 Handy Hardware Store, 2017 Sales Forecast by Month) (Do Not copy and Paste the excel sheet, please explain how you calculate the numbers and provide your interpretation) Month Monthly Actual Sales Monthly Sales Forecast for 2021 Sales Index* January $41,000 February 44,000 March 48,000 April 65,600 May 113,000 June 103,800 July 104,560 August 62,800 September 45,000 October 46,800 November 66,884 December 94,792 Total yearly sales $836,236 Average monthly sales Average monthly index $74,166.67 100.00 Total sales forecast for 2021 $890,000 Average Monthly forecast 1. What is the Average Monthly Sales ( Purple Color)? 2. What is the Sales Index for each month (Orange Color)? 3. Based on the Total Sales Forecast for 2021 is $890,000, What is the Average Monthly Sales forecast for 2021 (Green)? 4. Using the Average Monthly Forecast, what is the average monthly forecast(Blue Color)