Question

In: Finance

Cornerstone Exercise 16.4 (Algorithmic) After-Tax Profit Targets Olivian Company wants to earn $420,000 in net (after-tax)...

Cornerstone Exercise 16.4 (Algorithmic)
After-Tax Profit Targets

Olivian Company wants to earn $420,000 in net (after-tax) income next year. Its product is priced at $250 per unit. Product costs include:

Direct materials $75.00
Direct labor $55.00
Variable overhead $12.50
Total fixed factory overhead $425,000

Variable selling expense is $10 per unit; fixed selling and administrative expense totals $275,000. Olivian has a tax rate of 40 percent.

Required:

1. Calculate the before-tax profit needed to achieve an after-tax target of $420,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

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

$  

  

$  

  

$  

  

$  

4. What if Olivian had a 35 percent tax rate? Would the units sold to reach a $420,000 target net income be higher or lower than the units calculated in Requirement 2?
- Select your answer -HigherLowerCorrect 1 of Item 3

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

Solutions

Expert Solution

Total variable costs per unit = $ 75 + $ 55 + $ 12.50 + $ 10 = $ 152.50

Contribution margin per unit = $ 250 - $ 152.50 = $ 97.50

Total Fixed Costs = $ 425,000 + $ 275,000 = $ 700,000.

1.  The before-tax profit needed to achieve an after-tax target of $420,000 = $ 420,000 / ( 1 - 0.40 ) =  $ 700,000
2. The number of units that will yield operating income calculated in Requirement 1= $ ( 700,000 + 700,000 ) / $ 97.50 = 14,359 units.

3.

Olivian Company
Income Statement
For the Coming Year
Sales ( 14,359 x $ 250) $ 3,589,750
Less: Variable Costs ( 14,359 x $ 152.50) 2,189,750
Contribution Margin $ 1,400,000
Less: Fixed Expenses 700,000
Income before Taxes 700,000
Tax @ 40 % 280,000
Net Income 420,000

4. Lower

Before tax income = $ 420,000 / ( 1 - 0.35 ) = 646,154

Number of unit sales required to earned $ 646,154 = $ ( 700,000 + 646,154 ) / $ 97.50 = 13,807 units.


Related Solutions

Cornerstone Exercise 16.4 (Algorithmic) After-Tax Profit Targets Olivian Company wants to earn $600,000 in net (after-tax)...
Cornerstone Exercise 16.4 (Algorithmic) After-Tax Profit Targets Olivian Company wants to earn $600,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 $405,000 Variable selling expense is $16 per unit; fixed selling and administrative expense totals $255,000. Olivian has a tax rate of 40 percent Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of $600,000....
Cornerstone Exercise 16.4 (Algorithmic) After-Tax Profit Targets Olivian Company wants to earn $300,000 in net (after-tax)...
Cornerstone Exercise 16.4 (Algorithmic) After-Tax Profit Targets Olivian Company wants to earn $300,000 in net (after-tax) income next year. Its product is priced at $300 per unit. Product costs include: Direct materials $90.00 Direct labor $66.00 Variable overhead $15.00 Total fixed factory overhead $420,000 Variable selling expense is $12 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 $300,000....
After-Tax Profit Targets Olivian Company wants to earn $420,000 in net (after-tax) income next year. Its...
After-Tax Profit Targets Olivian Company wants to earn $420,000 in net (after-tax) income next year. Its product is priced at $275 per unit. Product costs include: Direct materials $90 Direct labor $65 Variable overhead $16 Total fixed factory overhead $440,000 Variable selling expense is $14 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 $420,000. 2. Calculate the number...
After-Tax Profit Targets Olivian Company wants to earn $300,000 in net (after-tax) income next year. Its...
After-Tax Profit Targets Olivian Company wants to earn $300,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 $450,000 Variable selling expense is $16 per unit; fixed selling and administrative expense totals $300,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of $300,000. $ 2. Calculate the...
After-Tax Profit Targets Olivian Company wants to earn $300,000 in net (after-tax) income next year. Its...
After-Tax Profit Targets Olivian Company wants to earn $300,000 in net (after-tax) income next year. Its product is priced at $250 per unit. Product costs include: Direct materials $75.00 Direct labor $55.00 Variable overhead $12.50 Total fixed factory overhead $445,000 Variable selling expense is $10 per unit; fixed selling and administrative expense totals $295,000. Olivian has a tax rate of 40 percent. Required: 1. Calculate the before-tax profit needed to achieve an after-tax target of $300,000. $ 2. Calculate the...
After-Tax Profit Targets Olivian Company wants to earn $360,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: Direct materials $105.00 Direct labor $77.00 Variable overhead $17.50 Total fixed factory overhead $410,000 Variable selling expense is $14 per unit; fixed selling and administrative expense totals $260,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. $ 2. Calculate the...
Cornerstone Exercise 6.10 (Algorithmic) Cost Information and the Weighted Average Method Morrison Company had the equivalent...
Cornerstone Exercise 6.10 (Algorithmic) Cost Information and the Weighted Average Method Morrison Company had the equivalent units schedule and cost information for its Sewing Department for the month of December, as shown below. Direct Materials Conversion Costs Units completed 43,000 43,000 Add: Units in ending work in process ×      Percentage complete:         15,000 × 100% direct materials 15,000 —         15,000 × 45% conversion materials — 6,750 Eqivalent units of output 58,000 49,750 Costs:         Work in process, December...
Cornerstone Exercise 6.10 (Algorithmic) Cost Information and the Weighted Average Method Morrison Company had the equivalent...
Cornerstone Exercise 6.10 (Algorithmic) Cost Information and the Weighted Average Method Morrison Company had the equivalent units schedule and cost information for its Sewing Department for the month of December, as shown below. Direct Materials Conversion Costs Units completed 41,000 41,000 Add: Units in ending work in process × Percentage complete: 14,000 × 100% direct materials 14,000 — 14,000 × 45% conversion materials — 6,300 Eqivalent units of output 55,000 47,300 Costs: Work in process, December 1: Direct materials $68,000...
eBook Cornerstone Exercise 6.10 (Algorithmic) Cost Information and the Weighted Average Method Morrison Company had the...
eBook Cornerstone Exercise 6.10 (Algorithmic) Cost Information and the Weighted Average Method Morrison Company had the equivalent units schedule and cost information for its Sewing Department for the month of December, as shown below. Direct Materials Conversion Costs Units completed 46,000 46,000 Add: Units in ending work in process × Percentage complete: 20,000 × 100% direct materials 20,000 — 20,000 × 45% conversion materials — 9,000 Eqivalent units of output 66,000 55,000 Costs: Work in process, December 1: Direct materials...
Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and...
Cornerstone Exercise 8.11 (Algorithmic) Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,670,000 Quarter 2 5,230,000 Quarter 3 2,850,000 Quarter 4 7,970,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT