Show me the work in Excel

The Year End closing of the financial books was completed by the financial department the third week of January. The V.P. of Sales and Marketing was then summoned to a meeting with the COO and CFO, and told to increase his sales revenue and given new financial targets. Based on his new financial targets, the V.P. has issued a revised monthly Sales Forecast and delivered it to you and the V.P. of Production for execution. The new Sales Forecast is below. Revised Sales Forecast for AGC. 2022 Month Jan Feb Increase More Sales 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 im 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. a. What should your new monthly production rate be? b. How will you add new capacity