Question

In: Accounting

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 increase its annual fixed costs by $142,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, 2019 Sales $ 704,640 Variable costs 563,712 Contribution margin 140,928 Fixed costs 184,000 Net loss $ (43,072 )

Problem 05-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.) Target pre income is 446000

Solutions

Expert Solution

Current

Sales per unit ( 704,640 / 19,200 )

36.70

Variable cost per unit ( 563712 / 19,200 )

29.36

Revised variable cost per unit = Current variable cost per unit * ( 1 - % reduction ) = 29.36 * ( 1 - 50% )  

14.68

ASTRO COMPANY

Forecasted Contribution margin income statement

For year ended December 31, 2018

Sales ( 36.70* 19,200 )

704,640

Variable cost ( 14.68 * 19,200 )

281,856

Contribution margin

422,784

Fixed costs ( 184,000 + 142,000 )

326,000

Net income

96,784

When machine is installed :

Contribution margin per unit = Contribution margin / Units sold = 422,784 / 19,200

22.02

Contribution margin ratio = Contribution margin per unit / Sales per unit = 22.02 / 36.70

60%

Sales level required in dollars

Choose numerator :

/

Choose denominator:

=

Sales dollars required

Fixed costs plus pretax income

/

Contribution margin ratio

=

Sales dollars required

772,000 (326,000+446000)

/

60%

=

1,286,667

Sales level required in units

Choose numerator :

/

Choose denominator:

=

Sales units required

Fixed costs plus pretax income

/

Contribution margin ratio

=

Sales units required

772,000

/

22.02

=

35,059

Required 5 :

ASTRO COMPANY

Forecasted Contribution margin income statement

For year ended December 31, 2020

$ Per unit

$

Sales

36.70

1,286,667

Variable cost [1,286,667/36.70*14.68]

14.68

514,667

Contribution margin

22.02

772,000

Fixed costs

772,000

Net income

0

I HOPE IT USEFUL TO YOU IF YOU HAVE ANY DOUBT PLZ COMMENT GIVE ME UP-THUMB. THANKS.......


Related Solutions

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...
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 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...
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 $77,400, $301,000, and $481,600, respectively. They predict annual partnership net income of $508,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...
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 Mo, Lu, and Barb formed the MLB Partnership by making investments of $67,500, $262,500, and $420,000, respectively. They predict annual partnership net income of $450,000 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 allowances of $80,000 to Mo, $60,000 to Lu, and $90,000 to Barb; interest...
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 $71,100, $276,500, and $442,400, respectively. They predict annual partnership net income of $471,000 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...
Required information Problem 23-6A Analysis of possible elimination of a department LO A1 [The following information...
Required information Problem 23-6A Analysis of possible elimination of a department LO A1 [The following information applies to the questions displayed below.] Elegant Decor Company’s management is trying to decide whether to eliminate Department 200, which has produced losses or low profits for several years. The company’s 2017 departmental income statements shows the following. ELEGANT DECOR COMPANY Departmental Income Statements For Year Ended December 31, 2017 Dept. 100 Dept. 200 Combined Sales $ 447,000 $ 281,000 $ 728,000 Cost 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT