Hello, Can someone assist me with the solutions needed for the attached MSExcel worksheet. As can be seen, the CV Income Statement needs completed, along with the noting the formulas and breakeven point. My sincere thanks

by Weygandt, Kieso, and Kimmel by Rex A Schildhouse Problem P5-2A Jorge Company bottles and distributes B-Lite, a diet soft drink. The beverage is sold for per 16-ounce bottle to retailers, who charge customers per bottle. For the $0.50 $0.75 year 2014, management estimates the following revenues and costs: Net sales $1,800,000 Selling expenses - Variable Direct materials 430,000 Selling expenses - Fixed Direct labor 360,000 Administrative expenses - Variable Manufacturing overhead - Variable 380,000 Administrative expenses - Fixed Manufacturing overhead - Fixed 280,000 Instructions: (a) Prepare a CVP income statement for 2014 based on management's estimates. JORGE COMPANY CVP Income Statement (Estimated) For the Year Ending December 31, 2014 Net sales Amount Variable expenses Title Amount (1) Title Amount Title Amount Total variable expenses Formula Contribution margin Formula Fixed expenses Title Amount Title Amount Title Amount Total fixed expenses Formula Net income Formula (1) Computation of cost of goods sold Title Title Title Title Amount Amount Amount Formula (b) Compute the break-even point in (1) units and (2) dollars. (1) Net sales Total variable expenses Contributions Variable costs as percentage of sales Variable costs per bottle Contributions per bottle Total fixed costs Break-even in units Amount Amount Formula Formula Formula Formula Amount Formula (2) Break-even in units Title Title Quantity Amount Formula (c) Compute the contribution margin ratio and the margin of safety ratio. Contribution margin ratio = Amount Amount = Formula Margin of safety ratio Amount Amount = Formula (d) Determine the sales dollars required to earn a net income of Required sales = Amount Percentage $180,000 = Formula erage is sold for per bottle. For the $70,000 65,000 20,000 60,000 rounded rounded Formula by Weygandt, Kieso, and Kimmel by Rex A Schildhouse Problem P6-8A Dilithium Batteries is a division of Enterprise Corporation. The division manufactures and sel battery used in a wide variety of applications. During the coming year it expects to sell per unit. Nyota Uthura is the division manager. She is considering producing either units during the period. Other information is presented in the schedule. Division Information for 2014 Beginning inventory Expected sales in units Selling price per unit Variable manufacturing costs per unit Fixed manufacturing overhead costs (total) Fixed manufacturing overhead costs per unit: Based on 60,000 units ($540,000 60,000 units) Based on 90,000 units ($540,000 90,000 units) Manufacturing cost per unit: Based on 60,000 units ($12.00 variable + $9.00 fixed) Based on 90,000 units ($12.00 variable + $6.00 fixed) Variable selling and administrative expenses Fixed selling and administrative expenses (total) Instructions: (a) Prepare an absorption costing income statement, with one column showing the results if one column showing the results if units are produced. 90,000 Sales Cost of goods sold Title Title Title Net income DILITHIUM BATTERIES DIVISION Income Statement For the Year Ended December 31, 2014 Absorption Costing 60,000 Produced Formula Formula Formula Formula Amount Formula (b) Prepare a variable costing income statement, with one column showing the results if one column showing the results if units are produced. 90,000 Sales Title Title Title DILITHIUM BATTERIES DIVISION Income Statement For the Year Ended December 31, 2014 Variable Costing 60,000 Produced Formula Formula Formula Title Title Title Net income Formula Formula Amount Amount Formula (c) Reconcile the difference in net incomes under the two approaches and explain what accounts for this differe Enter text answer here. Net income under absorption costing Less Title (d) Discuss the relative usefulness of the variable costing income statements versus the absorption costing inco decision making and for evaluating the manager's performance. Enter text answer here. ion manufactures and sells a long-life 60,000 $30.00 units for 60,000 90,000 or 0 60,000 $30.00 $12.00 $540,000 $9.00 $6.00 $21.00 $18.00 $2.00 $50,000 60,000 units are produced and VISION 1, 2014 90,000 Produced Formula Formula Formula Formula Amount Formula 60,000 units are produced and VISION 1, 2014 90,000 Produced Formula Formula Formula Formula Formula Amount Amount Formula at accounts for this difference. Amount Amount Formula e absorption costing income statements for