I need help on question #3 only please.

If you use GOAL SEEK to answer any questions, provide a screen shot of your Goal Seek solution window. The Blah Cafe operates a restaurant location in Fresno, CA where they serve food in an eclectic casual blah whatever setting. Blah 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 Part II of your file. 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 Blah Cafe develop an EXCEL spreadsheet model to determine the break-even point* demand quantity for each of the seasonal periods. Explain how you found the break-even point. Should the restaurant be kept open during the Fall \& Winter months? Explain. *At the Breakeven Point (demand), Total Revenue = Total Costs (or at Breakeven Point, Profit = zero) . 2. Now given current demand for each season, what fixed cost will justify keeping the restaurant open in each of the two seasonal periods? In other words, what are the break even points for each season as a function of fixed cost. 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? 3. The management of Blah 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 1000 meals below to 1000 above the current demand will impact their bottom-line (profits) for each of the two seasonal periods. Help the management by doing this. In other words, create a table for each season that shows profit levels the range of demand. Clearly explain how you went about answering this question (i.e., what tool/technique did you use)? Note: if current_demand 1000