You are the Director of Rooms for a Boutique Hotel which contains25 room in downtown Vancouver. You
Question:
You are the Director of Rooms for a Boutique Hotel which contains25 room in downtown Vancouver. You must determine out the last 7 guests who have called central reservations, which 5 guests should be accepted and explain why. From there you must calculate the total potential revenue per guest, total rooms sold, total gross revenue, marginal cost per room, non-room revenue per room and the final net revenue.
Scenario
You have a corporate group in-house that is taking up most of your rooms. They are going to be having a private dance on Friday and Saturday night and will have an open bar until 2:00 AM. There are 10 rooms that when not occupied will be out of order for maintenance work. This leaves you with 5 rooms left to sell for the remainder of the week (i.e. Monday through Saturday). There are 7 guests who have just called central reservations. Which 5 guests will you accept, and why? Using all the given information throughout this assignment select the guests that will assist you in achieving the most net revenue for the week.
Be sure to complete the following tasks to achieve full marks:
· Hotel Tape Chart
· Which guests you will accept and which guests you will decline, and explain why?
· Complete the Final Chart (Only Fill in the White Boxes)
Hotel Tape Chart /29 Marks
Using the rate offerings below, complete all blank boxes in the hotel tape chart. Rate Offerings:
• Rack Weekday Rate $145.00 (Monday to Friday)
• Rack Weekend Rate $170.00 (Saturday & Sunday)
• CAA Weekday Rate $130.50 (Monday to Friday)
• CAA Weekday Rate $153.00 (Saturday & Sunday)
• Corporate Rate $105.00
Hotel Tape Chart
Customers 1 through 20 have confirmed reservations and are in house, this means they cannot be moved. Complete the chart using Customer 21 to 25 and replace the 'Customer
21' with the customers name that will be staying based on which guests you will accept or not.
Monday Tuesday Wednesday Thursday Friday Saturday Sunday Potential Revenue Guest Reservation Status
Customer 1 OOO OOO $ 145.00 $ 145.00 $ 145.00 OOO OOO $ 435.00 CONFIRMED
Customer 2 $ 130.50 $ 130.50 OOO OOO OOO OOO OOO $ 261.00 CONFIRMED
Customer 3 $ 105.00 $ 105.00 $ 105.00 $ 105.00 $ 105.00 $ 105.00 OOO $ 630.00 CONFIRMED
Customer 4 OOO OOO $ 105.00 $ 105.00 $ 105.00 $ 105.00 $ 105.00 $ 525.00 CONFIRMED
Customer 5 OOO $ 290.00 $ 290.00 $ 290.00 $ 290.00 $ 290.00 $ 290.00 $ 1,740.00 CONFIRMED
Customer 6 OOO OOO OOO OOO OOO $ 120.00 $ 120.00 $ 240.00 CONFIRMED
Customer 7 $ 200.00 $ 200.00 OOO OOO OOO OOO OOO $ 400.00 CONFIRMED
Customer 8 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ - $ 175.00 $ 175.00 $ 950.00 CONFIRMED
Customer 9 OOO OOO OOO OOO OOO OOO $ 175.00 $ 175.00 CONFIRMED
Customer 10 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 11 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 12 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 13 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 14 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 15 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 16 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 17 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 18 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 19 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 20 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 175.00 $ 175.00 $ 175.00 $ 1,125.00 CONFIRMED
Customer 21 $ -
Customer 22 $ -
Customer 23 $ -
Customer 24 $ -
Customer 25 $ -
Which guests you will accept and which guests you will decline, and explain why?
1. Suzanne calls and would like to arrive Monday and depart Saturday morning on the Rack Rate.
2. Hunter calls who is looking for a room for himself and his 2 children. They would like to arrive Friday and depart Monday on the Rack Rate and are aware of the rate change.
3. John would like to arrive Wednesday and depart on Monday on the Rack Rate. John is aware of the rate change.
4. David calls and is looking for a room from Monday to Wednesday on the Rack Rate.