Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer all the questions and show work if you can, I'll make sure to up vote, thank you! Data Table Requirements 1. What is
Please answer all the questions and show work if you can, I'll make sure to up vote, thank you!
Data Table Requirements 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 The Creative Balloon Company Actual vs. Budget Performance Report For the Month Ended May 31 Master Master Budget Budget Variance 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 60,000 units and the budgeted sales volume of 58,000 units. Use the original budget assumptions for sales price, variable cost per unit, and fixed costs, assuming the relevant range stretches from 53,000 to 75,000 units. Actual Sales volume (number of cases sold) Sales revenue 58,000 $ 204,800 $ 179,800 87,000 $ 108,800$92,800 63,000 $ 44,300 29,800 60,000 6. Using the flexible budget performance report you prepared for Requirement 5, answer the following 96,000 Less: Variable expenses Contribution margin Less: Fixed expenses 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? What is the volume variance for fixed expenses? Why is it this amount? a. 64,500 b. Operating income c. d. Print Done Print Done dit fields and then click CheckStep 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