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 23 Styles E 1 | D lexible Budgets & Performance Analysis HIKILIMNOPQR 4 pts each A company has developed the Plan data in September The actual results for the month of June are presented, 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 9) Revenue variance for June h) Revenue variance For U 1) Spending variance for expenses in June Spending variance For U CLEARLY SHOW YOUR WORK BELOW: Data used in analysis Plan Cost Formulas Actual Plan Revenue units Selling price per unit 4.250 23.25 5,000 22.70 S Duect materials Direct labor Variable overhead Rent Utilities 31,600 14.250 5,850 11,500 1.650 64.850 32,500 S 6.50 Per 15,000 $ 3.00 Per 9,250 $ 1.85 Per 12.000 $ 12,000.00 fixed 1.500 $ 1.500.00 fixed Total expenses 70 250 Financial Statements Master Budgeting 1 Master Budgeting 2 Flexible Budgets Capital Budgeting 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 23 Styles E 1 | D lexible Budgets & Performance Analysis HIKILIMNOPQR 4 pts each A company has developed the Plan data in September The actual results for the month of June are presented, 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 9) Revenue variance for June h) Revenue variance For U 1) Spending variance for expenses in June Spending variance For U CLEARLY SHOW YOUR WORK BELOW: Data used in analysis Plan Cost Formulas Actual Plan Revenue units Selling price per unit 4.250 23.25 5,000 22.70 S Duect materials Direct labor Variable overhead Rent Utilities 31,600 14.250 5,850 11,500 1.650 64.850 32,500 S 6.50 Per 15,000 $ 3.00 Per 9,250 $ 1.85 Per 12.000 $ 12,000.00 fixed 1.500 $ 1.500.00 fixed Total expenses 70 250 Financial Statements Master Budgeting 1 Master Budgeting 2 Flexible Budgets Capital Budgeting