Cellular Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 9.000, 10,500, and 12.500 units. The static budget was based on expected sales of 10,500 units. The company sold 12,500 units during July. Its flexible budget and actual operating income was as follows: B (Click the icon to view the flexible budget.) (Click the icon to view the income statement.) Read the requirements Requirement 1. Prepare a flexible budget performance report for July (Enter a "O" for any zero balances. For any S0 variances, leave the Favorable (F/Unfavorable (U) input blank.) 5 Cellular Technologies Flexible Budget Performance Report For the Month Ended July 31, 2018 3 (1)-(3) Flexible Actual Budget Flexible Results Variance Budget 4 (3) - (5) Sales Volume Variance Static Budget Budget Amounts Per Unit Units Sales Revenue L23 Variable Expenses 15 Contribution Margin Fixed Expenses Operating Income A Data Table A Data Table Cellular Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue $ 294,500 Variable Expenses 192,600 Contribution Margin 101,900 Fixed Expenses 59,500 $ 42,400 Operating Income Print Done Cellular Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount per Unit 9,000 S 23 5 207,000 $ 15 135,000 72.000 58,000 14,000 $ Units 12,500 287,500 187,500 Sales Revenue Variable Expenses Contribution Margin Fixed Expenses Operating Income 10,500 241,500 $ 157,500 84.000 58,000 26,000 $ 100.000 58,000 42,000 Clear All Check