12,800,000 Sales Volume 80,000 Units Q1. Assume Altec Manufacturing Inc. has greatly exceeded the budget target. Its CVP Operating Income Statement for 2022 is as follows: Sales Variable costs Cost of goods sold 8,812,020 Selling & administrative expenses 1,553,800 Total variable costs SP 160 per unit Variable Cost per unit 110.15 per unit 19.422 per unit 10,365.820 Contribution margin 2,434,180 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: 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, va Please solve the problem using excel Goal Seek Funcions. Solutions: Selling Price Variable cost Cost of goods sold 121.165 110% Selling & administrative expenses 21.365 per unit Total Variable costs 142.53 CM -142.53 per unit 90.000 Unit Altec Manufacturing Inc. Projected Income Statement Projected Income Statement Year Ending December 31, 2023 Sales Revenue Variable costs Contribution margin Fixed costs Net operating income