Please help me with C, D, E, and F. I'm lost and need some guidance. Please help

Chapter 7 quantity for seven products that is based on sales projections made by AE7- asks you to create a spreadsheet to compute a production schedule. Your schedule should stipulate a production 1. Suppose your manager three regional managers at your company's three sales regions. Use the data in the Word file Ch07Ex01_u10e.docx. This file contains each manager's monthly sales projections for the past year, each manager's monthly a. Create a separate worksheet for each sales region. for sales for each month in the coming quarter b. Create a separate worksheet for each manager's data. Import the data from Word into Excel. c. On each of the worksheets, use the data trom the prior tour quarters to compute the discrepancy between the actual sales and the sale projections. This discrepancy can be computed in several ways: You could calculate an s more heavily than earlier ones. Choose a method that you think is most appropriate. Explain why you s to compute the discrepancy t overall average, or you could calculate an average per quarter or per month. You could al chose the method you did. an adjusted forecast for the coming quarter. Thus, each of your spreadsheets will show the raw forecast and the adjusted forecast for each month in the d. Modity your worksheets to use the discrepancy factors to compute an adjusted forecast for the coming quarter e. Create a fourth worksheet that totals sales projections t. Create a bar graph showing total monthly production. Display the unadjusted and adjusted f Show both the unadjusted torecast and the adjusted forecast for each region and for the company overal. Show month and quarter totals forecasts using different colored bars Region 1 2018 Sales Summary product Product Product Product ProductProduct Produet 8 lan, 2018 Forecast Sales 10 Actual Sales 12 Feb, 2018 Forecast Sales 10 Actual Sales 11 23 6 11 Mar, 2018 5 6 20 36 35 2 2 5 23 Forecast Sales 11 Actual Sales 11 1 Apr, 2018 | 12 1 1 2 13 24--11 2 47 Forecast Sales! 12 Actual Sales 13 | 24 May, 2018 10 Forecast Sales 12 Actual Sales 1 24 12 49 2 Jun, 2018 Forecast Sales 12 Actual Sales 12 12 50 24 Jul, 2018 Forecast Sales 13 Actual Sales 152420 15 24 56 Aug, 2018 24 1 24 Forecast Sales 13 Actual Sales 15 Sep, 2018 Forecast Sales 14 Actual Sales 15 Oct, 201E Forecast Sales 15 Actual Sales 16 Nov, 2018 Forecast Sales 15 Actual Sales 16 Dec, 201i Forecast Sales 14 4 24 20 16 16 16 59 24 Actual Sales 1s Region 2 2018 Sales Summary Product Product | ProductProduct Product Product Product Jan, 2018 Forecast Sales 12 35 3 1 9 Actual Sales 13 35 Feb, 2018 Forecast Sales 13 Actual Sales 12 4 13 Mar, 2018 Forecast Sales 12 Actual Sales 12 21 24 10 14 39 43 Apr, 2018 Forecast Sales 14 Actual Sales 13 May, 2018 Forecast Sales 14 Actual Sales 12 14 5 6 14 14 10 Jun, 2018 Forecast Sales 15 14 51 Actual Sales 10 24 14 Jul, 2018 Forecast Sales 15 Actual Sales 14 12 14 25 17 24 21 Aug, 2018 18 Forecast Sales15 Actual Sales 15 Sep, 2018 23 26 24 18 17 21 Forecast Sales 16 Actual Sales 16 15 13 26 16 15 Oct, 2018 Forecast Sales 18 Actual Sales 17 15 15 Nov, 2018 Forecast Sales 17 27 Actual Sales 17 0 16 Dec, 2018 Forecast Sales 15 Actual Sales 15 Region 3 2018 Sales Summary Product Product Product Product Product Product Product Jan, 2018 Forecast Sales 10 20 Actual Sales 12 21 12 Feb, 2018 35 45 10 Forecast Sales 10 Actual Sales 11 23 23 Mar, 2018 41 Forecast Sales 11 Actual Sales 11 Apr, 2018 Forecast Sales 12 24 25 12 13 47 12 13 Actual Sales13 25 Forecast Sales 12 24 23 12 13 12 13 49 59 12 23 Actual Sales 11 Forecast Sales12 Actual Sales 12 Forecast Sales 13 Jun, 2018 12 12 23 23 24 15 16 15 16 Jul, 2018 18 20 23 24 18 20 52 56 23 13 Actual Sales 15 15 Aug, 2018 24 24 18 20 57 18 20 Forecast Sales 13 Actual Sales 15 Sep, 2018 23 25 59 59 Forecast Sales 14 Actual Sales 15 25 16 15 Oct, 2018 12 15 18 24 26 61 24 26 Forecast Sales 15 12 Actual Sales 16 Nov, 2018 25 15 25 Forecast Sales 15 Actual Sales 16 Dec, 2018 Forecast Sales 14 Actual Sales 15 26 Region 1 2019 Sales Forecasts Product Product Product Product Product Product Product 17 18 17 24 25 26 12 12 15 59 2019 Feb, 2019 Mar, 2019 14 15 16 24 25 26 70 Region 2 2019 Sales Forecasts Product Product Product Product Product Product Product 15 17 14 24 25 26 12 12 15 51 62 70 14 Jan, 2019 Feb, 2019 Mar, 2019 24 25 26 16 Region 3 2019 Sales Forecasts Product Product ProductProduct Product Product Product 15 24 Jan, 2019 Feb, 2019 Mar, 2019 14 15 16 24 25 26 12 12 61 69 14 26 Chapter 7 quantity for seven products that is based on sales projections made by AE7- asks you to create a spreadsheet to compute a production schedule. Your schedule should stipulate a production 1. Suppose your manager three regional managers at your company's three sales regions. Use the data in the Word file Ch07Ex01_u10e.docx. This file contains each manager's monthly sales projections for the past year, each manager's monthly a. Create a separate worksheet for each sales region. for sales for each month in the coming quarter b. Create a separate worksheet for each manager's data. Import the data from Word into Excel. c. On each of the worksheets, use the data trom the prior tour quarters to compute the discrepancy between the actual sales and the sale projections. This discrepancy can be computed in several ways: You could calculate an s more heavily than earlier ones. Choose a method that you think is most appropriate. Explain why you s to compute the discrepancy t overall average, or you could calculate an average per quarter or per month. You could al chose the method you did. an adjusted forecast for the coming quarter. Thus, each of your spreadsheets will show the raw forecast and the adjusted forecast for each month in the d. Modity your worksheets to use the discrepancy factors to compute an adjusted forecast for the coming quarter e. Create a fourth worksheet that totals sales projections t. Create a bar graph showing total monthly production. Display the unadjusted and adjusted f Show both the unadjusted torecast and the adjusted forecast for each region and for the company overal. Show month and quarter totals forecasts using different colored bars Region 1 2018 Sales Summary product Product Product Product ProductProduct Produet 8 lan, 2018 Forecast Sales 10 Actual Sales 12 Feb, 2018 Forecast Sales 10 Actual Sales 11 23 6 11 Mar, 2018 5 6 20 36 35 2 2 5 23 Forecast Sales 11 Actual Sales 11 1 Apr, 2018 | 12 1 1 2 13 24--11 2 47 Forecast Sales! 12 Actual Sales 13 | 24 May, 2018 10 Forecast Sales 12 Actual Sales 1 24 12 49 2 Jun, 2018 Forecast Sales 12 Actual Sales 12 12 50 24 Jul, 2018 Forecast Sales 13 Actual Sales 152420 15 24 56 Aug, 2018 24 1 24 Forecast Sales 13 Actual Sales 15 Sep, 2018 Forecast Sales 14 Actual Sales 15 Oct, 201E Forecast Sales 15 Actual Sales 16 Nov, 2018 Forecast Sales 15 Actual Sales 16 Dec, 201i Forecast Sales 14 4 24 20 16 16 16 59 24 Actual Sales 1s Region 2 2018 Sales Summary Product Product | ProductProduct Product Product Product Jan, 2018 Forecast Sales 12 35 3 1 9 Actual Sales 13 35 Feb, 2018 Forecast Sales 13 Actual Sales 12 4 13 Mar, 2018 Forecast Sales 12 Actual Sales 12 21 24 10 14 39 43 Apr, 2018 Forecast Sales 14 Actual Sales 13 May, 2018 Forecast Sales 14 Actual Sales 12 14 5 6 14 14 10 Jun, 2018 Forecast Sales 15 14 51 Actual Sales 10 24 14 Jul, 2018 Forecast Sales 15 Actual Sales 14 12 14 25 17 24 21 Aug, 2018 18 Forecast Sales15 Actual Sales 15 Sep, 2018 23 26 24 18 17 21 Forecast Sales 16 Actual Sales 16 15 13 26 16 15 Oct, 2018 Forecast Sales 18 Actual Sales 17 15 15 Nov, 2018 Forecast Sales 17 27 Actual Sales 17 0 16 Dec, 2018 Forecast Sales 15 Actual Sales 15 Region 3 2018 Sales Summary Product Product Product Product Product Product Product Jan, 2018 Forecast Sales 10 20 Actual Sales 12 21 12 Feb, 2018 35 45 10 Forecast Sales 10 Actual Sales 11 23 23 Mar, 2018 41 Forecast Sales 11 Actual Sales 11 Apr, 2018 Forecast Sales 12 24 25 12 13 47 12 13 Actual Sales13 25 Forecast Sales 12 24 23 12 13 12 13 49 59 12 23 Actual Sales 11 Forecast Sales12 Actual Sales 12 Forecast Sales 13 Jun, 2018 12 12 23 23 24 15 16 15 16 Jul, 2018 18 20 23 24 18 20 52 56 23 13 Actual Sales 15 15 Aug, 2018 24 24 18 20 57 18 20 Forecast Sales 13 Actual Sales 15 Sep, 2018 23 25 59 59 Forecast Sales 14 Actual Sales 15 25 16 15 Oct, 2018 12 15 18 24 26 61 24 26 Forecast Sales 15 12 Actual Sales 16 Nov, 2018 25 15 25 Forecast Sales 15 Actual Sales 16 Dec, 2018 Forecast Sales 14 Actual Sales 15 26 Region 1 2019 Sales Forecasts Product Product Product Product Product Product Product 17 18 17 24 25 26 12 12 15 59 2019 Feb, 2019 Mar, 2019 14 15 16 24 25 26 70 Region 2 2019 Sales Forecasts Product Product Product Product Product Product Product 15 17 14 24 25 26 12 12 15 51 62 70 14 Jan, 2019 Feb, 2019 Mar, 2019 24 25 26 16 Region 3 2019 Sales Forecasts Product Product ProductProduct Product Product Product 15 24 Jan, 2019 Feb, 2019 Mar, 2019 14 15 16 24 25 26 12 12 61 69 14 26