AE$7-1.$ Suppose your manager asks you to create a spreadsheet to compute a production schedule. Your schedule should stipulate a production quantity for seven products that is based on sales projections made by three regional managers at your company's three sales regions.

a$-$ Create a separate worksheet for each sales region. use the data in the word file Ch$07$Ex$01\_$U$10$e$.$docx. this file contains each manager's monthly sales projections for the past year, actual sales results for those same months, and projections for sales for each month in the coming quarter.

b$-$ Create a separate worksheet for each manager's data. Import the data fromm word into Excel.

c$-$ On each of the worksheets, use thee data from the prior four 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 overall average, or you could calculate an average per quarter or per month. You could also weight recent discrepancies more heavily than earlier ones. Choose a methode that you think is most appropriate. Explain why you chose the method you did.

d$-$ Modify your worksheelts to use the discrepancy factors to compute 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 coming quarter.

e$-$ create a fourth worksheet that totals sales projections for all of the regions. Show both the unadjusted forecast and the adjusted forecast for each region and the company overall. Show month and quarter totals.

f$-$ Create a bar graph showing total monthly production. Display the unadjusted and the adjusted forecast using diffrent colored bars.