please read the requirements and do those too!

= Homework: CHAPTER M-6 Question 1, PM6-30B (book/static) Part 2 of 6 > HW Score: 33.45%, 1.67 of 5 points Points: 0.67 of 1 O Save Cell Plus Technologies manufactures capacitors for cellular base stations and other communication applications. The company's July 2024 flexible budget shows output levels of 8,500, 10,000, and 12,000 units. The static budget was based on expected sales of 10,000 units. The company sold 12,000 units during July. Its flexible budget and actual operating income was as follows: (Click the icon to view the flexible budget.) E: (Click the icon to view the income statement.) Data table Read the requirements. C. Cell Plus Technologies Cell Plus Technologies Flexible Budget For the Month Ended July 31, 2024 Budget Amount per Unit Flexible Budget Performance Report For the Month Ended July 31, 2024 1 2 2 3 (1)-(3) 4 5 (3) - (5) Units 8,500 10,000 12,000 Budget Flexible Sales $ Amounts Actual Flexible Volume Static Budget Variance Sales Revenue Variable Expenses Contribution Margin Fixed Expenses Per Unit Results Variance Budget 12,000 Budget 10,000 24 $ 204,000 $ 240,000 $ 288,000 13 110,500 130,000 156,000 93,500 110,000 132,000 57,000 57,000 57,000 $ 36,500 $ 53,000 $ 75,000 Units 12,000 295,000 $ Sales Revenue $ 24 $ 7,000 F $ $ 288,000 $ 48,000 F 156,000 240,000 130,000 Operating Income 13 161,100 5,100 U 26,000 U Variable Expenses Contribution Margin 133,900 1,900 F 22,000 F 132,000 57,000 110,000 57,000 Data table Fixed Expenses 58,000 1,000 0 Print $ 75,900 $ 900 F $ 75,000 $ 22,000 F 53,000 Operating Income Requirements Cell Plus Technologies Income Statement For the Month Ended July 31, 2024 Sales Revenue $ 295,000 Variable Expenses 161,100 Contribution Margin 133,900 58,000 Fixed Expenses $ 75,900 Operating Income 1. Prepare a flexible budget performance report for July 2024. 2. What was the effect on Cell Plus's operating income of selling 2,000 units more than the static budget level of sales? 3. What is Cell Plus's static budget variance for operating income? 4. Explain why the flexible budget performance report provides more useful information to Cell Plus's managers than the simple static budget variance. What insights can Cell Plus's managers draw from this performance report? Help me solve this Etext pages Get more help