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 | $ | 20 | $ | 100 | ||
Variable expense per unit | $ | 13 | $ | 30 | ||
Number of units sold annually | 34,000 | 7,200 | ||||
Fixed expenses total $651,900 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.
1A.
|
1B.
Break-even point in dollar sales | ||
Margin of safety in dollars | ||
Margin of safety percentage | % |
Contribution Income Statement |
||||||
Hawaiian Fantasy |
Tahitian Joy |
Total |
||||
Amount |
% |
Amount |
% |
Amount |
% |
|
Sales revenue |
$ 680,000.00 |
100% |
$ 720,000.00 |
100% |
$ 1,400,000.00 |
100% |
Variable Cost |
$ 442,000.00 |
65% |
$ 216,000.00 |
30% |
$ 658,000.00 |
47% |
Contribution margin |
$ 238,000.00 |
35% |
$ 504,000.00 |
70% |
$ 742,000.00 |
53% |
Fixed Cost |
$ 651,900.00 |
|||||
Net Income |
$ 90,100.00 |
A |
Fixed Cost |
$ 651,900.00 |
B |
Total CM Ratio |
53% |
C = A/B |
Break Even in Sales Dollars |
$ 1,230,000.00 |
D |
Total Sales Revenue |
$ 1,400,000.00 |
E = D - C |
Margin of Safety in Sales dollars |
$ 170,000.00 |
F = (E/D) x 100 |
Margin of Safety % |
12% |