| Req. 1 | ||
| Break-even point in unit sales = Fixed expenses / Contribution margin per unit = 75000 / 6 | 12500 | units |
| Break-even point in dollar sales = Break-even point in unit sales * Selling price per unit = 12500 * 20 | 250000 |
| Req. 2 | |
| Total contribution margin ( at break-even point ) | 75000 |
| Explanation : Break-even point is the sales level where there is no profit or loss, thus the contribution margin at break-even point equals to the fixed expenses. | |
| Req 3A | ||
| Units sold = ( Target profit + Fixed expenses ) / Contribution margin per unit = ( 35400 + 75000 ) / 6 | 18400 | units |
| Req 3B | ||
| Menlo Company | ||
| Contribution Income Statement | ||
| Total | Per unit | |
| Sales ( 18400 * 20 ) | 368000 | 20 |
| Variable expenses ( 18400 * 14 ) | 257600 | 14 |
| Contribution margin | 110400 | 6 |
| Fixed expenses | 75000 | |
| Net operating income | 35400 | |
| Req 4 | ||
| Before tax target profit = After tax target profit / ( 1 - Tax% ) = 35400 / ( 1 - 30% ) | 50571 | |
| Units sales required = ( Before tax Target profit + Fixed expenses ) / Contribution margin per unit = ( 50571 + 75000 ) / 6 | 20929 | units |
| Req 5 | |
| Margin of safety in dollars = Sales - Break even point in dollar sales = 302000 - 250000 | 52000 |
| Margin of safety percentage = ( Sales - Break even point in dollar sales ) / Sales = ( 302000 - 250000 ) / 302000 | 17.22% |
| Dollars | Percentage | |
| Margin of safety | 52000 | 17.22% |
| Req 6 | |
| CM ratio = Contribution margin per unit / Sales per unit = 6 / 20 | 30% |
| Net operating income increase by = ( Increase in sales * CM ratio ) - Increase in fixed cost = ( 71000 * 30% ) - 0 | 21300 |
Problem 4-22 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO5-1, LO5-3, LO5-5, LO5-6,...
Problem 4-22 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio (LO5-1, LO5-3, LO5-5, LO5-6, LO5-7) + Menlo Company distributes a single product. The company's sales and expenses for last month follow: ints Sales Variable expenses Total $ 636,000 445,200 Per Unit $ 40 28 Skipped $ 12 Contribution margin Fixed expenses 190, 800 145,200 Net operating income $ 45, 600 eBook Ask Required: 1. What is the monthly break-even point in unit sales and in dollar sales? Print...
Exercise 5-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO5-1, LO5-3, LO5-5, LO5-6, LO5-7] Menlo Company distributes a single product. The company's sales and expenses for last month follow: Per Unit $20 14 Sales Variable expenses Contribution margin Fixed expenses Net operating income Total $ 310,000 217,000 93,000 73,200 $ 19,800 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin...
Exercise 5-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio (LO5-1, LO5-3, LO5-5, LO5-6, LO5-7) Menlo Company distributes a single product. The company's sales and expenses for last month follow: Sales Variable expenses Contribution margin Fixed expenses Net operating income Total $ 608,000 425,600 182,400 154,800 $ 27,600 Per Unit $ 40 28 $ 12 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the...
Problem 4-22 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO5-1, LO5-3, LO5-5, LO5-6, LO5-7] Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 604,000 $ 40 Variable expenses 422,800 28 Contribution margin 181,200 $ 12 Fixed expenses 146,400 Net operating income $ 34,800 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to...
Exercise 5-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio (LO5-1, LO5-3, LO5-5, LO5-6, LO5-7) Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 450,000 180,000 270,000 216,000 $ 54,000 Per Unit $ 30 12 $ 18 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the...
PROBLEM 4-22 Break-Even Analysis: Target Profit Analysis; Margin of Safety: CM Ratio ILOI. LO3, LO5, L06, L07) Menlo Company distributes a single product. The company's sales and expenses for last month follow: Total Per Unit $30 ....................... $450,000 Variable expenses....... 180.000 Contribution margin..... 270,000 Fixed expenses ........... 216.000 Operating income......... ... $ 54.000 $18 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin...
Exercise 5-18 (Algo) Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio (LO5-1, LO5-3, LO5-5, LO5-6, LO5-7) Menlo Company distributes a single product. The company's sales and expenses for last month follow: Per Unit $ 40 28 Sales Variable expenses Contribution margin Fixed expenses Net operating income Total $ 624,000 436,800 187,200 151,200 $ 36,000 $ 12 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is...
Exercise 6-18 Break-Even and Target Profit Analysis; Margin of Safety; CM Ratio [LO6-1, LO6-3, LO6-5, LO6-6, LO6-7] Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 300,000 $ 20 Variable expenses 210,000 14 Contribution margin 90,000 $ 6 Fixed expenses 76,200 Net operating income $ 13,800 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] 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) Variable expenses Contribution margin Fixed expenses Net operating loss $264,000 132,000 132,000 147,000 $(15,000) Required: 1. Compute the company's CM ratio...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure (LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] 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 x $30 per unit) Variable expenses Contribution margin Fixed expenses Net operating loss $ 387,000 193,500 193,500 216,000 $ (22,500) Required: 1. Compute the company's...