Req 1 : | |
Contribution margin per unit = Contribution margin / Units sold = 198000 / 13200 = | 15 |
CM ratio = Contribution margin / Sales = 198000 / 396000 = | 50% |
Break-even point in units = Fixed expenses / Contribution margin per unit = 220500 / 15 = | 14700 |
Break-even point in dollars = Fixed expenses / Contribution margin ratio = 220500 / 50% = | 441000 |
Req 2 : | |
Increase in Contribution margin ( Increase in sales * Contribution margin ratio = 88000 * 50% ) | 44000 |
(-) Increase in advertising budget | 6800 |
Increase (decrease) in net operating income | 37200 |
Net operating income increases | by | 37200 |
Req 3 : | |
Revised selling price = Current selling price * ( 1 - % reduction ) = 30 * ( 1 - 10% ) = | 27 |
Current unit variable cost = Variable expenses / Units sold = 198000 / 13200 = | 15 |
Revised fixed costs = Current fixed costs + Increase in advertising expense = 220500 + 31000 = | 251500 |
Revised sales units = Current sales units * 2 = 13200 * 2 = | 26400 |
Sales ( 26400*27 ) | 712800 |
(-) Variable expenses ( 26400*15 ) | 396000 |
Contribution margin | 316800 |
(-) Fixed expenses | 251500 |
Net operating Income (loss) | 65300 |
Revised net operating Income (loss) | 65300 |
Req 4 : | |
Revised unit variable cost = Current unit variable cost + 0.70 = 15 + 0.70 = | 15.70 |
Units sales to attain target profit = ( Target profit + Fixed expenses ) / ( Selling price - Unit variable cost ) = ( 4100 + 220500 ) / ( 30 - 15.70 ) = | 15706 |
Req 5A : | |
Current unit variable cost = Variable expenses / Units sold = 198000 / 13200 = | 15 |
Revised unit variable cost = 15 - 3 = | 12 |
Revised fixed expenses = 220500 + 50000 = | 270500 |
Contribution margin per unit = Selling price - Unit variable cost = 30 - 12 = | 18 |
CM ratio = Contribution margin per unit / Selling price = 18 / 30 = | 60% |
Break-even point in unit sales = Fixed costs / Contribution margin per unit = 270500 / 18 = | 15028 |
Break even point in dollar sales = Fixed costs / CM ratio = 270500 / 60% = | 450833 |
Req 5B : | ||||||
Not automated | Automated | |||||
Total | Per unit | % | Total | Per unit | % | |
Sales | 624000 | 30.00 | 100.00% | 624000 | 30.00 | 100.00% |
Variable expenses | 312000 | 15.00 | 50.00% | 249600 | 12.00 | 40.00% |
Contribution margin | 312000 | 15.00 | 50.00% | 374400 | 18.00 | 60.00% |
Fixed expenses | 220500 | 270500 | ||||
Net operating income | 91500 | 103900 |
Req 5C : |
Answer : Yes |
Explanation : If the company sells 20800 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 (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,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 (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,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 (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,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 (13,200 units * $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 396,000 198,000 198,000 229,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 (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...
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...