In: Accounting
Betty DeRose, Inc. produces and sells three products. Information about
these products for 2022, the most recent year, appears below:
Product A Product B Product C
selling price per unit $33 $49 $24
variable costs per unit $14 $37 $11
number of units sold 22,000 18,000 25,000
Betty DeRose, Inc. reported total fixed costs of $195,636 in 2022.
Calculate the number of units of Product B that needed to be sold
in 2022 in order for Betty DeRose, Inc. to earn a net income of
$498,680.
|
Product A |
Product B |
Product C |
TOTAL |
|
|
(22000/65000) |
(18000/65000) |
(25000/65000) |
||
|
Product Mix |
33.85% |
27.69% |
38.46% |
100.00% |
|
Working |
Product A |
Product B |
Product C |
TOTAL |
|
|
A |
Price |
$ 33.00 |
$ 49.00 |
$ 24.00 |
|
|
B |
Variable Cost per unit |
$ 14.00 |
$ 37.00 |
$ 11.00 |
|
|
C = A - B |
Contribution Margin per unit |
$ 19.00 |
$ 12.00 |
$ 13.00 |
|
|
D |
Product Mix |
33.85% |
27.69% |
38.46% |
100.00% |
|
E = C x D |
Weighted Average Contribution Margin |
$ 6.43 |
$ 3.32 |
$ 5.00 |
$ 14.75 |
|
A |
Total Fixed Cost |
$ 195,636.00 |
|
B |
Desired Profits before Tax |
$ 498,680.00 |
|
C = A + B |
Total Contribution margin required |
$ 694,316.00 |
|
D |
Weighted Average Contribution Margin |
14.75 |
|
E = C/D |
Total no. of Units required for earning desired profits |
47,060 |
|
F x 33.85% |
Product A |
15,928 |
|
F x 27.69% |
Product B |
13,032 |
|
F x 38.46% |
Product C |
18,100 |
Number of Product B to be sold =13032