1.The Hotel owners and managers would like to know from you the major areas of concern where

there is a deviation (from Part A) that needs further monitoring and improvement.

2.Explain the importance to the owners of monitoring budgets and why do you think it will help them

to manage their finances better for the business.

3.Explain to them the use of analysing the monthly budget and comparing the forecasted budget

against the actual budgets.

4.Explain your findings and possible reasons for these variances.

5.Research and suggest what improvements do you think the owners can take to improve this

situation

The Bentley Hotel ACTUAL ROOM REVEN UE Monthly Room Type Total Actual Room Januar Revenue Varian Varianc Farourable Rooms Occupancy Rate per ceS or Available room UnFavourable type SSS -S S 231,725. 17,825. King Suite 20 65% 575.00 31 III 00 -7.14% UnFavourable SS S 103.075. 14.725. Queen Suite 10 70% 475.00 31 00 00 -12.50% UnFavourable -S S 494,062. 23,250. Deluxe Room 50 85% 375.00 31 50 00 -4.49% UnFavourable $ -$ Standard S 289,850. 17,050. Room 40 85% 275.00 31 00 00 -5.56% UnFavourable 1,118,71 2.50 -$ Total 120 72,850 -29.69% UnFavourable Monthly Room Type Total Actual Room Rooms Occupancy Rate Februa Available SS S 218,960. 6,440.0 King Suite 20 68% 575.00 28 III 0 -2.86% UnFavourable $ -S 73,150.0 33,250. Queen Suite 10 55% | $ 475.00 28 00 -31.25% UnFavourable -$ 446.250. 21,000. Deluxe Room 50 85% $ 375.00 28 00 -4.49% UnFavourable -$ Standard 215,600. 61,600. Room 40 70% | $ 275.00 28 00 00 -22.22% UnFavourable 953,960. Total 120 00 122,290 -60.82% UnFavourable Monthly Room Type Tota Actual Room Rooms Occupancy Rate March Available -SS 238,855. 10,695. King Suite 20 67% $ 575.00 31 00 00 -4.29% UnFavourable 117,800. Queen Suite 10 80% $ 475.00 31 00 $ - 0.00% Favourable 517,312. Deluxe Room 50 89% | $ 375.00 31 50 $ - 0.00% Favourable Standard 306,900. Room 40 90% $ 275.00 31 00 $ - 0.00% FavourableThe Bentley Hotel FORECAST ROOM REVENUE Annually Total Rooms Projected/Fore Projected /Forecasted Room Type Available casted Room Rate Available Occupancy days Revenue per room type King Suite 20 70% $575 365 $ 2,938,250.00 Queen Suite 10 80% $475 365 $ 1,387,000.00 Deluxe Room 50 19% $375 365 $ 6,090,937.50 Standard Room 40 90% $275 365 $ 3,613,500.00 Total $ 14,029,687.50 Monthly Room Type Total Rooms Projected/Fore casted Room Rate Januar Available Occupancy y King Suite 20 70% $575 31 $ 249,550.00 Queen Suite 10 80% $475 31 $ 117,800.00 Deluxe Room 50 89% $375 31 $ 517,312.50 Standard Room 40 90% $275 31 $ 306,900.00 Total $ 1,191,562.50 Monthly Room Type Total Rooms Projected/Fore Available casted Room Rate Februa Occupancy ry King Suite 20 70% $575 28 $ 225,400.00 Queen Suite 10 80% $475 28 $ 106,400.00 Deluxe Room 50 19% $375 28 $ 467,250.00 Standard Room 40 90% $275 28 $ 277,200.00 Total $ 1,076,250.00 Monthly Projected/Fore Room Type Total Rooms Room Rate March Available casted Occupancy King Suite 20 70% $575 31 $ 249,550.00 Queen Suite 10 80% $475 31 $ 117,800.00 Deluxe Room 50 39% $37 31 $ 517,312.50 Standard Room 40 90% $275 31 $ 306,900.00 Total $ 1,191,562.50