Menlo Company distributes a single product. The company’s sales and expenses for last month follow:
Answer -
1. Answer -
Monthly break-even point (in unit sales):
= Fixed expenses / Contribution margin per unit
= $145200 / $12
= 12100 units
Monthly break-even point (in dollar sales):
= Break-even point (in unit sales) * Sales price per unit
= 12100 * $40
= $484000
2. Answer -
The contribution margin is $145200 because the contribution margin is equal to the fixed expenses at the break-even point.
Total contribution margin at break-even point = $145200
3-a. Answer -
Unit sold to attain target profit:
= [Target profit + Fixed expenses] / Contribution margin per unit
= [$66000 + $145200] / $12
= 17600 units
3-b. Answer -
Menlo Company | ||
Contribution Income Statement | ||
Total | Per unit | |
Sales | $704000 | $40 |
Variable expenses | $492800 | $28 |
Contribution margin | $211200 | $12 |
Fixed expenses | $145200 | |
Net operating income | $66000 |
Calculation:
a. Sales = [17600 units * $40 per unit] = $704000
b. Variable expenses = [17600 units * $28 per unit] = $492800
c. Contribution margin = Sales - Variable expenses = $704000 - $492800 = $211200
d. Contribution margin per unit = Sales price per unit - Variable expenses per unit = $40 - $28 = $12
e. Net operating income = Contribution margin - Fixed expenses = $211200 - $145200 = $66000
4. Answer -
Margin of safety (in dollars):
= Total sales - Break-even sales
= $636000 - $484000
= $152000
Margin of safety ( in percentage terms):
= [Margin of safety in dollars / Total sales] * 100
= [$152000 / $636000] * 100
= 23.90%
5. Answer -
Contribution margin ratio (CM ratio):
= [(Sales price per unit - Variable expenses per unit) / Sales price per unit] * 100
= [($40 - $28) / $40] * 100
Contribution margin ratio (CM ratio) = 30%
And
Total contribution margin = Total sales * Contribution margin ratio
Total contribution margin = $636000 * 30%
Total contribution margin = $190800
Here,
Sales increase by $76000 per month and there is no change in fixed expenses.
So, Expected total sales = $636000 + $76000 = $712000
And
Expected total contribution margin = Expected total sales * Contribution margin ratio
Expected total contribution margin = $712000 * 30%
Expected total contribution margin = $213600
Then,
Increased total contribution margin = Expected total contribution margin - Total contribution margin
= $213600 - $190800 = $22800
As per given information there is no change in fixed expenses.
So,
Increased total contribution margin = Increased net operating income
Therefore, monthly net operating income will increase by $22800
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 632,000 $ 40 Variable expenses 442,400 28 Contribution margin 189,600 $ 12 Fixed expenses 144,000 Net operating income $ 45,600 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 at the break-even point? 3-a. How many units would have to be sold each...
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 $ 624,000 436,800 187,200 145,200 $ 42,000 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 total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
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 $ 620,000 434,000 186,000 145,200 $ 40, 800 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 total contribution margin at the break-even point? 3-a. How many units would have to be sold...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: 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: Sales Variable expenses Contribution margin Fixed expenses Net operating income Total $ 640,000 448,000 192,000 146,400 $ 45,600 Per Unit $ 40 28 $ 12 Required: 1. What is the monthly break-even...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 320,000 $ 20 Variable expenses 224,000 14 Contribution margin 96,000 $ 6 Fixed expenses 75,000 Net operating income $ 21,000 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 at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 600,000 $ 40 Variable expenses 420,000 28 Contribution margin 180,000 $ 12 Fixed expenses 151,200 Net operating income $ 28,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 at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 616,000 $ 40 Variable expenses 431,200 28 Contribution margin 184,800 $ 12 Fixed expenses 144,000 Net operating income $ 40,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 at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 304,000 $ 20 Variable expenses 212,800 14 Contribution margin 91,200 $ 6 Fixed expenses 73,800 Net operating income $ 17,400 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 at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 628,000 $ 40 Variable expenses 439,600 28 Contribution margin 188,400 $ 12 Fixed expenses 153,600 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 computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 628,000 $ 40 Variable expenses 439,600 28 Contribution margin 188,400 $ 12 Fixed expenses 151,200 Net operating income $ 37,200 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 at the break-even point? 3-a. How many units would have to be sold each...