could someone, please, solve one with detailed explanation? (like which cell must be divided/multiplied by another one)

Budget Assignment Part 2 Student (2) Pew COMMOTHMOTH Arial 10 - A A ota - 5 5 Microsoft 366 , . H3 c. E AY- . Neo E 11 Contribuon mer 1 0 40 12 1 444 | 1 1AA 2 03 00 14 1. What the Alec des charge to can helping mom 51.800.000 expech producent 90.000 und 2021, coat per una by to compared with 2022, fed corn changed 20 a se Pr per a na unt 24 Costogos Sing at ve te ar c Ahed Mandering in rametrument Premium t 10 views 11 de 4 Budget Asient Port 201 But Put 20% Budget P204 rofe 10 E Budget Assignment Part2_start (1) x | ) Arial 10. ota AY- . v - 5 5 Microsoft 366 , . B D H Q1. Assume Ahec Manufacturing Inc. has greaty exceeded the budget target Its CVP Operating Income Statement for 2022 is as follows: SP Sales Volume 3 3 Sales $ 12 750 000 $ 150,00 r unit 85 000 Units 4 Variable costs Variable Cost per un 5 Cost of goods sold 5 7 815 750 91,96 per unit 6 Selling & administrative expenses 1553 000 $ 18,28 per unit 7 Total variable costs $ 9 309 550 $ 3 O 40 9 Contribution margin 11 Fixed costs 12 Cost of goods sold 13 Selling & administrative expenses 14 Total Fixed costs 1453 454 1 148 000 2 602 300 16 Operating income 78 150 17 Required: 18 What is the selling price Alec needs to charge to earn the target operating income of 51,500,000? t expects to produce and sel 90,000 unts in 2023, variable cost per unit will increase ty 10% compared w 19 Please solve the problem using excelGoal Seek Funcions , 20 21 Solutions: Budget Assignment Port 201 200 Buton Put 203 Budget AP204 rofe 15 Neo AY- . N Budget Assignment Part2_start (1) x | ) Arial 10 - A A ota - a Microsoft 365 , . D E E 10 Operwing income 1 Required 10 What is the saling price Albec needs to charge to cam the target operating income of 1.500.0007 it each to produce and sell 10.000 units in 2023. variable cost per unit will increase by 10% compared with 2022. fed cont remain unchanged. 19. Please selve the problem using excel Goul Seek Funcions 20 2 Solutions 22 Selling Price Variable 24 Cost of goods sold 101.18 110 26 Seting & administrative expenses 20.11 per unit 20 Total Variable costs 121, 27 CM (121) r unit 20 Unet 30 Alter Manufacturing Ine. Projected income Statement 31 Projected income Statement Year Ending December 1, 2023 20 34 Se Revenue 15000000 90 000 ur 35 Variate cost - 16 Contribution margin 280 000 20 Matering 100) 40 10 4 Budget Agent Pr201 200 Bu Asment 20 4 fee 119