Sales Volume 80,000 Units Q1. Assume Altec Manufacturing Inc. has greatly exceeded the budget target. Is CVP Operating Income Statement for 2022 is as follows: Sales $ Variable costs Cost of goods sold $ 8,812,020 Selling & administrative expenses 1.552 AM Total variable costs $ SP 12,800,000 $ 180.00 per unit Variable Cast per uni! $ 110.15 per unit $ 19.42 per unit 10,385 820 Contribution margin $ 2,434,180 Fixed costs Cost of goods sold 453,494 Selling & administrative expenses 980,057 Total Fixed costs 1.413,551 Operating income $ 1,020,629 Required: What is the saling price Altec needs to charge to earn the target operating income of $1,500,000? Il expects to produce and sell 90.000 units in 2023, variable cost per unit will increase by 10% compared with 2022. fxed costs remain unchanged. Please solve the problem using and Goal Seek Funcions. Solutions: Selling Price Variable cost 121 110% $ Cost of goods sold Selling & administrative expenses Total Variable costs CM Q $ $ $ 21.38 per unit 142.53 (142.53) per unit 90,000.00 Unit Altec Manufacturing Inc. Projected Income Statement Projected Income Statement Year Ending December 31, 2023 Sales Revenue Variable costs Contribution margin Fixed costs Nel operating income Sales Volume 80,000 Units Q2. Assume Altec Manufacturing Inc. has greatly exceeded the budget target. Its CVP Operating Income Statement for 2022 is as follows: SP Sales $ 12,800,000 $ 160.00 per unit Variable costs Variable Cost per unit Cost of goods sold $ 8.812,020 $ 110.15 per unit Selling & administrative expenses 1.553.800 $ 19.42 per unit Total variable costs $ 10.365,820 $ 2.434,180 Contribution margin Fixed costs Cost of goods sold Selling & administrative expenses Total Fixed costs 453,494 960,057 1,413,551 Operating income $ 1,020,629 Required: At what level of unit sales would Albec be inciterent pared with a 1? In other words, at what level of unit sales would Altec cam the same target operating income of $1.500.0007 Assume the CEO expects to acquire a new equipment which would employ an automation system that intergrates the production process, and it would significantly reduce labour costs. Assume the selling price is sill $175 per unit. Under this new cost structure plan, variable cost will reduce by 15%, and fixed cost will increased by 40%. Please solve the problem using excel Goal Seek Funcions Solutions: Selling Price $ 175 Variable cost $ 85% $ Cost of goods sold Selling & administrative expenses Total Variable costs CM $ $ 93.63 16.51 per unit 110.14 64.86 per unit Unit Sales Revenue Variable costs Contribution margin Fixed costs Net operating income