market segmentation

The Attached report shows the performance of Hotel XYZ for 2014 and 2015. Hotel XYZ is a luxury resort with a mix of 85% Transient and 15% Group.

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

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 is to grow rate without significantly increasing room nights. Based on the performance of 2015 and 2014, how will you shift your segmentation in order to achieve this?
Please submit the answers to these questions on a separate word document. Submit calculations on the excel documen