please conplet part b and write the formula

BUS 2012 Chapter 18 - e Romuns Page Layout Date View Review Tell me what you want to do Normal Conditional Formats Check Cel Formatting Table O S. Copy Format Painter I . D.A. Merge Center - Alignment A B C D E F G H I J 1 P18 3A Prepare a CVP income statement compute break even point contribution margin ratio, margin of safety rabo 2 and sales for larger net income Jorge Company bottles and distnbutes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers. For the year 2020, management estimates the following revenues and costs Sales Dured materials Direct labor Manufacturing overhead variable Manufacturing overhead fixed $1,800,000 430 000 360.000 380,000 280,000 Seling expenses variable Selang expenses - fixed Administrative expenses - Variable Administrative expenses - fixed $70,000 65,000 20,000 60,000 12 Instructions 13 (a) Prepare a CVP income statement for 2020 based on management estimates (show column for total amounts only) 14 (1) Compute the break-even point in (1) units and (2) dollars 15 (c) Compute the contribution margin ratio and the margin of safety ratio (Round to the nearest full percent) 16 (d) Determine the sales dollars required to earn net income of $180.000 17 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 21 (a) Prepare a CVP income statement for 2020 based on management estimates (show column for total amounts only) JORGE COMPANY CVP Income Statement (Estimated) For the Year Ending December 31, 2020 Sales $1 800 000 Variable expenses Cost of goods sold $1170 000 Seling expenses 70,000 Administrative expenses 20 000 Total variable expenses 1.200 000 Contribution margin 540.000 Foed expenses Manufacturing overhead 280.000 Selling expenses 65,000 Administrative expenses 80.000 Totalfwed expenses 405,000 Net income $135.000 PIDA E Credit 18-9 POST Normal Check Cel Conditional Format Formatting Table Merge Center - 3DAF b) Compute the break even point in (1) units and (2) dollars X1) $0.50 Brak even point in uns Unit seling price Unit variable costs Unit contribution margin Value Value Foxed costs Unit contribution margin Break-even point in units ( 2) Break-even pointindolars Break-even point in units Unit seling price Break-even point in dollars Value Value 5 c) Compute the contribution margin ratio and the margin of safety ratio (Round to the nearest full percent) Value Contribution marginato Unit contribution margin Unit selling price Contribution margin ratio Value Value Margin of safety ratio Total sales Break-even sales Margin of safety (dollars) Total sales Margin of safety ratio (%) Value Value 14 (d) Determine the sales dollars required to eam net income of $180,000 77 Sales dollars required to earn target income Fixed costs Value P18A Extra Credit E18-9 Ready