90.2K

Verified Solution

Link Copied!

1. ADR for January

2.ADR for February

3.Revpar for January

4.Revparfor February

5.January percentage of occupancy

6.February percentage of occupancy

7. Total room revenue for the Two months

The rate Categories 20 100 Room ski resort Rack BAR 1 2 3 4 5 6 100 2 100 Lake Tahoe Package OTA 60 60 20 20 20 20 20 20 BBBB B 60 Numer of rooms forecasted to be sold in rach rate category 50 50 20 20 9 10 11 12 13 14 15 20 20 20 20 20 60 100 1001 Day Date Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Total rooms sold 60 60 16 20 20 20 20 20 60 20 20 1001 100 60 60 12 18 19 20 21 22 23 24 25 26 22 29 29 30 31 20 20 20 20 20 20 20 60 100 100 60 60 60 900 20 20 20 800 160 Total rooms forescated to be sold 460 2320 Forecasted total rooms D Rate times the number of rooms Rack $ 250.00 $ 200,000.00 BAR $ 175.00 $ 157,500.00 Packages $ 125.00 $ 20,000.00 Ota $ 99.00 $ 45,540.00 $ 423,040.00 Yield max 100 at $250 3100 $ 775,000.00 f every room was sold every night at the rack rate The rate Categories 20 100 Room ski resort Rack BAR 1 2 3 4 5 6 100 2 100 Lake Tahoe Package OTA 60 60 20 20 20 20 20 20 BBBB B 60 Numer of rooms forecasted to be sold in rach rate category 50 50 20 20 9 10 11 12 13 14 15 20 20 20 20 20 60 100 1001 Day Date Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Total rooms sold 60 60 16 20 20 20 20 20 60 20 20 1001 100 60 60 12 18 19 20 21 22 23 24 25 26 22 29 29 30 31 20 20 20 20 20 20 20 60 100 100 60 60 60 900 20 20 20 800 160 Total rooms forescated to be sold 460 2320 Forecasted total rooms D Rate times the number of rooms Rack $ 250.00 $ 200,000.00 BAR $ 175.00 $ 157,500.00 Packages $ 125.00 $ 20,000.00 Ota $ 99.00 $ 45,540.00 $ 423,040.00 Yield max 100 at $250 3100 $ 775,000.00 f every room was sold every night at the rack rate

Answer & Explanation Solved by verified expert

See Answer