A B C D E F G H Q1. Assume Altec Manufacturing Inc. has greatly exceeded the budget target. Its CVP Operating Income Statement for 2022 is as follows: 2 SP Sales Volume 3 Sales $ 12,750,000 $ 150.00 per unit 85,000 Units 4 Variable costs Variable Cost per unit 5 Cost of goods sold $ 7,815,750 $ 91.95 per unit 6 Selling & administrative expenses 1,553,800 18.28 per unit 7 Total variable costs $ 9,369,550 8 9 Contribution margin $ 3,380,450 TO 11 Fixed costs 12 Cost of goods sold 1,453,494 13 Selling & administrative expenses 1,148,806 2,602,300 + 14 Total Fixed costs 15 16 Operating income $ 778, 150 17 Required: 18 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 19 Please solve the problem using excel Goal Seek Funcions. 20 21 Solutions: Budget Assignment Part 2 Q1 Budget Assignment Part 2 Q2 Budget Assignment Part 2 Q3 E ... + Ready 16 C O W X T