In: Accounting
Problem 6-27 Sales Mix; Break-Even Analysis; Margin of Safety [LO6-7, LO6-9]
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product’s selling price, variable expense per unit, and annual sales volume are as follows:
Hawaiian Fantasy | Tahitian Joy | |||||
Selling price per unit | $ | 20 | $ | 100 | ||
Variable expense per unit | $ | 13 | $ | 40 | ||
Number of units sold annually | 22,000 | 6,600 | ||||
Fixed expenses total $506,000 per year.
Required:
1. Assuming the sales mix given above, do the following:
a. Prepare a contribution format income statement showing both dollar and percent columns for each product and for the company as a whole.
b. Compute the company's break-even point in dollar sales. Also, compute its margin of safety in dollars and its margin of safety percentage.
2. The company has developed a new product called Samoan Delight that sells for $55 each and that has variable expenses of $44 per unit. If the company can sell 10,000 units of Samoan Delight without incurring any additional fixed expenses:
a. Prepare a revised contribution format income statement that includes Samoan Delight. Assume that sales of the other two products does not change.
b. Compute the company’s revised break-even point in dollar sales. Also, compute its revised margin of safety in dollars and margin of safety percentage.
1-a. | ||||||
Island Novelties, Inc. | ||||||
Contribution Income Statement | ||||||
Hawaiian Fantasy | Tahitian Joy | Total | ||||
Amount | % | Amount | % | Amount | % | |
Sales | 440000 | 100% | 660000 | 100% | 1100000 | 100% |
Variable expenses | 286000 | 65% | 264000 | 40% | 550000 | 50% |
Contribution margin | 154000 | 35% | 396000 | 60% | 550000 | 50% |
Fixed expenses | 506000 | |||||
Net operating income | 44000 |
1-b. | |
Break-even point in dollars = Fixed expenses / Contribution margin ratio of company = 506000 / 50% | 1012000 |
Margin of safety in dollars = Sales - Break even point in dollars = 1100000 - 1012000 | 88000 |
Margin of safety percentage = Margin of safety in dollars / Sales = 88000 / 1100000 | 8.0% |
2-a. | ||||||||
Island Novelties, Inc. | ||||||||
Contribution Income Statement | ||||||||
Hawaiian Fantasy | Tahitian Joy | Samoan Delight | Total | |||||
Amount | % | Amount | % | Amount | % | Amount | % | |
Sales | 440000 | 100.0% | 660000 | 100.0% | 550000 | 100.0% | 1650000 | 100.0% |
Variable expenses | 286000 | 65.0% | 264000 | 40.0% | 440000 | 80.0% | 990000 | 60.0% |
Contribution margin | 154000 | 35.0% | 396000 | 60.0% | 110000 | 20.0% | 660000 | 40.0% |
Fixed expenses | 506000 | |||||||
Net operating income | 154000 |
2-b. | |
Break-even point in dollars = Fixed expenses / Contribution margin ratio of company = 506000 / 40.0% | 1265000 |
Margin of safety in dollars = Sales - Break even point in dollars = 1650000 - 1265000 | 385000 |
Margin of safety percentage = Margin of safety in dollars / Sales = 385000 / 1650000 | 23.3% |