In: Accounting
This Company produces a single product. Sales for the current year are 25,000 units. | ||||||||||
Relevant data: | ||||||||||
Selling price/unit | 130 | |||||||||
Variable cost/unit | 80 | |||||||||
Fixed costs | 1,300,000 | |||||||||
a) | What is their net income for the current year? | |||||||||
b) | Compute their breakeven point in sales units. | |||||||||
c) | Marketing Director believes that unit sales would increase by 20% if the price were cut by 10%. | |||||||||
Should they take this action? Explain. | ||||||||||
d) | Production Manager is considering outsourcing the production of some parts. This would reduce fixed | |||||||||
costs to $1,000,000, but increase variable cost/unit to $100. | ||||||||||
What would the breakeven point be if this action were taken? | ||||||||||
Answer a. | ||
Income Statement | ||
Sales - 25,000 Units X $130 | 3,250,000.00 | |
Variable Cost - 25,000 Units X $80 | 2,000,000.00 | |
Contribution Margin | 1,250,000.00 | |
Fixed Costs | 1,300,000.00 | |
Net Income | (50,000.00) | |
Answer b. | ||
Contribution Per Unit = $130 - $80 = $50 | ||
BEP (In Units) = Fixed Costs / Contribution Margin per Unit | ||
BEP (In Units) = $1,300,000 / $50 | ||
BEP (In Units) = 26,000 Units | ||
Answer c. | ||
Income Statement | ||
Sales - 30,000 Units X $117 | 3,510,000.00 | |
Variable Cost - 30,000 Units X $80 | 2,400,000.00 | |
Contribution Margin | 1,110,000.00 | |
Fixed Costs | 1,300,000.00 | |
Net Income | (190,000.00) | |
Sales in Units = 25,000 Units X 120% = 30,000 Units | ||
New SP per Unit = $130 X 90% = $117 | ||
The Company should not decrease there Selling Price, as it will increase their Loss from $50,000 to $190,000. | ||
Answer d. | ||
New Contribution per Unit = $130 - $100 = $30 per Unit | ||
New Fixed Cost = $1,000,000 | ||
BEP (In Units) = Fixed Costs / Contribution Margin per Unit | ||
BEP (In Units) = $1,000,000 / $30 | ||
BEP (In Units) = 33,333.33 or say 33,334 Units (Approx.) |