CellBase Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 7,000, 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.

(1) Please help me with preparing a flexible budget performance report for July

(2) What was the effect on CellBases 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) And can you please explain why the flex budget performance report provides more useful information to CellBase's managers that the simple static budget variance & what insights from the managers gain from the performance reports?

Thanks in advance :)

Tumput VIUMIN.) CellBase Technologies Flexible Budget Performance Report For the Month Ended July 31, 2018 2 3 (1) - (3) 5 4 (3) - (5) Budget Flexible Sales Amounts Actual Budget Flexible Volume Static Per Unit Results Variance Budget Variance Budget Units Sales Revenue Variable Expenses Contribution Margin Fixed Expenses Operating Income CellBase Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount per Unit Units Sales Revenue 25 $ 7,500 187,500 $ 82,500 9,000 225,000 $ 99,000 11,000 275,000 121,000 Variable Expenses Contribution Margin Fixed Expenses 105,000 51,000 54,000 $ 126,000 51,000 75,000 $ 154,000 51,000 103,000 Operating Income $ CellBase Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue $ 282,000 126,100 Variable Expenses Contribution Margin 155,900 52,000 Fixed Expenses | 103,900 Operating Income