please show all the work I need the formulas to plug into excel

Instructions: Prepare a CVP income statement, compute break-even point, contribution margin ratio, margin of safety ratio, and sales for target net income. Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for $0.50 per 16-ounce bottle to retailers, who charge customers $0.75 per bottle. For the year 2016, management estimates the following revenues and costs $1,800,000 Selling expenses Variable Net sales $70,000 430,000 Selling expenses Fixed Direct materials 65,000 Direct labor 20,000 360,000 Administrative expenses Variable 60,000 Manufacturing overhead Variable 380,000 Administrative expenses Fixed 280,000 Manufacturing overhead Fixed Instructions: (a) Prepare a CVP income statement for 2016 based on management's estimates. JORGE COMPANY CVP Income Statement (Estimated) For the Year Ending December 31, 2016 Net sales Amount Variable expenses Title Amount (1) Title Amount Title Amount Formula Total variable expenses Contribution margin Formula Fixed expenses Title Amount Title Amount Title Amount Total fixed expenses Formula Net income Formula Computation of the variable portion of Cost of Goods Sold (1) Amount Amount Amount Formula