Please complete the question using excel and showing all work with formulas. Cost information was asked for delaying the asnwer to this question but everything has been provided. Please refer to this link for earlier solving. https://www.chegg.com/homework-help/questions-and-answers/mini-case-forecasting-air-conditioned-golf-cart-demand-hired-planning-team-alabama-golf-ca-q95090804?trackid=GjJGmiFc

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. 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). 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. 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)