please do all requirements

4 P23-25A (similar to) Question Help Cellular Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 7,500,0,000 and 11.000 units. The static budget was based on expected sales of 9,000 units. The company sold 11,000 units during July. Its fexto budget and (Click the icon to view the flexible budget.) Cuck the icon to view the income statomont.) Read the guiraman Cellular Technologies Flexible Budget Performance Report For the Month Ended July 31, 2018 2 3 5 (1)-(3) (3) - (5) Budget Flexible Sales Amounts Actual Budget Flexible Volume Static Per Unit Results Variance Budget Variance Budget Units 11000 11000 9000 Sales Revenue 22 F F Variable Expenses 13 U Contribution Margin F F U Fixed Expensen U F F Operating Income COCO chnologies ma Tor cellular base stations and ou ons applications, 500, 9,000, and 11,000 units. The static budget was based on expected sales of 9,000 units. The company sold 11,000 units during July. Its flexible budget and ratin Data Table 0 Data Table X agu the Cellular Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount per Unit Cellular Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue $ 249,000 148,200 Variable Expenses Contribution Margin 100,800 59,500 Fixed Expenses $ 41,300 Operating Income St Units Sales Revenue $ Bu Variable Expenses Contribution Margin 7,500 9,000 11,000 22 S 165,000 S 198,000 $ 242,000 13 97,500 117.000 143,000 67,500 81,000 99,000 58,000 58,000 58,000 $ 9,500 $ 23,000 $ 41,000 wenu Exped Fixed Expenses Print Done on M Operating Income ens Inca Print Done om any list or enter any number in the input fields and then click Check Answer, Clear All Check Answer Requirements X 1. Prepare a flexible budget performance report for July. 2. What was the effect on Cellular's operating income of selling 2,000 units more than the static budget level of sales? 3. What is Cellular's static budget variance for operating income? 4. Explain why the flexible budget performance report provides more useful information to Cellular's managers than the simple static budget variance. What insights can Cellular's managers draw from this performance report? 2 3 Print Done U U