In: Accounting
Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $179,400 per month.
Required:
1. What is the break-even point in unit sales and in dollar sales?
2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)
3. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.
4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $77,000 per month?
Answer:
1.
Selling Price = $130 per unit
Variable Expenses = $91 per unit
Contribution Margin per unit = Selling price per unit - Variable expenses per unit = $130 - $91 = $39 per unit
Contribution Margin ratio = Contribution Margin per unit / Selling price per unit = $39 / $130 = 30%
Fixed cost = $179,400
Break-even (Units) = Total Fixed cost / Contribution Margin per unit
= $179,400 / $39
= 4,600 stoves
Break-even (Dollars) = Total Fixed cost / Contribution Margin ratio
= $179,400 / 30%
= $598,000
2.
If the variable expenses per stove increase as a percentage of the selling price, (Fixed expenses remain unchanged)
Then the Break-even in Dollar Sales remains same but the Break-even in Units will decrease because with the Increased selling price the company can attain Break-even by selling lesser quantity of units as compared to earlier
Let assume that there is 10% increase in both Selling price and Variable expenses (Fixed expenses are same)
Revised Selling Price = $130 * 110% = $143 per unit
Revised Variable Expenses = $91 * 110% = $100.1 per unit
Revised Contribution Margin per unit
= Revised Selling price per unit - Revised Variable expenses per unit = $143 - $100.1 = $42.9 per unit
Contribution Margin ratio = Contribution Margin per unit / Selling price per unit = $42.9 / $143 = 30%
Fixed cost = $179,400
Break-even (Units) = Total Fixed cost / Contribution Margin per unit
= $179,400 / $42.9
= 4,181.81
= 4,182 stoves
Break-even (Dollars) = Total Fixed cost / Contribution Margin ratio
= $179,400 / 30%
= $560,000
3.
Presently company is selling 8,000 stoves
Proposed Scenario
Revised Selling Price = $130 * 90% = $117 per unit
Revised Sales (Units) = 8,000 * 125% = 10,000 stoves
4.
Stoves to be sold under Proposed Scenario to attain target profit of $77,000
Proposed Scenario
Revised Selling Price = $130 * 90% = $117 per unit
Variable Expenses = $91 per unit
Contribution Margin per unit = Selling price per unit - Variable expenses per unit = $117 - $91 = $26 per unit
= [(Total Fixed Cost + Target Profit) / Contribution Margin per unit]
= [($179,400 + $77,000) / $26]
= $256,400 / $26
= 9,861.53
= 9,862 stoves