I need help with this Comprehensive case in accounting. please explain each step in terms of calculations. the calculations should be based on my entries in the first Excel sheet. thank you in advance!

You will be creating an excel spreadsheet using the Excel template provided in Canvas. Ensure you also enter your name and student number in the appropriate boxes. Do NOT add or remove any rows or columns in the template. The Assignment You will attempt to estimate, using reasonable assumptions, what a simplified contribution margin format income statement would look like for one of the locations of Dolce Chocolates. You will complete a What If Scenario and provide analysis on this potential change in business. You must use the excel spreadsheet template provided. What you need to do: Step 1: Dolce Chocolates Limited Limited has one retail location where it sells handmade chocolates and nothing else. Pick what the selling price for that high quality confectionary is. Fill that in on your spreadsheet in cell B5. Be reasonable. Step 2: Estimate how many customers per hour or day they have and estimate how many chocolate boxes they sell per month. Each box contains a variety of 12 chocolates. It doesn't matter if you are correct, just be reasonable. Fill that in on your spreadsheet in cell B6. Imagine their Variable and Fixed Expenses. Step 3: Enter three Variable Expenses, title them in cells A8, A9, and A10. Enter they Costs per Unit in cells B8, B9 and B10 respectively. Step 4: Enter three Fixed Expenses. Title them in cells A11, A12, and A13. Enter their costs in fields B11, B12, B13 respectively. Step 5: Use this information to build a contribution margin format Income Statement in your Excel spreadsheet that is based on formulas so that you can make changes to volume or margins easily. IMPORTANT: Enter information only in the green highlighted fields. Do NOT change formulas in the blue highlighted fields. And create your own formulas where needed. Step 6: If you discover the business has incurred a Net Loss, adjust your units sold or your costs so the company is profitable. Remember to use the data entry fields to make changes to data. Your Income Statement will change if you have used formulas, as you should have. Step 7: Once those numbers look reasonable, using those numbers, calculate the break-even sales in both dollars $ and units and the Margin of Safety in dollars $ and percentage % in the Step 5: Use this information to build a contribution margin format Income Statement in your Excel spreadsheet that is based on formulas so that you can make changes to volume or margins easily. IMPORTANT: Enter information only in the green highlighted fields. Do NOT change formulas in the blue highlighted fields. And create your own formulas where needed. Step 6: If you discover the business has incurred a Net Loss, adjust your units sold or your costs so the company is profitable. Remember to use the data entry fields to make changes to data. Your Income Statement will change if you have used formulas, as you should have. Step 7: Once those numbers look reasonable, using those numbers, calculate the break-even sales in both dollars $ and units and the Margin of Safety in dollars $ and percentage % in the Assignment Cost / Volume / Profit Analysis Assignment Instructions CB203 cells immediately below that Income Statement. Indicate how they were calculated by Using formulas in cells. Step 8: To the right of your first CM Income Statement, you will see that you are asked to create a "what if" scenario (example: What if Production Increased and Fixed Costs increased? Think about the impact on Contribution Margin and profitability) Choose one of the scenarios and Fill this in in the appropriate green highlighted fields. VERY IMPORTANT: Notice you are changing the original monthly production units by a certain amount of units and monthly fixed cost by a certain amount of dollars. Step 9: Based on the result, state your recommendation on whether or not you should implement the What If Scenario change, in the space provided below the What If Scenario Income statement. Explain how the change affects your profitability, your Contribution Margin and your break-even point. Type out one paragraph using business analysis and business language