In: Accounting
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 $ 30 $ 125 Variable expense per unit $ 21 $ 25 Number of units sold annually 10,000 5,600 Fixed expenses total $565,500 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 $50 each and that has variable expenses of $35 per unit. If the company can sell 20,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.
Req 1. | ||||||
Contribution margin Income Statement | ||||||
Hawaiin | Tahitian | Total | ||||
Sales revenue | 300000 | 700000 | 1000000 | |||
Less: Variable cost | 210000 | 140000 | 350000 | |||
Contribution margin | 650000 | |||||
Less: Fixed cost | 565500 | |||||
Net income | 84500 | |||||
CM ratio: Total contribution/ Ttotal sales *100 | ||||||
650000 /1000000 *100 = 65% | ||||||
Break even sales = Fixed cost / CMm ratio | ||||||
565500 / 65% = 870000 | ||||||
Margin of saferty = Total sales - Break even sales | ||||||
1000,000- 870000 = 130000 | ||||||
% margin of safetty: 130000 /1000000*100 = 13% | ||||||
Req 2. | ||||||
Contribution margin Income Statement | ||||||
Hawaiin | Tahitian | Samoan | Total | |||
Sales revenue | 300000 | 700000 | 1000000 | 2000000 | ||
Less: Variable cost | 210000 | 140000 | 700000 | 1050000 | ||
Contribution margin | 950000 | |||||
Less: Fixed cost | 565500 | |||||
Net income | 384500 | |||||
CM ratio: Total contribution/ Ttotal sales *100 | ||||||
950000 /2000000 = 47.50% | ||||||
Break even sales = Fixed cost / CMm ratio | ||||||
565500/47.50% =1190526 | ||||||
Margin of saferty = Total sales - Break even sales | ||||||
2000000-1190526= 809474 | ||||||
% margin of safetty: 809474 / 2000000 *100 = 40.47% |