Required information (Assessment Problem) 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 20,600 units of its only product and incurred a $55,028 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 $156,000. The maximum output capacity of the company is 40,000 units per year. ASTRO COMPANY Contribution Margin Income Statement For Year Ended December 31, 2017 Sales $784,860 Variable costs 627,888 Contribution margin 156,972 Fixed costs 212,000 Net loss $(55,028) Problem 18-4A Part 1 Required: 1. Compute the break-even point in dollar sales for year 2017. (Round your answers to 2 decimal places.) Contribution Margin Per Unit Current Contribution Margin Ratio Choose Numerator: Choose Denominator: Contribution Margin Ratio Contribution margin ratio Break-Even Point in Dollar Sales: Choose Numerator: Choose Denominator: Break-Even Point in Dollars Break-even point in dollars = Required information (Assessment Problem) 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 20,600 units of its only product and incurred a $55,028 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 $156,000. The maximum output capacity of the company is 40,000 units per year. ASTRO COMPANY Contribution Margin Income Statement For Year Ended December 31, 2017 Sales $784,860 Variable costs 627,888 Contribution margin 156,972 Fixed costs 212,000 Net loss $(55,028) Problem 18-4A Part 2 2. Compute the predicted break-even point in dollar sales for year 2018 assuming the machine is installed and there is no change in the unit selling price. (Round your answers to 2 decimal places.) Contribution margin Proposed per unit Contribution Margin Ratio Choose Numerator: Choose Denominator: = Contribution Margin Ratio Contribution margin ratio point in dollar sales with new machine Choose Choose Numerator: Denominator: Break-Even Point in Dollars Break-even point in dollars Required information (Assessment Problem) 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 20,600 units of its only product and incurred a $55,028 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 $156,000. The maximum output capacity of the company is 40,000 units per year. ASTRO COMPANY Contribution Margin Income Statement For Year Ended December 31, 2017 Sales $784,860 Variable costs 627,888 Contribution margin 156,972 Fixed costs 212,000 Net loss $(55,028) Problem 18-4A Part 3 3. 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. (Do not round intermediate calculations. Round your answers to the nearest whole dollar.) ASTRO COMPANY Forecasted Contribution Margin Income Statement For Year Ended December 31, 2018 Contribution margin Required information (Assessment Problem) 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 20,600 units of its only product and incurred a $55,028 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 $156,000. The maximum output capacity of the company is 40,000 units per year. ASTRO COMPANY Contribution Margin Income Statement For Year Ended December 31, 2017 Sales $784,860 Variable costs 627,888 Contribution margin 156,972 Fixed costs 212,000 Net loss $(55,028) Problem 18-4A Part 4 4. Compute the sales level required in both dollars and units to earn $260,000 of target pretax income in 2018 with the machine installed and no change in unit sales price. (Do not round intermediate calculations. Round your answers to 2 decimal places. Round "Contribution margin ratio" to nearest whole percentage) Sales level required in dollars Choose Numerator: Choose Denominator: Sales dollars required Sales dollars required Sales level required in units Choose Numerator: Choose Denominator: Sales units required Sales units required / Required information (Assessment Problem) 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 20,600 units of its only product and incurred a $55,028 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 $156,000. The maximum output capacity of the company is 40,000 units per year. ASTRO COMPANY Contribution Margin Income Statement For Year Ended December 31, 2017 Sales $784,860 Variable costs 627,888 Contribution margin 156,972 Fixed costs 212,000 Net loss $(55,028) Problem 18-4A Part 5 5. 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. (Do not round intermediate calculations. Round "per unit answers" to 2 decimal places.) ASTRO COMPANY Forecasted Contribution Margin Income Statement For Year Ended December 31, 2018 $ Per Unit $ 38.10 Contribution margin