Problem 18-4B Break-even analysis; income targeting and forecasting C2 P2 A1 Rivera Co. sold 20,000 units...

Problem 18-4B Break-even analysis; income targeting and forecasting C2 P2 A1

Rivera Co. sold 20,000 units of its only product and incurred a $50,000 loss (ignoring taxes) for the current year, as shown here. During a planning session for year 2018’s activities, the production manager notes that variable costs can be reduced 50% by installing a machine that automates several operations. To obtain these savings, the company must increase its annual fixed costs by $150,000. The maximum output capacity of the company is 40,000 units per year.

RIVERA COMPANY Contribution Margin Income Statement For Year Ended December 31, 2017
Sales	$750,000
Variable costs	600,000
Contribution margin	150,000
Fixed costs	200,000
Net loss	$ (50,000)

Required

Compute the break-even point in dollar sales for year 2017.
Compute the predicted break-even point in dollar sales for year 2018 assuming the machine is installed and no change occurs in the unit selling price. (Round the change in variable costs to a whole number.)
Prepare a forecasted contribution margin income statement for 2018 that shows the expected results with the machine installed. Assume that the unit selling price and the number of units sold will not change, and no income taxes will be due.

Check (3) Net income, $100,000

Compute the sales level required in both dollars and units to earn $200,000 of target pretax income in 2018 with the machine installed and no change in unit sales price. (Round answers to whole dollars and whole units.)

(4) Required sales, $916,667 or 24,445 units (both rounded)

Prepare a forecasted contribution margin income statement that shows the results at the sales level computed in part 4. Assume no income taxes will be due.

Expert Solution

1. Break-even point in dollar sales = Fixed costs/Contribution margin ratio

Contribution margin ratio = Contribution margin/Sales = $150000/$750000 = 20%

Break-even point in dollar sales for year 2017 = $200000/20% = $1000000

2. Fixed costs for 2018 = $200000 + $150000 = $350000

Variable costs = $600000 - (50% x $600000) = $300000

Contribution margin = $750000 - $300000 = $450000

Contribution margin ratio = $450000/$750000 = 60%

Predicted break-even point in dollar sales for year 2018 = $350000/60% = $583333

3.

Forecasted Contribution Margin Income Statement
For Year Ended December 31, 2018
Sales	750000
Variable costs	300000
Contribution margin	450000
Fixed costs	350000
Net income	100000

4. Sales level required in dollars = (Fixed costs + Target income)/Contribution margin ratio = ($350000 + $200000)/60% = $550000/60% = $916667

Sales level required in units = (Fixed costs + Target income)/Contribution margin per unit = ($350000 + $200000)/($450000/20000) = $550000/$22.50 = 24444.44 = 24445

5.

Forecasted Contribution Margin Income Statement
For Year Ended December 31, 2018
Sales	916667
Variable costs	366667
Contribution margin	550000
Fixed costs	350000
Net income	200000

ekkarill92 answered 2 years ago

Problem 18-4A Break-even analysis; income targeting and forecasting LO C2, P2, A1 [The following information applies...

Problem 18-4A Break-even analysis; income targeting and forecasting LO C2, P2, A1 [The following information applies to the questions displayed below.] Astro Co. sold 19,800 units of its only product and incurred a $48,292 loss (ignoring taxes) for the current year as shown here. During a planning session for year 2018’s activities, the production manager notes that variable costs can be reduced 50% by installing a machine that automates several operations. To obtain these savings, the company must increase its...

Required information Problem 05-4A Break-even analysis; income targeting and forecasting LO C2, P2, A1 [The following...

Required information Problem 05-4A Break-even analysis; income targeting and forecasting LO C2, P2, A1 [The following information applies to the questions displayed below.] Astro Co. sold 19,200 units of its only product and incurred a $43,072 loss (ignoring taxes) for the current year, as shown here. During a planning session for year 2020’s activities, the production manager notes that variable costs can be reduced 50% by installing a machine that automates several operations. To obtain these savings, the company must...

Problem 18-7B Break-even analysis with composite units P4 Milano Co. manufactures and sells three products: product...

Problem 18-7B Break-even analysis with composite units P4 Milano Co. manufactures and sells three products: product 1, product 2, and product 3. Their unit selling prices are product 1, $40; product 2, $30; and product 3, $20. The per unit variable costs to manufacture and sell these products are product 1, $30; product 2, $15; and product 3, $8. Their sales mix is reflected in a ratio of 6:4:2. Annual fixed costs shared by all three products are $270,000. One...

Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income...

Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income Werner Company produces and sells disposable foil baking pans to retailers for $2.50 per pan. The variable cost per pan is as follows: Direct materials $0.30 Direct labor 0.57 Variable factory overhead 0.74 Variable selling expense 0.17 Fixed manufacturing cost totals $136,541 per year. Administrative cost (all fixed) totals $18,619. Required: 1. Compute the number of pans that must be sold for Werner to...

7. Break-Even Analysis: You have been asked to calculate how many units need to be sold...

7. Break-Even Analysis: You have been asked to calculate how many units need to be sold to break even, based on the costs provided in task #3. Assume that only one conference will be attended and the estimated expenses associated with this conference are on target. Use the information in task #3 except do not consider taxes.) * **3. Cost Classification: The Lee’s have provided you with the following costs and relevant information that are assumed for year 20XY. A....

Problem 10-14 NPV Break-Even Analysis (LO3) Modern Artifacts can produce keepsakes that will be sold for...

Problem 10-14 NPV Break-Even Analysis (LO3) Modern Artifacts can produce keepsakes that will be sold for $100 each. Nondepreciation fixed costs are $1,300 per year, and variable costs are $70 per unit. The initial investment of $4,000 will be depreciated straight-line over its useful life of 5 years to a final value of zero, and the discount rate is 12%. a. What is the accounting break-even level of sales if the firm pays no taxes? b. What is the NPV...

Question