complete requirements 4 through 6

The Everlasting Balloon Company produces party balloons that are sold in multi-pack cases. Following is the company's performance report in contribution margin format for August: B. (Click the icon to view the performance report in contribution margin format.) Read the requirements. The budgeted variable expense per unit is $ 2.10 Requirement 3. What is the budgeted fixed cost for the period? The budgeted fixed cost for the period is $ 67,000 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 62,500 units and the budgeted sales volume of 59,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 54,000 to 72,500 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. Label each variance as favorable (F) or unfavorable (U). If the variance is 0, make sure to enter in a "0". A variance of zero is considered favorable.) The Everlasting Balloon Company Flexible Budget Performance Report For the Month Ended August 31 Flexible Budget Flexible Volume Variance Budget Variance Master Master Actual 62500 Budget 59000 Budget Variance 3500 F Sales volume Sales revenue 218600 200600 18000F 134900 123900 Less: Variable expenses 11000 U Contribution margin 83700 684001 76700 670001 7000 F 1400 u Less: Fixed expenses Operating income 15300 9700 5600 Choose from any list or enter any number in the input fields and then click Check Answer. Data Table A B D 1 The Everlasting Balloon Company Actual vs. Budget Performance Report 2 3 For the Month Ended August 31 Master Budget Master Budget Variance Actual 4 Sales volume (number of cases 5 sold) 62,500 59,000 6 Sales revenue $ 218,600 $ 200,600 7 Less: Variable expenses 134,900 123,900 8 Contribution margin 83,700 $ 76,700 9 Less: Fixed expenses 68,400 67,000 $ 10 Operating income 15,300 $ 9,700 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 62,500 units and the budgeted sales volume of 59,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 54,000 to 72,500 units. 6. Using the flexible budget performance report you prepared for Requirement 5, answer the following questions: a. 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? d. What is the volume variance for fixed expenses? Why is it this amount? C