Required: What is the se|ing price Altec needs to charge to earn the target operating income of 51,500,000?| |t expects to produce and sell 90,000 units in 2023, variable cost per unit Wlll Increase by 10% compared With 2022, xed costs remain unchanged, Please solve the problem using excel Goal Seek Funcions, Solutions: Selling Price 5 167 Variable cost $ 935355700 Cost of goods sold 5 827 550.00 Selling 8. administrative expenses 5 154,520,00 per unit Total Variable costs 5 10,912,77000 CM 5 4,102,300,00 per unit Q 90,000 Unit Altec Manufacturing Inc. Projected Income Statement Projected Income Statement Year Ending December 31. 2023 Sales Revenue 5 15,015,060 Variable costs 5 10,912,770 Contribution margin 5 4,102,300 Fixed costs 5 (2,602,300) Net operating income 5 1,500,000 Q1. Assume Altec Manufacturing Inc. has greatly exceeded the budget target. Its CVP Operating Income Statement for 2022 is as follows: SP Sales Volume Sales $ 12,750,000 $ 150.00 per unit 85,000 Units Variable costs Variable Cost per unit Cost of goods sold $ 7,815,750 91 95 per unit Selling & administrative expenses 1.553.800 18.28 per unit Total variable costs $ 9,369,550 Contribution margin $ 3,380,450 Fixed costs Cost of goods sold 1,453,494 Selling & administrative expenses 1, 148,806 2,602,300 Total Fixed costs Operating income $ 778, 150 Required: What is the seling price Altec needs to charge to earn the target operating income of $1,500,000? It expects to produce and sell 90,000 units in 2023, variable cost per unit will increase by 10% compared with 2022, fixed costs remain unchanged. Please solve the problem using excel Goal Seek Funcions