The Attached report shows the performance for Hotel XYZ for 2017 and 2018. Hotel XYZ is a luxury resort with mostly leisure business.

The Attached report shows the performance for Hotel XYZ for 2017 and 2018. Hotel XYZ is a luxury resort with mostly leisure business.

After looking at this report, please answer the following questions:

• What is the mix of business for this hotel for 2017 and 2018.
• What was the Total YOY( year over year) growth? Was the growth driven by Room nights? ADR? both?
• Which segment drove this growth or decline? Transient or group?
• Which sub-segment within Transient and Group drove the growth or decline? Please explain both.
• Hotel XYZ overall strategy for next year(2019) is to grow rate without significantly increasing room nights. How can you shift your segmentation to achieve this.

Please submit the  answers to these questions  on a separate word document. Submit your calculations on the excel document.