Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | PEM | |||||||
Battery | ||||||||
Requirement 1 | Laptop | |||||||
Selling Price per unit | $ 20 | |||||||
Less: Variable Cost per unit | $151,200/12,600 | $ -12 | ||||||
Contribution Margin per unit | $ 8 | |||||||
Contribution Margin Ratio | $8/$20 | 40.00% | ||||||
BEP in Units | $112,800/$8 | 14,100 | ||||||
BEP in Sales Dollars | $112,800/40% | $ 282,000 | ||||||
Requirement 2 | ||||||||
Incremental Contribution | $80,000 Sale*40% CM Ratio | $ 32,000 | ||||||
Less: Incremental Advertising Cost | $ -6,500 | |||||||
Increase in Monthly Net Income | $ 25,500 | |||||||
Requirement 3 | ||||||||
New Sales Volume | 12,600*2 | 25,200 | ||||||
New Selling Price | $20-10% | $ 18 | ||||||
Sales | 25,200 Units*$18 | $ 453,600 | ||||||
Less: Variable Cost | 25,200 Units*$12 | $ -302,400 | ||||||
Contribution Margin | $ 151,200 | |||||||
Less: Fixed Cost | $112,800+$33,000 | $ -145,800 | ||||||
Net Income | $ 5,400 | |||||||
Existing Loss | $ -12,000 | |||||||
Increase in Income by | $ 17,400 | |||||||
Requirement 4 | ||||||||
Selling Price per unit | $ 20 | |||||||
New Variable Cost per Unit | $12+$0.60 | $ -12.60 | ||||||
Contribution Margin | A | $ 7.40 | ||||||
Fixed Expense | B | $ 112,800 | ||||||
Target Profit | C | $ 4,300 | ||||||
No of Units to be Sold | (B+C)/A | 15,824 | ||||||
Requirement 5A | ||||||||
Selling Price per unit | $ 20 | |||||||
New Variable Cost per Unit | $12-$3 | $ -9.00 | ||||||
Contribution Margin | A | $ 11.00 | ||||||
Fixed Expense ($112,800+$51,000) | B | $ 163,800 | ||||||
CM Ratio | $11/$20 | 55.00% | ||||||
BEP in Units | $163,800/$11 | 14,891 | ||||||
BEP in Sales Dollars | $163,800/55% | $ 297,818 | ||||||
Requirement 5B | ||||||||
Not Automated | Automated | |||||||
Total | Per unit | % | Total | Per unit | % | |||
Sales | 20,900*$20 | $ 418,000 | $ 20 | 100% | $ 418,000 | $ 20 | 100% | |
Less: Variable Expense | 20,900*$12 & 9 | $ -250,800 | $ -12 | -60% | $ -188,100 | $ -9 | -45% | |
Contribution Margin | $ 167,200 | $ 8 | 40% | $ 229,900 | $ 11 | 55% | ||
Less: Fixed Expense | $ -112,800 | $ -163,800 | ||||||
Net Income | $ 54,400 | $ 66,100 | ||||||
Requirement 5C | ||||||||
Yes as Net income is more in this case |
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,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,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 (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,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 (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 (12,800 units * $20 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $256,000 153,600 102,480 114,400 $(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 that a...
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 * $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...
Help solving 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: $252,000 Sales (12,600 units X $20 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss 151,200 100,800 112,800 $(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 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...