Question

In: Accounting

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 annual fixed costs by $148,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 $ 738,540, Variable costs 590,832, Contribution margin 147,708, Fixed costs 196,00,0 Net loss $ (48,292 ).

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.)

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.)

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.)

4. Compute the sales level required in both dollars and units to earn $180,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)

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.)

*PLEASE SHOW ALL PARTS*

Solutions

Expert Solution

1) Units sold in 2017 = 19,800 units

Contribution margin per unit = Contribution margin/Units sold

= $147,708/19,800 units = $7.46 per unit

Fixed costs in 2017 = $196,000

Break Even Point (in units) = Fixed costs/Contribution margin per unit

= $196,000/$7.46 = 26,273.46 units

Selling Price per unit = Sales/Units sold

= $738,540/19,800 units = $37.30 per unit

Break Even point (in dollars) = Break even units*Selling price per unit

= 26,273.46 units*$37.30 per unit = $980,000

2) Curent Varaible cost per unit = Selling Price per unit - Contribution margin per unit

= $37.30 - $7.46 = $29.84

New variable cost per unit = $29.84*50% = $14.92

New Fixed cost = $196,000+$148,000 = $344,000

New Contribution margin per unit = Selling Price per unit - New variable cost per unit

= $37.30 - $14.92 = $22.38

Break Even Point (in units) = Fixed costs/Contribution margin per unit

= $344,000/$22.38 = 15,370.87 units

Break Even point (in dollars) = Break even units*Selling price per unit

= 15,370.87 units*$37.30 per unit = $573,333.45

3) Forecasted contribution margin income statement for 2018 (Amount in $)

Sales (19,800 units*$37.30 per unit) 738,540
Less: Variable costs (19,800 units*$14.92 per unit) (295,416)
Contribution Margin 443,124
Less: Fixed costs (344,000)
Net Income 99,124

4) Required Contribution = Fixed costs+Required net income

= $344,000+$180,000 = $524,000

New contribution per unit = $37.30 - $14.92 = $22.38

Contribution margin ratio = ($22.38/$37.30)*100 = 60%

Required sales in $ = Required contribution/contribution margin ratio

= $524,000/60% = $873,333.33

Required sales in units = Required sales in dollars/Selling price per unit

= $873,333.33/$37.30 = 23,413.76 units

5) Forecasted contribution margin income statement for 2018 (Amount in $)

Sales (23,413.76 units*$37.30 per unit) 873,333.33
Less: Variable costs (23,413.76 units*$14.92 per unit) (349,333.33)
Contribution Margin 524,000
Less: Fixed costs (344,000)
Net Income 180,000

Related Solutions

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-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...
Required information Problem C-1A Applying activity-based costing LO P1, P2, A1, [The following information applies to...
Required information Problem C-1A Applying activity-based costing LO P1, P2, A1, [The following information applies to the questions displayed below.] Craftmore Machining produces machine tools for the construction industry. The following details about overhead costs were taken from its company records. Production Activity Indirect Labor Indirect Materials Other Overhead Grinding $ 330,000 Polishing $ 135,000 Product modification 500,000 Providing power $ 255,000 System calibration 590,000 Additional information on the drivers for its production activities follows. Grinding and Polishing 9,000 machine...
Required information Problem 17-5A Comparative ratio analysis LO A1, P3 [The following information applies to the...
Required information Problem 17-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 800,000 $ 912,200 Cash $ 18,000 $ 34,000 Cost of goods sold 596,100 650,500 Accounts receivable, net 37,400 56,400 Interest expense...
Problem 01-1A Cost computation, classification, and analysis LO C2, C3 [The following information applies to the...
Problem 01-1A Cost computation, classification, and analysis LO C2, C3 [The following information applies to the questions displayed below.] Listed here are the total costs associated with the production of 1,000 drum sets manufactured by TrueBeat. The drum sets sell for $520 each.    Costs 1. Plastic for casing—$19,000 2. Wages of assembly workers—$87,000 3. Property taxes on factory—$6,000 4. Accounting staff salaries—$39,000 5. Drum stands (1,000 stands purchased)—$31,000 6. Rent cost of equipment for sales staff—$48,000 7. Upper management...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 37,400 57,400 Interest expense 7,900...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 37,400 57,400 Interest expense 7,900...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company   Data from the current year-end balance sheets Data from the current year’s income statement   Assets Sales $ 770,000    $ 880,200      Cash $ 19,500     $ 34,000 Cost of goods sold 585,100    632,500      Accounts receivable, net...
Required information Problem 11-4A Analysis of changes in stockholders' equity accounts LO C3, P2, P3 [The...
Required information Problem 11-4A Analysis of changes in stockholders' equity accounts LO C3, P2, P3 [The following information applies to the questions displayed below.] The equity sections from Atticus Group’s 2016 and 2017 year-end balance sheets follow. Stockholders’ Equity (December 31, 2016) Common stock—$5 par value, 100,000 shares authorized, 35,000 shares issued and outstanding $ 175,000 Paid-in capital in excess of par value, common stock 135,000 Retained earnings 340,000 Total stockholders’ equity $ 650,000 Stockholders’ Equity (December 31, 2017) Common...
Required information Problem 12-4A Partnership income allocation, statement of partners' equity, and closing entries LO P2...
Required information Problem 12-4A Partnership income allocation, statement of partners' equity, and closing entries LO P2 [The following information applies to the questions displayed below.] Mo Meek, Lu Ling, and Barb Beck formed the MLB Partnership by making capital contributions of $70,200, $273,000, and $436,800, respectively. They predict annual partnership net income of $466,500 and are considering the following alternative plans of sharing income and loss: (a) equally; (b) in the ratio of their initial capital investments; or (c) salary...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT