ch 23 hw, need all 4 requirements please

Score: 0 of 1 pt 2 of complete HW Score: 47.7896, 1.43 of 3 C X P23-25A (similar to) Question Help Collate Technologies manufactures capacitors for cellular base stations and other communications applications. The company's sty 2018 fenible budgut shows output level of 8,500,10,000 and 12,000 units The static budget win bated on expedied sales of 10,000 unit. The company old 12.000 unite during Suly. Its feble budget and actual operating income was as follows: khoon to view the flexible budget) Click the icon to view the income statement) Read the Flexible Budget Performance Report For the Month Ended July 31, 2018 2 3 (1)-(3) Budget Flexible Amounta Actual Budget Flexible Per Unit Results Variance Budget 12.000 12.000 $ 225 271.000 173200 U 97.100 12.500 0.15) Sales Volume Variance Static Budget Units Sales Reven Variable Experts Contribution Man Foedente 45.300 Choose from any ut or enter any number in the input fields and then click Check Answer 5 portes Clear Al Check Answer i Data Table X CellBase Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount per Unit Units 8,500 10,000 12,000 Sales Revenue $ 22 $ 187,000 $ 220,000 $ 264,000 14 119,000 140,000 168,000 Variable Expenses Contribution Margin Fixed Expenses 68,000 80,000 96,000 51,000 17,000 $ 51,000 29,000 $ 51,000 45,000 $ Operating Income Print Done Data Table CellBase Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue $ 271,000 173,200 Variable Expenses Contribution Margin 97,800 Fixed Expenses 52,500 $ 45,300 Operating Income Print Done i i Requirements 1. Prepare a flexible budget performance report for July. 2. What was the effect on CellBase's operating income of selling 2,000 units more than the static budget level of sales? 3. What is CellBase's static budget variance for operating income? 4. Explain why the flexible budget performance report provides more useful information to CellBase's managers than the simple static budget variance. What insights can CellBase's managers draw from this performance report? Print Done