5 Al B Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2017, management estimates the following revenues and costs 4 Sales $1,800,000 430,000 360,000 Selling expenses-variable Selling expenses-fixed Administrative expenses-variable Administrative expenses fised $70,000 65,000 20,000 60,000 Direct materials Direct labor Manufacturing overhead-variabl 10 Manufacturing overhead-fied 280,000 12 lastrsctions (a) Prepare a CVP income statement for 2017 based on management estimates. (show column for total amounts only.) 14 b) 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. NOTE: Enter a number in cells requesting a value: enter either a number or a formula in cells with a ? 18 19 20 21 (a) Prepare a CVP income statement for 2017 based on management estimates. (show column for total amounts only,) 23 24 25 JORGE COMPANY CVP Income Statement (Estimated) Sales Variable expenses Cost of goods sold Selling expenses Administrative expenses 28 30 Total variable expenses Contribution margin Fixed expenses Cost of goods sold Selling expenses Administrative expenses 36 Total fixed expenses Net income P5-2A