The attached document is the Year summary performance for K Hotel. Based on these numbers

The attached document is the Year summary performance for K Hotel. Based on these numbers, write an analysis answering the following questions:

Please submit your detailed analysis in a separate document in essay format.

  • Which months can you identify as high season and why?
  • Which months can you identify as low season and why?
  • What is the group and transient mix during the low season months?
  • What is the highest producing segment overall?
  • Based on the performance, what do you think the strategy of this hotel was for this year?
  • Looking at the Day of week (DOW) tab, does this hotel have higher demand on weekends or weekdays?
  • Which segment or segments would you target to help you increase occupancy during weekdays?
  • Which segment or segments would you target to help you increase ADR on weekends?