Assignment: Rev Management
Two separate files: word for questions to answers, excel for analysis
a) Which months can you identify as high season and why?
b) Which months can you identify as low season and why?
c) What is the group and transient mix during the low season months?
d) What is the highest producing segment overall?
e) Based on this performance, what do you think the strategy of this hotel was for this year?
f) Looking at the Day of week (DOW) tab, does this hotel have higher demand on weekends or weekdays?
g) Which segment or segments would you use to increase occupancy during weekdays?
h) Which segment or segments would you use to increase ADR on weekends?
Format your assignment according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- XYZ-Hotel-Year-Summary.rar