As can be seen in the Table, demand is pretty high and robust in the Spring and Summer season, with demand falling in the Fall and Winter season. 1. Help Rock and Roll Cafe develop an EXCEL spreadsheet model to determine the breakeven point" for each of the seasonal periods. Use the spreadsheet template file Quiz1.xls (on Brightspace) to get started. Explain how you found the break-even point. Should the restaurant be kept open during the Fall \& Winter months? Explain. (4 points) *At the Breakeven Point, Total Revenue = Total Costs (or at Breakeven Point, Profit = zero). 2. What lease cost will justify keeping the restaurant open in each of the two seasonal periods? Again, clearly explain how you went about answering this question (i.e. what tool/ technique did you use)? What is your interpretation of the result? ( 4 points) 3. The management of Rock and Roll Cafe is considering running an advertising campaign to simulate demand at this location. As part of this exercise they are interested in evaluating how demand in increments of 100 meals in the range from 300 to 2000 meals per month will impact their bottom-line (profits) for each of the two seasonal periods. Please help the management by doing this. Clearly explain how you went about answering this question (i.e. what tool/ technique did you use)? (4 points) 4. Also plot a chart that shows how the volume of demand in each of the two seasonal periods impacts the bottom-line. Provide a title and legend for your chart and appropriately label the X and Y-axis ( 4 points) Provide your answers to these questions on the EXCEL worksheet itself. Once you are done answering and including all the relevant information, please go ahead and submit your quiz in the correct Assignment folder on Brightspace. Pleaseanswerallquestionscompletelyandconclusively. If you use GOAL SEEK to answer any questions, please paste a screen shot of your Goal Seek input window(s). The Rock and Roll Cafe operates a restaurant location in Atlantic City, NJ where they serve food in an eclectic Rock and Roll setting. Rock and Roll Cafe analyzes their operations in two seasonal periods - Spring \& Summer being the first seasonal period and Fall \& Winter being the second. The average monthly demand, with revenue and variable cost figures for both the seasonal periods is given in the Table below. Lease costs are $4000 per month in the Fall \& Winter seasonal period, with the same going up to $6000 per month in the Spring \& Summer seasonal period (since space is at a premium in the high season)
