After-Tax Profit Targets Olivian Company wants to earn $540,000 in net (after-tax) income next year. Its product is priced at $350 per unit. Product costs include: Direct materials $105.00 Direct labor $77.00 Variable overhead $17.50 Total fixed factory overhead $420,000 Variable selling expense is $14 per unit; fixed selling and administrative expense totals $270,000. Olivian has a tax rate of 40 percent.
Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of $540,000. $
2. Calculate the number of units that will yield operating income calculated in Requirement 1 above. If required, round your answer to the nearest whole unit. units Hide Feedback Partially Correct Check My Work Feedback 1. After-tax Profit/(1-Tax Rate) = Before-Tax Profit.
2. The required number of units = (Fixed Costs + Target Profit)/Contribution Margin per Unit. Hide
3. Prepare an income statement for Olivian Company for the coming year based on the number of units computed in Requirement 2. Do NOT round interim calculations and, if required, round your answer to the nearest dollar. Olivian Company Income Statement For the Coming Year Total $ $ $ $ Hide Feedback Partially Correct Check My Work Feedback 3. See Cornerstone 16.4. Use a contribution margin format income statement.
4. What if Olivian had a 35 percent tax rate? Would the units sold to reach a $540,000 target net income be higher or lower than the units calculated in Requirement 2? Calculate the number of units needed at the new tax rate. In your calculations, round before-tax income to the nearest dollar. Round your answer to the nearest whole unit. units
Working:
Sales price per unit | 350.00 |
Less variable expenses | |
Direct materials | 105.00 |
Direct labor | 77.00 |
Variable overhead | 17.50 |
Variable selling expense | 14.00 |
Total variable expenses | 213.50 |
Contribution margin per unit | 136.50 |
Fixed costs: | |
Fixed factory overhead | 420000 |
Fixed selling and administrative expense | 270000 |
Total fixed costs $ | 690000 |
1. Before-tax profit = After-tax profit/(1 - Tax rate) = $540000/(1 - 0.40) = $540000/0.60 = $900000
2. The required number of units = (Fixed costs + Target profit)/Contribution margin per unit = ($690000 + $900000)/$136.50 = $1590000/$136.50 = 11648.35 = 11648 units
3.
Olivian Company | |
Income Statement | |
For the Coming Year | |
Total | |
Sales revenue (11648 x $350) | 4076800 |
Less: Variable expenses (11648 x $213.50) | 2486848 |
Contribution margin | 1589952 |
Less: Fixed expenses | 690000 |
Net operating income $ | 899952 |
4. Lower
Before-tax profit = After-tax profit/(1 - Tax rate) = $540000/(1 - 0.35) = $540000/0.65 = $830769.23 = $830769
The required number of units = (Fixed costs + Target profit)/Contribution margin per unit = ($690000 + $830769)/$136.50 = $1520769/$136.50 = 11141.16 = 11141 units
After-Tax Profit Targets Olivian Company wants to earn $540,000 in net (after-tax) income next year. Its...
After-Tax Profit Targets Olivian Company wants to earn $360,000 in net (after-tax) income next year. Its product is priced at $350 per unit. Product costs include: $105.00 Direct materials Direct labor Variable overhead Total fixed factory overhead $77.00 $17.50 $400,000 Variable selling expense is $14 per unit; fixed selling and administrative expense totals $250,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of $360,000. $ 600,000 2. Calculate...
Cornerstone Exercise 16.4 (Algorithmic) After-Tax Profit Targets Olivian Company wants to earn $360,000 in net (after-tax) income next year. Its product is priced at $400 per unit. Product costs include: Direct materials $120.00 Direct labor $88.00 Variable overhead $20.00 Total fixed factory overhead $440,000 Variable selling expense is $16 per unit; fixed selling and administrative expense totals $290,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of $360,000....
Erin Shelton, Inc., wants to earn a target profit of $860,000 this year. The company’s fixed costs are expected to be $1,120,000 and its variable costs are expected to be 60 percent of sales. Erin Shelton, Inc., earned $760,000 in profit last year. Required: 1. Calculate break-even sales for Erin Shelton, Inc. 2. Prepare a contribution margin income statement on the basis break-even sales. 3. Calculate the required sales to meet the target profit of $860,000. 4. Prepare a contribution...
Coronado, Inc. wants to sell a sufficient quantity of products to earn an after-tax profit of $27000. If the unit sales price is $10, unit variable cost is $8, and total fixed costs are $79000, how many units must be sold to earn income of $27000? Coronado, Inc. has a tax rate of 40%. 62000 units 63600 units 39500 units 94800 units
How many sales are required to earn a target after-tax net income of $87000 if total fixed costs are $92000, the contribution margin ratio is 40%, and the tax rate is 20%? O $6960000 O $230000 O $501875 O $1317500
CVP: Before- and After-Tax Targeted Income Head-Gear Company produces helmets for bicycle racing. Currently, Head-Gear charges a price of $240 per helmet. Variable costs are $96.00 per helmet, and fixed costs are $1,158,000. The tax rate is 25 percent. Last year, 14,000 helmets were sold. Required: 1. What is Head-Gear's net income for last year? $ 2. What is Head-Gear's break-even revenue? In your computations, round the contribution margin ratio to two decimal places. $ 3. Suppose Head-Gear wants to...
CVP: Before- and After-Tax Targeted Income Head-Gear Company produces helmets for bicycle racing. Currently, Head-Gear charges a price of $230 per helmet. Variable costs are $92.00 per helmet, and fixed costs are $1,158,000. The tax rate is 25 percent. Last year, 14,000 helmets were sold. Required: 1. What is Head-Gear's net income for last year? $ 2. What is Head-Gear's break-even revenue? In your computations, round the contribution margin ratio to two decimal places. $ 3. Suppose Head-Gear wants to...
Question 12 How many sales are required to earn a target after-tax net income of $88000 if total fixed costs are $96000, the contribution margin ratio is 40%, and the tax rate is 20%? O $7040000 O $%240000 $515000 $1340000
Cornerstone Exercise 16.5 (Algorithmic) Multiple-Product Break-Even and Target Profit Vandenberg, Inc., produces and sells two products: a ceiling fan and a table fan. Vandenberg plans to sell 40,000 ceiling fans and 80,000 table fans in the coming year. Product price and cost information includes: Ceiling Fan Table Fan Price $58 $13 Unit variable cost $16 $9 Direct fixed cost $22,400 $47,000 Common fixed selling and administrative expenses total $86,000. Required: 1. What is the sales mix estimated for next year...
6 Erin Shelton, Inc., wants to earn a target profit of $970,000 this year. The company's fixed costs are expected to be $1,340,000 and its variable costs are expected to be 50 percent of sales. Erin Shelton, Inc., earned $870,000 In profit last year. 1.36 points Required: 1. Calculate break-even sales for Erin Shelton, Inc. 2. Prepare a contribution margin income statement on the basis break-even sales. 3. Calculate the required sales to meet the target profit of $970,000. 4....