Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Financial Numbers Game

Authors: Charles W Mulford, Eugene E Comiskey

1st Edition

0471770736, 9780471770732

More Books

Students also viewed these Accounting questions

Question

Always show respect for the other person or persons.

Answered: 1 week ago

Question

Self-awareness is linked to the businesss results.

Answered: 1 week ago

Question

1. Too reflect on self-management

Answered: 1 week ago