URGENT!!!

CellBase Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 6,500,8,000, and 10,000 units. The static budget was based on expected sales of 8.000 units. The company sold 10.000 units during July. Its flexible budget and actual operating income was as follows: Requirement 1. Prepare a flexible budget performance report for July. (Enter a "0" for any zero balances. For any S0 variances, leave the Favorable (FyUnfavorable (U) input blank.) 5 CellBase Technologies Flexible Budget Performance Report For the Month Ended July 31, 2018 1 2 3 (1)-(3) Flexible Actual Budget Flexible Results Variance Budget 4 (3) - (5) Sales Budget Amounts Volume Static Per Unit Variance Budget Units Sales Revenue Variable Expenses Contribution Margin Fixed Expenses Operating Income Requirement 2. What was the effect on CellBase's operating income of selling 2,000 units more than the static budget level of sales? Selling 2,000 units more than the static budget level of sales CellBase's operating income by $ Requirement 3. What is CellBase's static budget variance for operating income? meaning that its operating income is than expected CellBase's static budget variance is $ per the static budget. Requirement 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? Choose two reasons why the flexible budget performance report provides CellBase's managers with more information than the simple static budget variance. These variances suggest that the marketing department did a job. They sold units than expected and sold them at a price than expected. Data table - X Data table CellBase Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount per Unit Units CellBase Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue $ 257,000 Variable Expenses 135,200 Contribution Margin 121,800 57,000 Fixed Expenses $ 64,800 Operating Income Sales Revenue 6,500 8,000 10,000 25 $ 162,500 $ 200,000 $ 250,000 13 84,500 104,000 130,000 78,000 96,000 120,000 56,000 56,000 56,000 $ 22,000 $ 40,000 $ 64,000 Variable Expenses Contribution Margin Fixed Expenses Operating Income Print Done Print Done