Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing difficulty for some time. The company’s contribution format income statement for the most recent month is given below:
Total (Tk.) |
Per Unit |
Percent of Sales |
|
Sales (19,500 units) |
5,85,000 |
30 |
100% |
Variable Expense |
4,09,500 |
21 |
? % |
Contribution Margin |
1,75,500 |
9 |
? % |
Fixed Expenses |
1,80,000 |
||
Net Operation Income |
(4,500) |
Required:
Answer 1.
Contribution Margin Ratio = Contribution Margin per unit /
Selling Price per unit
Contribution Margin Ratio = $9.00 / $30.00
Contribution Margin Ratio = 30%
Breakeven Point in unit sales = Fixed Expenses / Contribution
Margin per unit
Breakeven Point in unit sales = $180,000 / $9.00
Breakeven Point in unit sales = 20,000
Breakeven Point in dollar sales = Fixed Expenses / Contribution
Margin Ratio
Breakeven Point in dollar sales = $180,000 / 0.30
Breakeven Point in dollar sales = $600,000
Answer 2.
Increase in Sales = $80,000
Increase in Fixed Expenses = $16,000
Increase in Net Operating Income = Increase in Sales *
Contribution Margin Ratio - Increase in Fixed Expenses
Increase in Net Operating Income = $80,000 * 0.30 - $16,000
Increase in Net Operating Income = $8,000
Answer 3.
Selling Price per unit = $30.00 - 10% * $30.00
Selling Price per unit = $27.00
Fixed Expenses = $180,000 + $60,000
Fixed Expenses = $240,000
Number of units sold = 2 * 19,500
Number of units sold = 39,000
Net Operating Income (Loss) = Number of units sold * (Selling
Price per unit - Variable Cost per unit) - Fixed Expenses
Net Operating Income (Loss) = 39,000 * ($27.00 - $21.00) -
$240,000
Net Operating Income (Loss) = -$6,000
Answer 4.
Variable Cost per unit = $21.00 + $0.75
Variable Cost per unit = $21.75
Contribution Margin per unit = Selling Price per unit - Variable
Cost per unit
Contribution Margin per unit = $30.00 - $21.75
Contribution Margin per unit = $8.25
Required Unit Sales = (Fixed Expenses + Target Profit) /
Contribution Margin per unit
Required Unit Sales = ($180,000 + $9,750) / $8.25
Required Unit Sales = 23,000
Answer 5-a.
Variable Cost per unit = $21.00 - $3.00
Variable Cost per unit = $18.00
Fixed Expenses = $180,000 + $72,000
Fixed Expenses = $252,000
Contribution Margin per unit = Selling Price per unit - Variable
Cost per unit
Contribution Margin per unit = $30.00 - $18.00
Contribution Margin per unit = $12.00
Contribution Margin Ratio = Contribution Margin per unit /
Selling Price per unit
Contribution Margin Ratio = $12.00 / $30.00
Contribution Margin Ratio = 40%
Breakeven Point in unit sales = Fixed Expenses / Contribution
Margin per unit
Breakeven Point in unit sales = $252,000 / $12.00
Breakeven Point in unit sales = 21,000
Breakeven Point in dollar sales = Fixed Expenses / Contribution
Margin Ratio
Breakeven Point in dollar sales = $252,000 / 0.40
Breakeven Point in dollar sales = $630,000
Answer 5-b.
Answer 5-c.
Yes, company should automate its operations
Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been...
Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing difficulty for some time. The company’s contribution format income statement for the most recent month is given below: Total (Tk.) Per Unit Percent of Sales Sales (19,500 units) 5,85,000 30 100% Variable Expense 4,09,500 21 ? % Contribution Margin 1,75,500 9 ? % Fixed Expenses 1,80,000 Net Operation Income (4,500) Required: Compute the company’s CM ratio and its break-even point...
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 (19,500 units × $30 per unit)
$
585,000
Variable expenses
409,500
Contribution margin
175,500
Fixed expenses
180,000
Net operating loss
$
(4,500
)
Required:
1. Compute the company’s CM ratio and its break-even point in
unit sales and dollar sales.
2. The...
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 (12,600 units × $30 per unit) $ 378,000 Variable expenses 226,800 Contribution margin 151,200 Fixed expenses 169,200 Net operating loss $ (18,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president...
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 (12,600 units × $20 per unit) $ 252,000 Variable expenses 126,000 Contribution margin 126,000 Fixed expenses 141,000 Net operating loss $ (15,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president...
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:
Required:
1. Compute the company’s CM ratio and its break-even point in
unit sales and dollar sales.
2. The president believes that a $6,900 increase in the monthly
advertising budget, combined with an intensified effort by the
sales staff, will result in an $81,000...
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,300 units × $30 per unit) $ 399,000 Variable expenses 239,400 Contribution margin 159,600 Fixed expenses 177,600 Net operating loss $ (18,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The...
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 (12,500 units × $30 per unit) $ 375,000 Variable expenses 187,500 Contribution margin 187,500 Fixed expenses 210,000 Net operating loss $ (22,500 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The...
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 132,000 Contribution margin 132,000 Fixed expenses 147,000 Net operating loss $ (15,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The...
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,000 units × $20 per unit) $ 260,000 Variable expenses 130,000 Contribution margin 130,000 Fixed expenses 145,000 Net operating loss $ (15,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The...
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 (12,700 units × $30 per unit) $ 381,000 Variable expenses 228,600 Contribution margin 152,400 Fixed expenses 170,400 Net operating loss $ (18,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The...