Annual Fixed Cost F9F11C

Question: Download the template called Break-Even AnalysisDownload Break-Even Analysis to your device. The Refreshing Drink’s Name Enter the Refreshing Drink’s name in cell C4 as decided on by your group. Press "Enter" or the equivalent on your screen or keyboard to enter the change to cell C4. Be sure everyone in your group types the drink’s name exactly the same in their own workbooks to allow for the same fixed costs to generate in cells F5 and F6. You may resize column C to fit your name if you would like. Part 2: Annual Fixed Cost Use an Excel formula to calculate the annual fixed costs in cell F8. Note that your fixed costs are listed monthly, and you need to calculate annual (yearly) fixed costs. Use cell references. Check your work! Use the “✓ “ to check your answer. A “C” will indicate when you have correctly calculated the annual fixed cost by using an Excel formula with cell references. An “A” indicates that your answer needs to be checked, but your cell referencing is good. A “CR” indicates that your cell referencing needs to be checked or is not present, but your answer is correct. An “N” indicates that your answer and cell referencing are not correct and need to be checked. Part 3: Price and Percent of Demand Look at the Price/Demand Graph. Choose a price per cup, then find the corresponding percent of demand. Enter these into the appropriate cells in Part 3. Consider different variations of price per cup and percent of demand according to the chart. Use the Part 5: Yearly Cost & Revenue chart and tables to help you make your decision. Choose a price per cup that allows you to sell to as many neighbors as possible (high demand) while also making as much money as possible (high price). See W05 Prepare: Team Project for more information. Check your work! Use the “✓ “ to check your answer. Read Chart: This section will determine if you have properly read the “Price/Demand Graph” and were able to find a price per cup and % of demand that correspond. A “C” indicates that