Discussion Questions 1. Use the Excel spreadsheet attached to complete the Rooms Sold and Revenue Projections based on the above case study. (40 Marks - 12 mark deducted for each incorrect calculation) 2. Do a complete financial analysis to help determine which group, if any, the Diamond Peak Hotel should accept? You may use the second part of the Excel spreadsheet to assist you with this OR you may complete your own analysis. (40 Marks for your financial analysis AND your explanation/discussion of results) a. Your analysis should: i. Consider required non-room revenue per guest ii. Show your calculations along with your explanations. A layman should be able to follow your arguments. 3. What other variables might be taken into consideration when determining which group the hotel should accept. Explain. (5 Marks for specific points) 4. How would you deny one of the groups? What specific recommendations would you propose to the denied TOUR2031 Page 3 Revenue Management - Winter2018