In: Accounting
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?
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 |