Question

In: Accounting

Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost,...

Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost, and sales data for the two products follow:


Hawaiian Fantasy

Tahitian

Joy

  Selling price per unit $ 14 $ 120
  Variable expenses per unit $ 7 $ 36
  Number of units sold annually 24,000 5,200
Fixed expenses total $510,300 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 break-even point in dollar sales for the company as a whole and the margin of safety in both dollars and percent. Round your "Margin of safety percentage" to 1 decimal place (i.e .1234 should be entered as 12.3).

         

2.

The company has developed a new product to be called Samoan Delight. Assume that the company could sell 14,000 units at $60 each. The variable expenses would be $42 each. The company’s fixed expenses would not change.

a.

Prepare another contribution format income statement, including sales of the Samoan Delight (sales of the other two products would not change). Round your "Percentage" answers to 1 decimal place (i.e .1234 should be entered as 12.3).

         

b.

Compute the company’s new break-even point in dollar sales and the new margin of safety in both dollars and percent. Round your dollar amounts to nearest whole number. Round your "Percentage" answer to 1 decimal place (i.e .1234 should be entered as 12.3).

         

Solutions

Expert Solution

Island Novelties Inc.,

Contribution Margin Income Statement -

Answer to 1 (a)

Answer to 1 (b)

Break-even point in Sales is the volume of sales at which level the total revenue equals the total costs. At this point the Company is at a position of no gain or no loss.

Break-even point in sales value can be calculated by dividing the fixed costs by the contribution margin ratio

However, the contribution margin ratio is calculated by dividing the contribution margin by sales

Therefore, in the given instance contribution margin ratio is equal =

Margin of Safety - It is the additional sales value that is over the break-even sales. It also indicates the amount of sales that a Company can loose before it becomes unprofitable

Margin of Safety = Actual Sales - Break Even Sales

= 960000-810000

= $150,000.00

Margin of Safety in % = (Actual Sales - Break Even Sales) / Actual Sales x 100

=(960000-810000)/960000*100

= 15.6%

Answer to 2 (a)

Revised contribution margin statement including the sales of new product Samaon Delight

Answer to 2 (b)

New break even point in dollar sales


Related Solutions

Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost,...
Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost, and sales data for the two products follow: Hawaiian Fantasy Tahitian Joy Selling price per unit $20.00 $25.00 Variable expenses per unit $14.00 $10.00 Number of units sold annually 25,000 10,000 Fixed expenses total $270,000 per year. The Republic of Palau uses the U.S. dollar as its currency. Required: 1. Assuming the sales mix given above, do the following: a. Prepare a contribution format...
Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost,...
Island Novelties, Inc., of Palau makes two products, Hawaiian Fantasy and Tahitian Joy. Present revenue, cost, and sales data on the two products follow:                                                           Hawaiian Fantasy      Tahitian Joy    Selling price per unit                                     $15                        $100    Variable expenses per unit                               9                           20    Number of units sold annually              20,000                      5,000 Fixed expenses total $475,800 per year. The Republic of Palau uses the U.S. dollar as its currency. Assuming the sales mix given above, do...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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. 2. The company has developed a new product called Samoan Delight that sells for $50 each and that has variable...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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 $ 25 $ 120 Variable expense per unit $ 15 $ 42 Number of units sold annually 14,000 7,500 Fixed expenses total $580,000 per year. Required: 1. Assuming the sales mix given above, do the following: a. Prepare a contribution format income statement showing both...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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 $ 125 Variable expense per unit $ 14 $ 25 Number of units sold annually 30,000 5,200 Fixed expenses total $652,400 per year. Required: 1. Assuming the sales mix given above, do the following: a. Prepare a contribution format income statement showing both...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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 $ 150 Variable expense per unit $ 12 $ 30 Number of units sold annually 37,000 7,400 Fixed expenses total $912,000 per year. Required: 1. Assuming the sales mix given above, do the following: a. Prepare a contribution format income statement showing both...
Island Novelties, Inc., of Palau makes two products—Hawaiian Fantasy and Tahitian Joy. Each product's selling price,...
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 $ 40 $ 140 Variable expense per unit $ 24 $ 28 Number of units sold annually 39,000 6,000 Fixed expenses total $907,200 per year. Required: 1. Assuming the sales mix given above, do the following: a. Prepare a contribution format income statement showing both...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT