Data Window Module 3 HW probs part 1 Formulas Data Review View Tell me ' 29 General " $ % ) Conditional Formatting Format as Table Cell Styles G H K L M N o P PROBLEM Acollege department is thinking of organizing a half day workshop for alumni featuring several prominent local business speakers. Amid-level price for tickets for this type of event would be $40, however this could be as low as $20 or as high as 75 Atypical honorarium fee for speakers of the type planned $1000, so with four speakers, the fixed cost would have a mid-level case of S4000. However, this could be as low as $1800 (three speakers at $600 per speaker) or as high as $7500 Mive speakers at $1500/peaker In addition, the campus will change a service and catering fee, which depends on the exact location and refreshments. The typical fee for such events is around $15 per person so this is the mid-level case for unit cost. However, this could be as low as $5 per person or a shigh as $35 per person The number of people attending should be around a mid-level quantity of 250. However it could be as low as 90 or as high as 500 ENTER values in the parameter ranges table in cells F3:16 corresponding to the facts above For EACH of the following situations - CALCULATE answers to the following questions by entering 1, 2 or 3 in the Case Index cells D3:D6, and then TYPE your answers in the ORANGE cells below, for each situation - TYPE answers in the ORANGE cells below, for each situation -COPY the case index numbers into the corresponding column of the scenario Input case table 1) base case: Low price, low fixed cost, medium unit cost, medium quantity Profit 2) got too greedy: High price, medium fixed cost, high unit cost, low quantity Profit? 3) lower key event: Low price, low fixed cost, medium unit cost, medium quantity Profit? 4) generating goodwill Low price, high fixed cost, low unit cost. High quantity Profit + Scenarios - HW prob 4 arios - HW prob 3.2 Scenarios - HW prob 3.3 ex cred