DO NOT ANSWER IF YOU DO NOT KNOW IT!!! YOU ARE WASTING MY QUESTIONS POST!

DO NOT ANSWER IF YOU DO NOT KNOW IT!!! YOU ARE WASTING MY QUESTIONS POST!

NEED A NEW ANSWER!!

DO NOT COPY AND PASTE FROM OTHER WEBSITE OR CHEGG POST.

WILL GIVE THUMBS DOWN IF ANSWER IS NOT COMPLETE OR I AM NOT SATISFIED WITH ANSWER!!!!!

TOPIC: RevPATH

You have recently been hired as the new spa manager at a luxury resort. The spa at the resort has 20 treatment rooms. Your first project is to identify peak periods to see if there is a way to drive additional revenue. Simultaneously, you also want to note low periods to see if there is a way to attract more business at the spa. Previous spa management had never used RevPATH; they had only tracked the number of treatment rooms occupied and the total revenue per hour.

Using the spreadsheet in the Part 3 Spa RevPATH tab, calculate the following:

• Spa occupancy per hour.
• Average spend per guest per hour (assume that one treatment room is occupied by one guest).
• RevPATH for each hour each day of the week.

In the textbox provided at the bottom of the spreadsheet, answer the following questions:

1. Where are the hot periods and what would you implement to help drive more revenue?
2. Where are the cold periods and how can you attract more business to the spa?

Spa Exercise 1. Where are the hot periods and what would you implement to help drive more revenue? 2. Where are the cold periods and how can you attract more business to the spa