Razr-Tech Manufacturing Ltd produces specialised computer parts for computer manufacturers around the world. Apart from the central processing unit (CPU), graphics processing unit (GPU), motherboard and Random Access Memory (RAM), Razr also produces small microprocessors. Two of its microprocessors are the Snapdragon and Exynos. The Snapdragon is sold at $300 per unit while the Exynos is sold at $440 per unit. In 2023, demand for the Snapdragon is expected to be 24,000 units while demand for Exynos is expected to be 6,000 units. Estimated beginning inventory in 2023 for Snapdragon and Exynos are expected to be 600 and 300 units respectively, while the company desires to have ending inventory of 500 and 200 units respectively for Snapdragon and Exynos. Additional information for the production of Snapdragon and Exynos follows: Razr-Tech expects the average wage rate to be $36 per hour in 2023 . Razr-Tech uses direct-labour hours to apply overhead. Each year the company determines the overhead application rate for the year based on the budgeted output for the year. The company maintain negligible work-in-progress inventory and expects the cost per unit for both the beginning and ending inventory of finished goods to be identical. REQUIRED: a. Using EXCEL, prepare the following schedules or statements for 2023: i. Sales budget ii. Production budget iii. Direct materials purchases budget iv. Direct labour budget v. Factory overhead budget (Hint: separate variable and fixed) vi. Cost of good sold and ending inventory budget vii. Selling and administrative expense budget (Hint: Separate selling and administrative expense) viii. Budgeted income statement. b. 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 produd 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 aftertax operating income. (Hint: Do not develop another spreadsheet.) Would you recommend that Razr-Tech implement the proposed strategy? End of Question One Razr-Tech Manufacturing Ltd produces specialised computer parts for computer manufacturers around the world. Apart from the central processing unit (CPU), graphics processing unit (GPU), motherboard and Random Access Memory (RAM), Razr also produces small microprocessors. Two of its microprocessors are the Snapdragon and Exynos. The Snapdragon is sold at $300 per unit while the Exynos is sold at $440 per unit. In 2023, demand for the Snapdragon is expected to be 24,000 units while demand for Exynos is expected to be 6,000 units. Estimated beginning inventory in 2023 for Snapdragon and Exynos are expected to be 600 and 300 units respectively, while the company desires to have ending inventory of 500 and 200 units respectively for Snapdragon and Exynos. Additional information for the production of Snapdragon and Exynos follows: Razr-Tech expects the average wage rate to be $36 per hour in 2023 . Razr-Tech uses direct-labour hours to apply overhead. Each year the company determines the overhead application rate for the year based on the budgeted output for the year. The company maintain negligible work-in-progress inventory and expects the cost per unit for both the beginning and ending inventory of finished goods to be identical. REQUIRED: a. Using EXCEL, prepare the following schedules or statements for 2023: i. Sales budget ii. Production budget iii. Direct materials purchases budget iv. Direct labour budget v. Factory overhead budget (Hint: separate variable and fixed) vi. Cost of good sold and ending inventory budget vii. Selling and administrative expense budget (Hint: Separate selling and administrative expense) viii. Budgeted income statement. b. 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 produd 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 aftertax operating income. (Hint: Do not develop another spreadsheet.) Would you recommend that Razr-Tech implement the proposed strategy? End of Question One