Flexible Budgeting 4) A company has developed the Plan data in September. The actual results for the month of June are presented in the Excel worksheet, along with Plan data/rates. By building a Flexible Budget Performance Report, provide the answers to the questions as presented. Each answer correctly calculated is worth 4 points. a) Oper income for Plan in June b) Oper income for Flexible Budger in June c) Activity variance for Revenue d) Activity variance for Revenue For U e) Activity variance for total expenses f) Activity variance for Expenses For U g) Revenue variance for June h) Revenue variance For U i) Spending variance for expenses in June 1) Spending variance For U Page 2 of 3 Formatting Table ( f Student Name: HIMNO 4 pts ead A company has developed the Plan data in September The actual results for the month of June are presented, along with Plan de By building a Flexible Budget Performance Report, provide the answers Each answer correctly calculated is worth 4 points a) Oper income for Plan in June b) Oper income for Flexible Budger in June c) Activity variance for Revenue d) Activity variance for Revenue For U e) Activity variance for total expenses 1) Activity variance for Expenses For U g) Revenue variance for June h) Revenue variance For U Spending variance for expenses in June Spending variance For U CLEARLY SHOW YOUR WORK BELOW: Data used in analysis 5.000 4250 23 25 Revenue units Selling price per unit S 22 10 Direct materials Duct labor Variable overhead Rent Utilities 31.500 14.250 5850 11.500 1.650 32.500 15 000 9.250 12 000 1.500 5 6.50 Per $ 300 Per $ 105 Per S 12 000 00 foxed $ 1.500.00 fored 64.850 Total expenses Budgets Capital Budgeting Master geting 2 Master Budgeting Financial Statements