Question

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 companys contribution format income statement for the most recent month is given below: Sales (19,500 units x $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $585,00e 409,50e 175,500 180,000 $ (4,500) Required 1. Compute the companys CM ratio and its break-even point in unit sales and dollar sales 2. The president believes that a $16,000 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in an $80,000 increase in monthly sales. If the president is right, what will be the increase (decrease) in the companys monthly net operating income? 3. Refer to the original data. The sales manager is convinced that a 10% reduction in the selling price, combined with an increase of $60,000 in the monthly advertising budget, will double unit sales. If the sales manager is right, what will be the revised net operating income (loss)? 4. Refer to the original data. The Marketing Department thinks that a fancy new package for the laptop computer battery would grow sales. The new package would increase packaging costs by 75 cents per unit. Assuming no other changes, how many units would have to be sold each month to attain a target profit of $9,750? 5. Refer to the original data. By automating, the company could reduce variable expenses by $3 per unit. However, fixed expenses would increase by $72,000 each month a. Compute the new CM ratio and the new break-even point in unit sales and dollar sales b. Assume that the company expects to sell 26,000 units next month. Prepare two contribution format income statements, one assuming that operations are not automated and one assuming that they are. (Show data on a per unit and percentage basis, as well as in total, for each alternative.) C. Would you recommend that the company automate its operations (Assuming that the company expects to sell 26,000)?

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

1 CM ratio or Contribution margin Ratio is the difference between a companys sales and variable expenses, expressed as a percentage CM Ratio (Sales-Variable expenses)/Sales Sales Variable Expenses- CM Ratio $585000 $409500 ($585000-$409500)/$585000 30% the break-even point is defined as a point where total expense are equal to total sales. IT can be described as a point where there is no net profit or loss Break even point in Units- Fixed Expenses Sale Price per unit- Variable Expenses per unit- Fixed Expenses/(Sales Price per unit - Variable expenses per unit) $180000 $30 ($409500/19500 units) $21 $180000/($30-$21) 20000 Units Break even point in Units- Break even point in Dollars- Break even point in Units*Sales price per unit 20000 Units $30 $6000002 The increase in advertisment expenses by $16000 results in increase in fixed expenses to $196000 ($180000+$16000) The increase in advertisment expenses resulted in increase in sales by $80000 i.e addition of 2667 units ($80000/$30/unit- 2666.67units) Sales (22167units at $30 Variable expenses (22167units $21) Contribution Margin Fixed Expenses Net operating income $665000 $465507 $199493 $196000 $34933 Revised salling price per unit $27 (Original selling price is redused by 10%) Revised Sales unit (Doubled as a result of decreased selling price and increase in advertisment) Fixed expenses ($180000+$60000) 39000 Units $240000 Revised net operating income (Loss) Sales (39000units at $27 Variable expenses (39000units $21) Contribution Margin Fixed Expenses Net operating income (Loss) $1053000 $819000 $234000 $240000 ($6000)

4 increase in packaging cost would increase variable expense by 75cents Profit sales - variable expenses - fixed expenses Profit = $9750 Sales unit = Let us assume X sales in dollars $30X Variable expenses- $21.75X Fixed Expenses = $180000 $9750-$30x-$21.75X-$180000 $189750 $8.25X X-$189750/$8.25 23000 Units A sale of 23000 units at $30 would yield a profit of $9750

$585000 $351000 Sales Variable expenses (19500units at $18 ($21-$3) Fixed Expenses ($180000+$72000) 5a $252000 CM Ratio (Sales-Variable expenses)/Sales CM Ratio Break even point in Units- Break even point in Units- Break even point in Dollars- Break even point in Dollars- ($585000-$351000)/$585000 40% Fixed Expenses/(Sales Price per unit - Variable expenses per unit) $252000/($30-$18) 21000 Units Break even point in Units Sales price per unit 21000 Units $305b Net operating income (Loss) under Automated process $780000 Sales (26000 units at $30) Variable expenses (26000 units*$18) Contribution Margin Fixed Expenses Net operating income (Loss) $468000 $312000 $252000 $60000 Net operating income (Loss) under Normal process Sales (26000 units at $30) Variable expenses (26000 units *$21) Contribution Margin Fixed Expenses Net operating income (Loss) $780000 $546000 $234000 $252000 ($18000) The company is advised to adopt automated process which would result in earning operating profit of $60000 as comapred to normal process which results in a Loss of $18000 5c

Add a comment
Know the answer?
Add Answer to:
Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has been...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Due to erratic sales of its sole product a high-capacity battery for laptop computers-PEM, Inc., has...

    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) Variable expenses Contribution margin Fixed expenses Net operating loss $ 585,000 409,500 175,500 180,000 $ 4,500) 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.,...

    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. S585.000 Sales (19,500 units * $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss 409,500 175,500 180,000 $ (4,500) 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...

    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...

  • 5B: Due to erratic sales of its sole product-a high-capacity battery for laptop computers-PEM, Inc., has...

    5B: 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 x $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 585,000 409,500 175,500 180,000 $ (4,500) 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...

    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 $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 384,000 192,000 192,000 214,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...

    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 president...

  • 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 (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...

    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 199,500 199,500 222,000 $ (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...

    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,400 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...

  • 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,100 units X $20 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 262,000 131,000 131,000 146,000 $ (15,000) Required: 1. Compute the company's CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT