hi can you please help me with this question.

Cellular Technologies manufactures capacitors for celular base stations and other communications applications. The company's July 2010 flexible budget shows output levels of 7,500. 9,000, and 11.000 units. The static budget was based on expected sales of 9,000 units. The company gold 11,000 units during July. Is Nexible budget and actual operaling income was as follows: Click the icon to view the flexible budget) Click the icon to view the income statement.) Read the reguirements i Data Table 1 Requirement 1. Prepare a flexible budget performance report for July. (Enter a ' for any zero balances. For any $0 variances, leave the favorable (F/Unfavorable (U) input blank] Cellular Technologies Data Table Flexible Budget Performance Report For the Month Ended July 31, 2018 2 3 4 5 Cellular Technologies (1)-(3) (3) - (5) Income Statement Budget Flexible Sales For the Month Ended July 31, 2018 Amounts Actual Budget Flexible Volume Static Sales Revenue $ 280.000 Per Unit Results Variance Budget Varianca Budget 159 200 Variable Expenses Units 11.000 11,000 9,000 Contribution Margin 100.800 Sales Revenu 23 % 280,000's 7,000 F's 250,000$ 48,000 207.000 E 51.000 Fixed Expenses 14 Variable Expenses 159,200 5,200 u 154,000 28,000 126,000 $ 49.400 Contribution Margin 100,00 1,800F DID 18,00DF 91.000 Operating Income 51,000 Fixed Expenses 1,000 50,000 U 50,000 $ BOD $ 49.000 18,000 $ 31,000 Print Donie Operating Income Cellular Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount per Unit 3 Unit B,000 Sales Revenue S 23 $ 7,500 172.500 5 105.000 207,000 S 128.000 11,000 253,000 154.000 14 1 49,800's Variable Expenses Contribution Margin Fixed Expenses Operating income 67.500 50.000 17,500 S 81.000 50 000 99,000 50,000 31,000 40,000 Flexible Budget Variance $ 20 Sales Volume Variance $ 18,000 Print Done - Static Budget Variance $ 18,800F This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers. ? Requirement 2. What was the effect on Cellular'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 increased Cellular's operating income by $ 18,000 Requirement 3. What is Cellular's static budget variance for operating income? 18,800 favorable meaning that its operating income is higher than expected Cellular's static budget variance is $ per the static budget. Requirement 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? Choose two reasons why the flexible budget performance report provides Cellular's managers with more information than the simple static budget variance. A favorable sales volume variance reveals whether profits increased due to more units being sold. A favorable sales revenue flexible budget variance means the sale price was higher than planned. These variances suggest that the marketing department did a good job. They sold more units than expected and sold them at a higher price than expected. This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers. company said 12.000 units during a bla brand other communications applications. The company's July 2010 fexbia budget Shos autout lavni of B, 500, 100 and 12.000 units. The statin bungat was based on expected sales of 10,000 units. The 20 a " company said 12,000 units during July. Its flexibil: bucgest and actual operating income was as follows: Cick the icon to view the flexible budget.) Click the icon to view the income statement.) i Data Tablo Read the requirements 1 Phone Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue S S 283,000 Variable Expenses 173,000 Contribution Margin 110,000 Fixed Experts 51,500 S 59,00 Operating Income Requirement 1. Prepare a flexible budget performance repurl for July. (Enter a '0" for any zero balances. For any S0 variances, leave the favorable (F) Unfavorabile (U) impul blank.) Phone Technologies Dala Table Flexible Budget Performance Report For the Month Ended July 31, 2018 2 3 4 5 Phone Technologies (3) - (5) Flexible Budget Budget Flexible Sales For the Month Ended July 31, 2018 Amounts Actual Budget Flexible Volume Static Budget Per Unit Results Variance Budget Variance Amount Units per Unit Salas Revenue Units 8,500 Variable Expenses Sales Revenue $ 23 S 195,KID $ Conlibution Margin Variable Expenses 14 119,000 Fixed Expenses n Contribution Margin 78,500 Operating Income SIDID Fixed Expenses S 25,500 $ Requirements Operating Incoma Budget Print Dane 10,000 230,00 $ 140,000 12,000 276,0X10 168,000 Please schets 90,000 DXD 100,000 saxar 40,DID $ 58,000 Print Donc 1. Prepare a flexible budget performance report for July. 2. What was the effect on Phore's operaling incorle al seling 2,000 units more than the state budget level of sales? 3. What is Phone's stali buugul variance for operaling income? 4. Explain why the flexible budget performance report provides more useful informacion to Phonie's raragens than the simple static budge. variance What insights can Phone's managers dreta from this performance report? Choose from any list or 5 5 parts remaining Clear All Check