PLEASE SHOW EXCEL WORK WITH FORMULAS

Revised Sales Forecast for AGC. Increase More Sales 2022 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Forecast 5,500 5,700 6,000 5,800 6,300 7,000 7,500 7,200 6,800 6,300 6,000 5,800 4. Create a new Production Plan that will begin in March of 2022. It must be level and it must cover the new Sales Forecast numbers through the year. Assume there are no Backorders from last year (2021). a. What should your new monthly production rate be? b. How will you add new capacity? Revised Sales Forecast for AGC. Increase More Sales 2022 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Forecast 5,500 5,700 6,000 5,800 6,300 7,000 7,500 7,200 6,800 6,300 6,000 5,800 4. Create a new Production Plan that will begin in March of 2022. It must be level and it must cover the new Sales Forecast numbers through the year. Assume there are no Backorders from last year (2021). a. What should your new monthly production rate be? b. How will you add new capacity