Question
The master budget for the year just ended was on a computer that was just hacked. You feel responsible because you didnt install anti-hacking software
The master budget for the year just ended was on a computer that was just hacked. You feel responsible because you didnt install anti-hacking software on the computer and you didnt have a backup file. Rather than admit your mistake to your supervisor, you are trying to reconstruct the budget. You have learned the following information.
Sales volume | 182,000 | units | |
Sales revenue | $ | 978,000 | |
Variable costs: | |||
Manufacturing | 328,000 | ||
Marketing and administrative | 90,100 | ||
Fixed costs: | |||
Manufacturing | 200,000 | ||
Marketing and administrative | 86,000 | ||
Operating profit | $ | 273,900 | |
You know that the company planned to sell 164,000 units at a price of $5 each. Variable marketing and administrative costs are budgeted at 12 percent of revenue. You have discovered that the manufacturing fixed costs are budgeted to be $1.50 per unit at the budgeted volume. You know that the company policy is to budget for an operating profit of one dollar per unit. Finally, you recall that the master budget for fixed marketing and administrative costs is $82,000.
Required: Prepare a report explaining the differences between the actual results, flexible budget, and the master budget. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
can you please give me the answer in this form? same form, please. I just don't want to be confused.
Profit Variance Analysis Actual Manufacturing Variance Marketing and Administrative Variance Sales Price Variance Flexible Budget Sales Activity Variance Master Budget Sales units Sales revenue Variable costs: 182,000 978,000 182,000 910,000 164,000 820,000 $ 68,000F $ $ 90,000 F $ 73,200U 328,000 $ 90,100 559,900 $ 19,100F 254,800 109,200 546,000 $ 25,200U 10,800U 54,000 F 229,600 98,400 492,000 $ 13,900F $ $ Manufacturing Marketing and administrative Contribution margin Fixed costs: Manufacturing Marketing and administrative Operating profit 73,000 u 200,000 86,000 273,900 5,000 F 273,000 273,000 91,000 182,000 $ 27,000 F 9,000 F 18,000F | 246,000 82,000 164,000 $ 91,900F $ $Step 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