please provide detailed information steps by steps on how you got the answer for example part b (production), why is it 23,900? please use the table below to come up with steps by step explanation . thank you

\fQuestion one (continued) REQUIRED: a. ii. iii. iv. vI. vii. viii. b. Using EXCEL, prepare the following schedules or statements for 2023: Sales budget Production budget Direct materials purchases budget Direct labour budget Factory overhead budget (Hint: separate variable and xed) Cost of good sold and ending inventory budget Selling and administrative expense budget (Hint: Separate selling and administrative expense) Budgeted income statement. Snapdragon is a mature product and the sales manager believes that price can be increased by 10% to $330 without having an impact on sales. Additionally, the sales manager believes that Exynos, which is a new product that was introduced last year has great potential. He believes that reducing the price to $400 is likely to double the sales of Exynos to 12,000 units. Using the EXCEL spreadsheet developed in part A above, determine what effect the proposed changes will have on the company's after-tax operating income. (Hint: Do not develop another spreadsheet.) Would you recommend that Razr-Tech implement the proposed strategy