The Blowing Balloon Company Actual vs. Budget Performance Report For the Month Ended May 31 Master Master Budget Actual Budget Variance Sales volume (number of cases sold) 58,000 52,000 $151,000 130,000 Sales revenue 71,400 62,400 Less: Variable expenses $ 79,600 $ Contribution margin 67,600 68,500 67,000 Less: Fixed expenses 11,100 $ 600 Operating income 4. Compute the master budget variances. Be sure to indicate each variance as favorable (F) or unfavorable (U.) 5. Management would like to determine the portion of the master budget variance that is (a) due to volume being different than originally anticipated, and (b) due to some other unexpected cause. Prepare a flexible budget performance report to address these questions, using the actual sales volume of 58,000 units and the budgeted sales volume of 52,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 47,000 to 63,000 units 6. Using the flexible budget performance report you prepared for Requirement 5, answer the following questions: How much of the master budget variance (calculated in Requirement 4) for operating income is due to volume being higher than expected? . b. How much of the master budget variance for variable expenses is due to some cause other than volume? What could account for the flexible budget variance for sales revenue? C. d. What is the volume variance for fixed expenses? Why is it this amount? Requirements 4 and 5. Compute the master budget variances. Be sure to indicate each variance as favorable (F) or unfavorable (U.) Management would like to determine the portion of the master budget variance that is (a) due to volume being different than originally anticipated, and (b) due to some other unexpected cause. Prepare a flexible budget performance report to address these questions, using the actual sales volume of 58,000 units and the budgeted sales volume 52,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 47,000 to 63,000 units Begin by completing the actual and master budget columns of the performance report and then the master budget variances. Then compute the flexible budget column and the remaining variance columns. (Round all amounts to the nearest whole dollar. For accounts with a 0 balance, make sure to enter "0" in the appropriate column. Label each variance as favorable (F) or unfavorable (U).) The Blowing Balloon Company Flexible Budget Performance Report For the Month Ended May 31 Flexible Master Budget Flexible Volume Master Budget Actual Variance Budget Variance Budget Variance Sales volume Sales revenue Less: Variable expenses Contribution margin Less: Fixed expenses Operating income The Blowing Balloon Company Actual vs. Budget Performance Report For the Month Ended May 31 Master Master Budget Actual Budget Variance Sales volume (number of cases sold) 58,000 52,000 $151,000 130,000 Sales revenue 71,400 62,400 Less: Variable expenses $ 79,600 $ Contribution margin 67,600 68,500 67,000 Less: Fixed expenses 11,100 $ 600 Operating income 4. Compute the master budget variances. Be sure to indicate each variance as favorable (F) or unfavorable (U.) 5. Management would like to determine the portion of the master budget variance that is (a) due to volume being different than originally anticipated, and (b) due to some other unexpected cause. Prepare a flexible budget performance report to address these questions, using the actual sales volume of 58,000 units and the budgeted sales volume of 52,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 47,000 to 63,000 units 6. Using the flexible budget performance report you prepared for Requirement 5, answer the following questions: How much of the master budget variance (calculated in Requirement 4) for operating income is due to volume being higher than expected? . b. How much of the master budget variance for variable expenses is due to some cause other than volume? What could account for the flexible budget variance for sales revenue? C. d. What is the volume variance for fixed expenses? Why is it this amount? Requirements 4 and 5. Compute the master budget variances. Be sure to indicate each variance as favorable (F) or unfavorable (U.) Management would like to determine the portion of the master budget variance that is (a) due to volume being different than originally anticipated, and (b) due to some other unexpected cause. Prepare a flexible budget performance report to address these questions, using the actual sales volume of 58,000 units and the budgeted sales volume 52,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 47,000 to 63,000 units Begin by completing the actual and master budget columns of the performance report and then the master budget variances. Then compute the flexible budget column and the remaining variance columns. (Round all amounts to the nearest whole dollar. For accounts with a 0 balance, make sure to enter "0" in the appropriate column. Label each variance as favorable (F) or unfavorable (U).) The Blowing Balloon Company Flexible Budget Performance Report For the Month Ended May 31 Flexible Master Budget Flexible Volume Master Budget Actual Variance Budget Variance Budget Variance Sales volume Sales revenue Less: Variable expenses Contribution margin Less: Fixed expenses Operating income