Question
Smithen Company, a wholesale distributor, has been operating for only a few months. The company sells three productssinks, mirrors, and vanities. Budgeted sales by product
Smithen Company, a wholesale distributor, has been operating for only a few months. The company sells three productssinks, mirrors, and vanities. Budgeted sales by product and in total for the coming month are shown below based on planned unit sales as follows:
Units | Percentage | ||||
Sinks | 1,000 | 50 | % | ||
Mirrors | 500 | 25 | % | ||
Vanities | 500 | 25 | % | ||
Total | 2,000 | 100 | % | ||
Product | ||||||||||||||||||||||||
Sinks | Mirrors | Vanities | Total | |||||||||||||||||||||
Percentage of total sales | 48 | % | 20 | % | 32 | % | 100 | % | ||||||||||||||||
Sales | $ | 408,000 | 100.00 | % | $ | 170,000 | 100.00 | % | $ | 272,000 | 100.00 | % | $ | 850,000 | 100.00 | % | ||||||||
Variable expenses | 80,000 | 19.61 | % | 66,000 | 38.82 | % | 90,000 | 33.09 | % | 204,300 | 24.04 | % | ||||||||||||
Contribution margin | $ | 328,000 | 80.39 | % | $ | 104,000 | 61.18 | % | $ | 182,000 | 66.91 | % | 645,700 | 75.96 | % | |||||||||
Contribution margin per unit | $ | 328.00 | $ | 208.00 | $ | 364.00 | ||||||||||||||||||
Fixed expenses | 602,300 | |||||||||||||||||||||||
Operating income | $ | 43,400 | ||||||||||||||||||||||
Break-even point in sales dollars | = | Fixed expenses | = | $602,300 | = | $792,868.21 | |
Overall CM ratio | 0.76 | ||||||
Break-even point in unit sales:
Total Fixed expenses | = | $602,300 | = 1,961.89 units | |
Weighted-average CM per unit | ||||
$307.00* | ||||
*($328.00 0.50) + ($208.00 0.25) + ($364.00 0.25) |
As shown by these data, operating income is budgeted at $43,400 for the month, break-even sales dollars at $792,868.21, and break-even unit sales at 1,961.89.
Assume that actual sales for the month total $856,800 (2,100 units), with the CM ratio and per unit amounts the same as budgeted. Actual fixed expenses are the same as budgeted, $602,300. Actual sales by product are as follows: sinks, $214,200 (525 units); mirrors, $357,000 (1,050 units); and vanities, $285,600 (525 units).
Required:
1.Prepare a contribution format income statement for the month based on actual sales data.(Round your answers to 2 decimal places.)
Product | ||||||||||||||||||||||||
Sinks | Mirrors | Vanities | Total | |||||||||||||||||||||
Percentage of total sales | $ | ....... | % | % | % | % | ||||||||||||||||||
Sales | $ | .... | .... | % | $ | % | $ | % | $ | % | ||||||||||||||
Variable expenses | $ | .... | % | % | % | % | ||||||||||||||||||
Contribution margin | $ | ........ | % | $ | .. | % | $ | % | % | |||||||||||||||
Fixed expenses | ||||||||||||||||||||||||
Operating income | $ | |||||||||||||||||||||||
2.Compute the break-even point in sales dollars for the month, based on the actual data.(Round your percentage answers to nearest whole percent. Round other intermediate values and final answer to the nearest whole dollar.)
3.Calculate the break-even point in unit sales for the month, based on the actual data.(Do not round your intermediate calculations. Round your final answer to the nearest whole number.)
4.This part of the question is not part of your Connect assignment.
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