PLEASE HELP ME! I am trying to get my grade up by the end of today ?? *PLEASE INCLUDE THE FORMULA ON HOW YOU GOT THE ANSWERS ON EXCEL, And as WELL AS THE ANSWERS. Thank you so much.

ACC 255 Graded Assignment #8 Instructions: The owner of Pax Company is requesting a break-even analysis, Use the information from the 2017 Income statement in the Excel file to: In the "2017 IS" sheet, create formulas to calculate Contribution margin per unit, Contribution margin ratio, Break-even point in units, Break-even point in sales dollars o Formulas should use cell references to data provided - Profit analysis-Mr. Pax would like to increase profit to $150,000 for 2018. He asks you to propose 5 independent scenarios that would increase profit. o Create a Cost-Volume-Profit analysis on a new sheet and rename "CVP Analysis o Create formulas to calculate Contribution margin per unit, Contribution margin ratio Break-even point in units and Projected net income for each of the 5 scenarios o Track the results for each of the 5 scenarios in the CVP Analysis worksheet o Include a section in the worksheet that describes the change that occurred in each o o Worksheet should be visually organized and print to one sheet Create a chart that compares the Break-even point in units for the 5 scenarios Move chart to a new sheet tab and rename "Break-even Comparison" Layout chart appropriately ' o Create a chart that compares the Projected net income for the 5 scenarios Move chart to a new sheet tab and rename "Net Income Comparison" - 'Layout chart appropriately o Based on the results, chose the best scenario to propose to Mr. Pax -In a new worksheet, prepare an Income statement in contribution margin format based on the best scenario's numbers-rename the new sheet Proposed 2018 IS" and give a brief explanation why this is the best scenario Add your name to the bottom right-hand footer of each sheet in the workbook (including charts) Name your completed Excel file using your first initial and last name. (Example: ACC 255 Graded Assi Submit your completed Excel file to the Assignment in Laulima by the due date indicated in the assignment. t #8 L. Ake Grading Rubric Maximum Points Create formulas in Excel to accurately calculate break-even amounts Create formulas in Excel to accurately calculate CVP amounts Create 5 independent scenarios and calculate CVP amounts for each Proposed 2013 IS explains why the scenario was chosen Use cell references in all formulas Chart layout is appropriate for both charts Charts are moved to a new sheet and renamed Create a contribution margin income statement in Each sheet is visually organized, prints to one page and contains name in footer Add your name to file name Total points 50