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 Dino Pie Limited. You must use the excel spreadsheet template provided. What you need to do: Step 1: Dino Pie Limited has one bakery location where it sells fresh made apple pies and nothing else. Pick what the selling price for that high quality apple pie is. Fill that in on your Income Statement. Step 2: Estimate how many customers per hour or day they have and estimate how many pies they sell per month. It doesnt matter if you are correct, just be reasonable. Fill that in on your spreadsheet and use these estimates to forecast monthly revenue. Step 3: Imagine their expenses and classify them into variable and fixed. List three or four of each. Come up with your own but make them reasonable. For example, you might have the following costs: Variable: Pie ingredients (crust and filling) Amount of time it takes each baker to make a pie Utilities to run the bakery Fixed: Store Managers salary per month Advertising expense per month Monthly rent on the location per month Depreciation on the equipment per month Please note that I dont expect you to include all the possible detailed costs but rather just the obvious ones and I expect your estimates to be reasonable. Add lines to your spreadsheet if necessary. Step 4: 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. Step 5: Adjust your estimates so profit looks reasonable. If your numbers show them losing a hundred thousand dollars at their location, you might want to adjust some of your assumptions. Step 6: Once those numbers look reasonable, using those numbers, calculate both the break- even sales $ and units in the cells immediately below that Income Statement. Indicate how they were calculated. Use formulas in cells wherever possible. Assignment Cost / Volume / Profit Analysis Assignment Instructions CB203 Step 7: To the right of your first CM Income Statement, you will see that you are asked to create a what if scenario (eg. Increase marketing by $1,000 per month and sell 20 more pies per month). Do not use my example. Come up with your own. Use your knowledge from your marketing and math courses. Fill this in at the top of this copy tell me what the what if scenario is. Come up with your own what if. Step 8: Copy your contribution margin income statement and the formulas over so you can quickly and easily estimate the change in profit in your what if scenario. Change the input numbers to match your what if scenario. Step 9: Based on the result, state your recommendation on whether or not you should implement the change in the space provided below that statement. Just a sentence or two in the cell right under that Income Statement is sufficient.

I want to Do this thing in excel so please send formulas too.