Question

In: Accounting

Problem 6-27 Sales Mix; Break-Even Analysis; Margin of Safety [LO6-7, LO6-9] Island Novelties, Inc., of Palau...

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.

Solutions

Expert Solution

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%

Related Solutions

Problem 5-27 Sales Mix; Break-Even Analysis; Margin of Safety [LO5-7, LO5-9] Island Novelties, Inc., of Palau...
Problem 5-27 Sales Mix; Break-Even Analysis; Margin of Safety [LO5-7, LO5-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 $ 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...
Problem 6-28 Sales Mix; Commission Structure; Multiproduct Break-Even Analysis [LO6-9] Carbex, Inc., produces cutlery sets out...
Problem 6-28 Sales Mix; Commission Structure; Multiproduct Break-Even Analysis [LO6-9] Carbex, Inc., produces cutlery sets out of high-quality wood and steel. The company makes a Standard set and a Deluxe set and sells them to retail department stores throughout the country. The Standard set sells for $86, and the Deluxe set sells for $101. The variable expenses associated with each set are given below. Standard Deluxe Variable production costs $ 28.00 $ 43.00 Sales commissions (28% of sales price) $...
Exercise 6-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO6-1, LO6-3, LO6-5, LO6-6,...
Exercise 6-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO6-1, LO6-3, LO6-5, LO6-6, LO6-7] Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 450,000 $ 30 Variable expenses 180,000 12 Contribution margin 270,000 $ 18 Fixed expenses 216,000 Net operating income $ 54,000 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the...
Explain the term sales mix and its effects on break-even sales. What is Margin of Safety...
Explain the term sales mix and its effects on break-even sales. What is Margin of Safety and how does it get used in CVP Analysis? How does a company determine sales mix when a company has limited resources? How does operating leverage affect profitability?
Problem 6-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6]...
Problem 6-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,200 units × $20 per unit) $ 264,000 Variable expenses 158,400 Contribution margin 105,600 Fixed expenses 117,600 Net operating loss $ (12,000 ) Required: 1. Compute...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8]...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 36,000 of these balls, with the following results: Sales (36,000 balls) $ 900,000...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8]...
Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 30,500 of these balls, with the following results: Sales (30,500 balls) $ 775,000...
Chapter 6 HOMEWORK Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4,...
Chapter 6 HOMEWORK Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 37,500 of these balls, with the following results: Sales (37,500...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6]...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6] Neptune Company produces toys and other items for use in beach and resort areas. A small, inflatable toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $2.60 per unit. Enough capacity exists in the company’s plant to produce 30,300 units of the toy each month. Variable expenses to manufacture and sell one...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6]...
Problem 6-25 Changes in Fixed and Variable Costs; Break-Even and Target Profit Analysis [LO6-4, LO6-5, LO6-6] Neptune Company produces toys and other items for use in beach and resort areas. A small, inflatable toy has come onto the market that the company is anxious to produce and sell. The new toy will sell for $2.90 per unit. Enough capacity exists in the company’s plant to produce 30,500 units of the toy each month. Variable expenses to manufacture and sell one...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT