can you do all four requirements

England Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 8,500, 10,000, and 12,000 units. The static budget was based on expected sales of 10,000 units. The company sold 12,000 units during July. Its flexible budget and actual operating income was as follows: (Click the icon to view the flexible budget.) (Click the loon to view the Income statement.) ci Data Table Read the resulrements England Technologies Flexible Budget For the Month Ended July 31, 2018 Budget Amount 4 5 Requirement 1. Prepare a flexible budget performance report for July. (Enter a "O" for any zero balances. For any $0 variances, leave the Favorable (FV England Technologies Flexible Budget Performance Report For the Month Ended July 31, 2018 1 2 3 (1)-(3) (3) - (5) Budget Flexible Sales Amounts Actual Budget Flexible Volume Static Per Unit Results Variance Budget Variance Budget Units per Unit Units 8,500 10,000 Sales Revenue S 24 $ 204,000 S 93,500 240,000 $ 110,000 12,000 288,000 132,000 11 Variable Expenses Contribution Margin 110,500 52,000 130,000 52,000 156,000 52,000 Sales Revenue ses Data Table $ 58,500 S 78,000 $ pome 104,000 Variable Expenses Contribution Margin Fixed Expenses Print Done Operating Income i Requirements Choose from any | ? England Technologies Income Statement For the Month Ended July 31, 2018 Sales Revenue S 295,000 Variable Expenses 137,000 Contribution Margin 158,000 Fixed Expenses 53,000 $ 105,000 Operating Income 5 parts 5 remaining 1. Prepare a flexible budget performance report for July. 2. What was the effect on England's operating income of selling 2,000 units more than the static budget level of sales? 3. What is England's static budget variance for operating income? 4. Explain why the flexible budget performance report provides more useful information to England's managers than the simple static budget variance. What insights can England's managers draw from this performance report? Check