need help ASAP dont know how to do the spreadsheet

Assignment 6: What If Analysis - Break-Even Point Analysis We are revisiting basic spreadsheet modeling skills. Break-even point analysis is a type of what-if analyses that concentrates on the activities at the point where a product breaks even Oxford Popcorn is a small company located in Oxford, AL that produces a brand of gourmet popcorn, Lucy has developed a workbook that will allow her to perform a profit analysis for the company. Using this workbook, she wants to create formules to determine the break-even point for the company 1. Save the EXCEL data file as *A6 - Your FirstInitial. LastName" (you must keep the existing Excel file extension). 2. Define the following Excel Names in Name Box as below (To understand Excel expressions on this item, see the attached video clip) This means create an Excel name, "UnitPrice", on the cell Cts. a UnitPrice = "Profit Analysis!$C$15 To learn how to create an BRCE Name, see the attached footage For example to define the cell C15 as specified above, select the cellsenter UnitPrice is the Excel Name Box, and hit the enter key to save note: no space between "Unit" and Price a This means create an Excel name, Unit Cost, on the cell Cis. Do the b. UnitCost = 'Profit Analysis $C$16 same for Fest on the cell 17 c. FixedCost = Profit Analysis $C$17 3. Enter data as below: $13 on the cell C15 for Unit Price b. $10 on the cell C16 for Unit Cost. c. $30,000 on the cell C17 for Fixed Cost. 4. In Cell 13, enter a formula that calculates the revenue and copy and paste it to the range 14:43 Hint: Revenue = Units Sold* UnitPrice in the cell C15. For example, enter 63 * UnitPrice (in the cell C15) in the cell H3. 5. In Cell 13, enter a formula that calculates the expenses and copy and paste it to the range 14:143. a Hint Expense = Units Sold * Unit Cost . Fixed Cost For example, enter 63 * UnitCost (in the cell C16) Fixed Cost (in the cell C17) in the cell 13 6. In Cell C18, enter a formula that calculates the break-even point. Break-even point is determined by Fixed Cost divided by the difference between Unit Price and Unit Cost e Hint: BEP = Fixed Cost/(UnitPrice - UnitCost). 7. In Cell 19, enter a formula that calculates the revenue at the break-even point, which is determined by the break-even point multiplied by the unit price (hint: Revenue at the break-even point BEP Unit Price). 8. What are the BEP and the revenue at BEP? a. To check whether your formula is right, the BEP should be is 10,000 and Revenue at BEP is $130,000, where Unit Price: $13. Unit Cost: $10, and Fixed Cost: $30,000. Now your Excel screen looks like below. Cance CH edot/Untnice-Unis) Proft Analysis 200.000 $450.000 9.00 550.000 000 10.000 Un 18.000 2000 SH 14 15 Und Proce 10 Unt Cou 17 Fred Cost 18 Break Even Points Sod) 10 Revenue Break Even Port Units Sold Revere E S80 000 $5500 $35 000 1000 $13.000 $40 000 1 500 $19.500 $45.000 2000 $20.000 $50,000 2500 $32.500 $55.000 1000 $39.000 S0000 7500 $45.500 5.000 4000 $32000 5.70 000 4500 $0.500 $35.000 5000 5.000 500 000 5600 $73.500 $85.000 6000 $70,000 8600 93400 $95000 7000 301.000 $100.000 7600 $97500 S105.000 8000 $104000 $110.000 3.500 $110500 $115.000 $117 000 $120.000 9.500 $123.500 $125.000 10 000 $130 000 $130.000 105.00 $136.500 $135.000 11.000 $143.000 $140 000 11400 $149.500 $145.000 12000 5156 000 $150 000 T1000 3117000 9. Save your work and submit your completed Excel file to the Canvas folder. 10. The end