Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help filling in the table with an explanation how how to find the numbers please. The Flowing Balloon Company produces party balloons that
I need help filling in the table with an explanation how how to find the numbers please.
The Flowing 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 October: E: (Click the icon to view the performance report in contribution margin format.) Read the requirements Requirement 1. What is the budgeted sales price per unit? The budgeted sales price per unit is $ 2.70 Requirement 2. What is the budgeted variable expense per unit? The budgeted variable expense per unit is $ 1.30 Requirement 3. What is the budgeted fixed cost for the period? The budgeted fixed cost for the period is $ 71,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,000 units and the budgeted sales volume of 51,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 46,000 to 60,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. 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.) Requirements Data Table mancer A B c D 1 2 The Flowing Balloon Company Actual vs. Budget Performance Report For the Month Ended October 31 orable performa 3 due to ld costs, Master Budget Variance 4 Actual 1. What is the budgeted sales price per unit? 2. What is the budgeted variable expense per unit? 3. What is the budgeted fixed cost for the period? 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 55,000 units and the budgeted sales volume of 51,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 46,000 to 60,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? 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? Master Budget 51,000 to the s. Then p". A var 5 Sales volume (number of cases sold) 55,000 6 Sales revenue $ 160,700 137,700 a. 7 Less: Variable expenses 76,300 66,300 8 Contribution margin $ 84,400 $ b. 71,400 71,000 9 Less: Fixed expenses 71,800 C. 10 Operating income $ 12,600 $ 400 U Print Done Print Done The Flowing Balloon Company Flexible Budget Performance Report For the Month Ended October 31 Flexible Budget Flexible Volume Variance Budget Variance OU 55000 Master Budget Variance ou Master Budget 51000 Actual 55000 F. 160700 F 137700 23000 F 76300 U 66300 10000 Sales volume Sales revenue Less: Variable expenses Contribution margin Less: Fixed expenses Operating income c|| 71400 13000 84400 71800 BILD 71400 400 12600 400 12200 F F FStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started