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....
Jay-Zee Company makes an in-car navigation system. Next year, Jay-Zee plans to sell 20,000 units at a price of $360 each. Product costs include: Direct materials $76.00 Direct labor $43.00 Variable overhead $11.00 Total fixed factory overhead $698,400 Variable selling expense is a commission of 5 percent of price; fixed selling and administrative expenses total $117,800. Required: 1. Calculate the sales commission per unit sold. If required, round your answers to the nearest dollar. Use rounded answers in subsequent computations....
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...
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...
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...
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
Erin Shelton, Inc., wants to earn a target profit of $920,000 this year. The company's fixed costs are expected to be $1.240,000 and its variable costs are expected to be 50 percent of sales. Erin Shelton, Inc., earned $820,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 $920,000. 4. Prepare a contribution...