From Hospitality Industry Managerial Accounting 8th Edition (Schmidgall), Chapter 9, pg 478

Need help forecasting sales for 200-room hotel:

January 31 days, paid Occ% 80, ADR 150, Room Sales $744,000

February 29 days, paid Occ% 78, ADR $148, Room sales $669,552

March 31 days, paid Occ% 81, ADR $152, Room sales $763,344

Room sales will increase by 1% each month and ADR should increase $2 over the rate achieved in 20X4. Assume total revenue consiss of room sales and miscellaneous income.

1. Forecast the expected number of room sales for each month

2. Forecast the room sales for each month.

3. If miscellaneous income is 5% of total revenue, forecast miscellaneous income for each month.