In: Finance
Multiple Product Planning with Taxes
In the year 2008, Wiggins Processing Company had the following
contribution income statement:
WIGGINS PROCESSING COMPANY Contribution Income Statement For the Year 2008 |
||
---|---|---|
Sales | $1,000,000 | |
Variable costs | ||
Cost of goods sold | $400,000 | |
Selling and administrative | 200,000 | (600,000) |
Contribution margin | 400,000 | |
Fixed Costs | ||
Factory overhead | 180,000 | |
Selling and administrative | 80,000 | (260,000) |
Before-tax profit | 140,000 | |
Income taxes (40%) | (56,000) | |
After-tax profit | $84,000 |
HINT: Round the contribution margin ratio to two decimal places for your calculations below.
(a) Determine the annual break-even point in sales
dollars.
$Answer
(b) Determine the annual margin of safety in sales dollars.
$Answer
(c) What is the break-even point in sales dollars if management
makes a decision that increases fixed costs by $60,000?
Answer
(d) With the current cost structure, including fixed costs of
$260,000, what dollar sales volume is required to provide an
after-tax net income of $190,000?
Do not round until your final answer. Round your answer to the
nearest dollar.
$Answer
(e) Prepare an abbreviated contribution income statement to verify
that the solution to part (d) will provide the desired after-tax
income.
Round your answers to the nearest dollar. Use rounded answers for subsequent calculations. Do not use negative signs with any of your answers.
WIGGINS PROCESSING COMPANY Income Statement For the Year 2008 |
||
---|---|---|
Sales | Answer | |
Variable costs | Answer | |
Contribution margin | Answer | |
Fixed costs | Answer | |
Net income before taxes | Answer | |
Income taxes (40%) | Answer | |
Net income after taxes | Answer |
Answer a.
Contribution margin ratio = Contribution margin / Sales
Contribution margin ratio = $400,000 / $1,000,000
Contribution margin ratio = 0.40
Breakeven point in sales dollars = Fixed costs / Contribution
margin ratio
Breakeven point in sales dollars = $260,000 / 0.40
Breakeven point in sales dollars = $650,000
Answer b.
Margin of safety = Sales - Breakeven point in sales
dollars
Margin of safety = $1,000,000 - $650,000
Margin of safety = $350,000
Answer c.
Fixed costs = $260,000 + $60,000
Fixed costs = $320,000
Breakeven point in sales dollars = Fixed costs / Contribution
margin ratio
Breakeven point in sales dollars = $320,000 / 0.40
Breakeven point in sales dollars = $800,000
Answer d.
After-tax net income = Before-tax taxable income * (1 - Tax
rate)
$190,000 = Before-tax taxable income * (1 - 0.40)
Before-tax taxable income = $316,666.667
Required sales = (Fixed costs + Before-tax taxable income) /
Contribution margin ratio
Required sales = ($260,000 + $316,666.667) / 0.40
Required sales = $1,441,667
Answer e.