Question

In: Accounting

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 unit would be $1.84, and fixed expenses associated with the toy would total $47,995 per month.

The company's Marketing Department predicts that demand for the new toy will exceed the 30,500 units that the company is able to produce. Additional manufacturing space can be rented from another company at a fixed expense of $2,400 per month. Variable expenses in the rented facility would total $2.03 per unit, due to somewhat less efficient operations than in the main plant.

Required:

1. What is the monthly break-even point for the new toy in unit sales and dollar sales.

2. How many units must be sold each month to attain a target profit of $11,136 per month?

3. If the sales manager receives a bonus of 15 cents for each unit sold in excess of the break-even point, how many units must be sold each month to attain a target profit that equals a 24% return on the monthly investment in fixed expenses?

Solutions

Expert Solution

Solution 1:
Normal Contribution Margin per unit
Selling Price $2.90
Other Variable Cost $1.84
Contribution per Unit $1.06
Contribution Margin from Rented Space
Selling Price $2.90
Other Variable Cost $2.03
Contribution per Unit $0.87
Computation of Break Even Point
Current Fixed Costs $47,995
Less: Recovered by Current Contribution margin (30500*1.06) $32,330
Unrecovered Fixed Cost $15,665
Add: Additional Fixed Cost $2,400
Total additional fixed costs to be Recovered   $18,065
/ Contribution margin Per Unit from rented space $0.87
Additional Number of Units 20764
Total Breakeven Units (30500 + 20764) 51264
Breakeven Point in Dollares(Break even units*$2.90) $1,48,667
Soltuion 2:
Computation of Total Units to be sold
Total additional fixed costs to be Recovered   $18,065
Add: Desired Profit $11,136
Additional Contribution $29,201
Contribution Margin per Unit $0.87
Additional Number of Units 33564
Total units to be Sold (30500 + 33564) 64064
Solution 3:
Computation of New Contribution margin per unit
Variable Cost $2.03
Add: Bonus $0.15
Total Variable Cost $2.18
Selling Price $2.90
New Contribution Margin per Unit $0.72
Compuattion of Total units to be sold
Total Fixed Investment (47995+2400) $50,395
Desired Profit(Fixed Investment * 24%) $12,095
New Contribution margin per Unit $0.72
Number of Units (Desired profit*New contr. Margin per unit) 16798
Total units to be Sold(51264+16798) 68063

Related Solutions

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 5-25A Changes in Fixed and Variable Expenses; Break-Even and Target Profit Analysis [LO5-4, LO5-5, LO5-6]...
Problem 5-25A Changes in Fixed and Variable Expenses; Break-Even and Target Profit Analysis [LO5-4, LO5-5, LO5-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.50 per unit. Enough capacity exists in the company’s plant to produce 30,700 units of the toy each month. Variable expenses to manufacture and sell one...
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...
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-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-24A Companywide and Segment Break-Even Analysis; Decision Making [LO6-4, LO6-5] Toxaway Company is a merchandiser...
Problem 6-24A Companywide and Segment Break-Even Analysis; Decision Making [LO6-4, LO6-5] Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential   Sales $ 1,005,000 $ 335,000 $ 670,000...
Problem 6-24 Companywide and Segment Break-Even Analysis; Decision Making [LO6-4, LO6-5] Toxaway Company is a merchandiser...
Problem 6-24 Companywide and Segment Break-Even Analysis; Decision Making [LO6-4, LO6-5] Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 840,000 $ 280,000 $ 560,000...
Problem 6-19 Break-Even Analysis; Pricing [LO6-1, LO6-4, LO6-5] Minden Company introduced a new product last year...
Problem 6-19 Break-Even Analysis; Pricing [LO6-1, LO6-4, LO6-5] Minden Company introduced a new product last year for which it is trying to find an optimal selling price. Marketing studies suggest that the company can increase sales by 5,000 units for each $2 reduction in the selling price. The company’s present selling price is $98 per unit, and variable expenses are $68 per unit. Fixed expenses are $834,600 per year. The present annual sales volume (at the $98 selling price) is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT