FOL Week 13 - Assistance with Report X FOL Assignment 2 - HOTL5002 Reven X + V X C a fanshaweonline.ca/d21/le/content/1259396/viewContent/10895441/View E Final Case Stuy - 25% 1 / 3 - 89% + 1 Final Case Study- HOTL 5002 Hotels This assignment is worth 20% of your final mark. This assignment will demonstrate your ability to critically examine a hotel's performance and make credible revenue management recommendations applying what you have learned throughout the course. As the new Revenue Manager with Lily Hotels, your task is to assist the below hotel in creating an action plan to improve performance. Analyze and summarize your hotel's performance for the STR report. Your hotel has 323 rooms. Please a professional business report of your hotel's performance for the year 2019. Note: this is not an academic paper - but a communication to your manager. Read this if you are unsure: https:/www.skillsyouneed.com/write/report-writing.htm STR REPORT - The Lily Hotel For: 2019 (the entire year). Please note - this is before COVID! ADR RevPAR 2 Occupancy % My Comp Comp Property Set Index My Property Comp Set Index My Property Set Index 60.3% 72.50% 83.2 $155.52 $141.28 110.1 $93.78 $102.43 91.6 Competitors: Hotel Name City ID Phone # Rooms 1 Lily Hotel London, Ont 12345-1234 (555) 121-1212 323 2 JW Marriott London, Ont 12345-2222 (555) 121-2222 205 3 The W Hotel London, Ont 12345-3333 (555) 121-3333 357 3 The Sheraton London, Ont 12345-4444 (555) 121-4444 385 5 The Independent London, Ont 12345-5555 (555) 121-5555 220 6 Double Tree London, Ont 12345-6666 (555) 121-6666 303 Part 1 (25 marks): Based upon STR report for 2019 above. Discuss how the hotel is performing by: Analomino usnor hotal's a 35 . C ENG 10:21 Haze IN 20-04-2022FOL Week 13 - Assistance with Report X FOL Assignment 2 - HOTL5002 Reven X + V X C a fanshaweonline.ca/d21/le/content/1259396/viewContent/10895441/View E Final Case Stuy - 25% 1 / 3 - 89% + Competitors: Hotel Name City ID Phone # Rooms Lily Hotel London, Ont 12345-1234 (555) 121-1212 323 JW Marriott London, Ont 12345-2222 (555) 121-2222 205 3 The W Hotel London, Ont 12345-3333 (555) 121-3333 357 4 The Sheraton London, Ont 12345-4444 (555) 121-4444 385 5 The Independent London, Ont 12345-5555 (555) 121-5555 220 6 Double Tree London, Ont 12345-6666 (555) 121-6666 303 Part 1 (25 marks): Based upon STR report for 2019 above. Discuss how the hotel is performing by: a) Analyzing your hotel's performance STR performance based upon the report. b) Analyzing your hotel's performance compared to the competitors c) As you were not the Revenue Manager, what other questions/information would you want to know? Discuss any information that you would like to see? Some Advice: Do not re-write the numbers or provide definitions - your Regional can read the 2 numbers/knows their definitions. Your job is to provide a summary. It is your job to "interpret" these numbers. (Continued on next page) 1 of 3 3 Final Case Study- HOTL 5002 Hotels Part 2: (15 marks) a) Based upon your analysis in Part 1 - what could be reasons for the hotel's performance.? Back up these claims from your findings in the report (i.e. don't make up information). HINT: this in 2019 - before Covid-19. Do not discuss Covid-19. Covid is 35 . C OLDA O ENG 10:21 Haze O ? U V IN 20-04-2022FOL Week 13 - Assistance with Report X FOL Assignment 2 - HOTL5002 Reven X + V X C a fanshaweonline.ca/d21/le/content/1259396/viewContent/10895441/View E Final Case Stuy - 25% 2/3 - 89% + 1 Final Case Study- HOTL 5002 Hotels Part 2: (15 marks) a) Based upon your analysis in Part 1 - what could be reasons for the hotel's performance.? Back up these claims from your findings in the report (i.e. don't make up information). HINT: this in 2019 - before Covid-19. Do not discuss Covid-19. Covid is not a factor. (5 marks) Discuss Revenue Management strategies that you could implement to improve your business moving forward based upon the data and your research. Please note: assume you cannot change any services! Be specific in your revenue management strategies. Remember to bring in Revenue Management strategies and tactics (don't provide theories or definitions - provide actual tactics with desired outcomes). (10 marks) (Modules 2-6 and the Ideas Modules can assist you). Part 3: Group Decisions - (25 marks) 2 It is time for your Revenue Management meeting with the sales department. What group(s) will you recommend the sales department to take for May 2022. Provide your recommendations and rationale in the same memo. AVAILBILTY: Date May 9 May 10 May 11 May 12 Available 323 323 323 323 rooms to sell Rooms Sold 187 209 282 199 Occupancy ADR $110.35 $128.05 $133.15 $167.52 3 RevPAR As the Revenue Manager discuss what your strategy will be based upon the below inquiries. What is your recommendation - what group (s) will you take, why, and do you have any recommendations? . Royal Bank of Canada would like to host a meeting: 25 Rooms for 2 nights: for 2 nights. Arriving June 10th Departure June 12. They have a corporate rate with your hotel at a 35 . C 10:21 Haze O O ENG IN 20-04-2022FOL Week 13 - Assistance with Report X FOL Assignment 2 - HOTL5002 Reven X + V X C fanshaweonline.ca/d21/le/content/1259396/viewContent/10895441/View E Final Case Stuy - 25% 2/ 3 - 89% + 1 ADR $110.35 $128.05 $133.15 $167.52 RevPAR As the Revenue Manager discuss what your strategy will be based upon the below inquiries. What is your recommendation - what group (s) will you take, why, and do you have any recommendations: Royal Bank of Canada would like to host a meeting: 25 Rooms for 2 nights: for 2 nights. Arriving June 10th Departure June 12. They have a corporate rate with your hotel at a rate of $125.00. However, a Trafalgar Tours group just called and would like 30 rooms arriving on June 11 for 1 night and would like their tour rate of $89 single/double occupancy Sony Corporation would like to arrive on June 11th for one night arriving June 10th for 40 rooms. No rate was provided to Sony Corp the sales manager would like your recommendation. (Continued on next page) 2 of 3 2 YLily Final Case Study- HOTL 5002 Hotels Other Instructions: This assignment is worth 20% of your final mark. Please read the Rubrics! . All submissions must be in Word and submit to the submission folder. 3 . Please see FOL for due date Rubrics: 35 . C ENG 10:21 Haze IN 20-04-2022