Req 1 : | |
Contribution margin per unit = Contribution margin / Units sold = 103200 / 12900 | 8 |
Contribution margin ratio = Contribution margin / Sales = 103200 / 258000 | 40% |
Break-even point in units = Fixed expenses / Contribution margin per unit = 115200 / 8 | 14400 |
Break-even point in dollars = Fixed expenses / Contribution margin ratio = 115200 / 40% | 288000 |
Req 2 : | |
Increase in Contribution margin ( Increase in sales * Contribution margin ratio = 89000 * 40% ) | 35600 |
(-) Increase in advertising budget | 6800 |
Increase (decrease) in net operating income | 28800 |
Increase in monthly net operating income | 28800 |
Req 3 : | |
Revised selling price = Current selling price * ( 1 - % reduction ) = 20 * ( 1 - 10% ) | 18 |
Current unit variable cost = Variable expenses / Units sold = 154800 / 12900 | 12 |
Revised fixed costs = Current fixed costs + Increase in advertising expense = 115200 + 30000 | 145200 |
Revised sales units = Current sales units * 2 = 12900 * 2 | 25800 |
Sales ( 25800 * 18 ) | 464400 |
(-) Variable expenses ( 25800 * 12 ) | 309600 |
Contribution margin | 154800 |
(-) Fixed expenses | 145200 |
Net operating income (loss) | 9600 |
Req 4 : | |
Revised unit variable cost = Current unit variable cost + 0.50 = 12 + 0.50 | 12.50 |
Units sales to attain target profit = ( Target profit + Fixed expenses ) / ( Selling price - Unit variable cost ) = ( 4300 + 115200 ) / ( 20 - 12.50 ) | 15933 |
Req 5A : | |
Revised unit variable cost = 12 - 3 | 9 |
Revised fixed expenses = 115200 + 54000 | 169200 |
Contribution margin per unit = Selling price - Unit variable cost = 20 - 9 | 11 |
CM ratio = Contribution margin per unit / Selling price = 11 / 20 | 55% |
Break-even point in unit sales = Fixed costs / Contribution margin per unit = 169200 / 11 | 15382 |
Break even point in dollar sales = Fixed costs / CM ratio = 169200 / 55% | 307636 |
Req 5B : | ||||||
Not automated | Automated | |||||
Total | Per unit | % | Total | Per unit | % | |
Sales | 400000 | 20 | 100% | 400000 | 20 | 100% |
Variable expenses | 240000 | 12 | 60% | 180000 | 9 | 45% |
Contribution margin | 160000 | 8 | 40% | 220000 | 11 | 55% |
Fixed expenses | 115200 | 169200 | ||||
Net operating income | 44800 | 50800 |
Req 5C : |
Answer : Yes |
Explanation : If the company sells 20000 units, then the company will earn more net operating income if it automates 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 financial
difficulty for some time. The company’s contribution format income
statement for the most recent month is given below:
Sales (12,900 units × $20 per unit)
$
258,000
Variable expenses
129,000
Contribution margin
129,000
Fixed expenses
144,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,200 units * $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 396,000 237,600 158, 400 176,400 $ (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 (13,200 units x $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 396,000 198,000 198,000 220,500 $ (22,500) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
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 * $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 396,000 237,600 158, 400 176,400 $ (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,800 units X $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 384,000 230,400 153,600 171,600 $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales 2. The president believes...
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) Variable expenses Contribution margin Fixed expenses Net operating loss $ 378,000 226,800 151,200 169,200 $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
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) Variable expenses Contribution margin Fixed expenses Net operating loss $ 399,000 239,400 159,600 177,600 $ (18,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
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,100 units * $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 393,000 235, 800 157,200 175, 200 $ (18,000) Required: Reg 1 Reg 2 Req3 Req 4 Req 5A Req 5B Req 5C Compute the company's CM ratio...
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 X $20 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 254,000 152,400 101,600 113,600 $ (12,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...
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,788 units * $38 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 381, ea 228.688 152,4ee 170,400 $ (18,eee) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales 2. The president...