MGMT 397 Hotel and Resort Management Assignment Week 1 (Due Aug 2 Sunday Midnight) Assignment 1 (1): Understanding Affiliations of Hotel Properties Download Analytical Foundations Application Exercise 1_Countries from Blackboard (Week 1 folder) When you answer the below questions, you should copy and paste the table you found from the Excel sheets (see the example in the Class note pages 26- 27). Select a country and using the property and room count data file provided, analyze some basic statistics about the hotel industry in your choice of country. Answer some of the following questions: 1. What Continent and Subcontinent is your Country in? 2. How does your Country compare to other Countries in the same Subcontinent (number of hotels/rooms)? 3. What are the major Markets (cities versus areas) in your Country? 4. What are additional Submarkets (sometimes smaller cities) in your Country? 5. How many hotels are there in your Country by Class? 6. How do the hotels in your Country compare by Scale? 7. What is the percentage of Chain versus Independent hotels in your Country (by number of rooms)? 8. What are the top Chains (and Parent Companies if you like) in your Country? Assignment 1 (2): Creating a Competitive Set Download Analytical Foundations Application Exercise 2_Comp Set from Blackboard (Week 1 folder) When you answer the below questions, you should copy and paste the table you found from the Excel sheets. Here is a suggested set of steps to help determine potential competitors. 1. There are Radial Participation Lists of 6 hotels in each tab. 2. Select one of them and see the highlighted subject hotel. First raw shows important fields, ones related to the 4 Ps. 3. The list is sorted by the Distance field. Look at the hotels and the distances and determine a best case number for the first range (e.g., hotels within 1.5 mile). Using any color, highlight just the Distance values (numbers only in the Distance column) for the hotels in the best case first range. 4. Determine the number for a second range (e.g., hotels within 3 miles) and highlight the next group with a different shade of the same color. 5. Use the Excel Sort program to sort the Participation List by the Class column. Find the subject hotel and identify other hotels that are in the same Class as the subject. Using a different color from steps 3 and 4, highlight just the Class values (Class names only in the Class column) for the hotels in the same group as the subject. 6. Identify the hotels in one Class group higher or lower than the subject, and highlight these hotels with a different shade of the same color. Then for the second range, pick another number higher or lower than the first range and highlight that with a lighter shade.