The LAU hotel is composed of 650 rooms as follows:

The LAU hotel is composed of 650 rooms as follows: 300 single bed rooms; 300 double bed rooms and 50 suites

Average forecasted occupancy percentage per room type is as follows: 65% for single rooms; 75% for double rooms and 80% for suites with a budgeted occupancy percentage of 100% and a budgeted number of registered customers of 265900 guests.

The hotel has on a yearly basis 75 rooms from each type to be listed as OOO.

Due to marketing efforts and campaigns the sales and marketing department has budgeted 50 rooms per year as a complimentary rooms

Total number of guests forecasted to be registered is 215500 guests

Forecasted ADR for single-bed room is $150; for double-beds is $225 and for suite is $315 while the achievement factor for single bed rooms is 60%; for double beds room is 75% and for suite is 85%

Based on the previous information, complete the manager’s report and then evaluate your findings (all your analysis is on a yearly basis)
Actual. The hotel original
Budget what is the hotel planning to achieve
Variance what the hotel achieved

Calculate yearly basis
   Actual   Budget   Variance
Rooms available          
Rooms sold          
Rooms vacant          
Rooms OOO          
Rooms Comp.          
Occupancy Percentage          
Double Occ. Percentage          
Room Revenue          
Yield %