How do I solve for the "Flexible Budget" column?

2x E10-38B (similar to) D Assigned Media 3 Question Help The Precious Balloon Company produces party balloons that are sold in multi-pack cases. To follow is the company's performance report in contribution margin format for March: (Click the icon to view the performance report in contribution margin format.) Read the requirements. The budgeted sales price per unit is $ 3.50 Requirement 2. What is the budgeted variable expense per unit? The budgeted variable expense per unit is $ 1.10 Requirement 3. What is the budgeted fixed cost for the period? The budgeted fixed cost for the period is $ 65,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 55,500 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 65,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. For accounts with a 0 balance, make sure to enter "0" in the appropriate column. Label each variance as favorable (F) or unfavorable (U).) Radengua Shp i The Precious Balloon Company - Data Table X Flexible Budget Performance Report For the Month Ended March 31 For the Month Ended March 31 Flexible Master Master Budget Flexible Volume Master Budget Master Budget Actual Variance Budget Variance Budget Variance Actual Budget Variance 55500 Sales volume OF 55500 3,500 FT 52000 55,500 52,000 Sales volume (number of cases sold) Sales revenue 207,000 182000 25,000 Sales revenue $ 207,000 $ 182,000 Less: Variable expenses 68,200 IN 194250 N 5 7,200 11,000 68,200 57,200 Less: Variable expenses Contribution margin 138,800 124,800 14,000 Contribution margin $ 138,800 $ 124,800 Less: Fixed expenses 66,200 1,200 U 65,000 65,000 1200 U 66,200 65,000 Less: Fixed expenses 72,600 12800 Operating income $ 72,600 $ 59,800 Operating income 3500 P C n 59,800 12800 FT