BABH9601 Strategic Revenue Management Winter, 2022 Case Study Requirements 1. Use MS Excel to determine a room mix to achieve the €38 million EBITA target from foreign guests. (30 Marks) 2. Extend your work in question 1 to develop an optimization template that addresses all the issues raised in the case. The objective is to maximize the sum of the local revenues in the four seasons that Hotels A to E in Mauritius are open to local residents. The case has two decision variables. These are the room mixes needed to market to a. foreign guests across the five seasons at the 10 hotels, and b. local guests across all but the peak season in Hotels A to E in Mauritius. The first decision variable has already been defined in question 1 above. The second decision variable pertains to the room mix to be sold to local residents during the high, shoulder, shoulder low, and low seasons at Hotels A to E in Mauritius. (20 Marks) 3. After you are done with the optimization template, discuss how you would a. make the €38 million EBITA target easier to achieve, (20 Marks) and b. raise a higher amount for financing CSR projects. (10 Marks)