Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACTUAL ROOM REVEN The Bentley Hotel UE Monthly Januar Revenue Varian per room Room Type Total Rooms Available Actual Room Occupancy Rate y Varianc

image text in transcribedimage text in transcribed

ACTUAL ROOM REVEN The Bentley Hotel UE Monthly Januar Revenue Varian per room Room Type Total Rooms Available Actual Room Occupancy Rate y Varianc Farourable ce S e or % UnFavourable type $ $ King Suite 20 65% 575.00 31 231,725. 00 17,825. $ -$ $ Queen Suite 10 70% 475.00 31 103,075. 00 14,725. S 494,062. 50 23,250. Deluxe Room 50 85% 375.00 31 $ -$ Standard $ Room 40 85% 289,850. 00 17,050. 275.00 31 00 -7.14% UnFavourable 00 -12.50% UnFavourable -$ 00 -4.49% UnFavourable 00 -5.56% UnFavourable $ 1,118,71 120 2.50 72,850 -29.69% UnFavourable Total Room Type Total Rooms Available Actual Room Monthly Februa Occupancy Rate r y -$ $ King Suite 20 68% 575.00 28 218,960. 00 6,440.0 0 -2.86% UnFavourable -$ 73,150.0 33,250. Queen Suite 10 55% $475.00 0 28 00-31.25% UnFavourable $ -$ 446,250. 21,000. Deluxe Room 50 85% $ 375.00 00 00 28 -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 Room Type Total Rooms Available Actual Occupancy Rate Room Monthly March $ 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 50 31 $- 0.00% Favourable $ Standard 306,900. Room 40 90% $275.00 00 31 0.00% Favourable FORECAST ROOM REVENUE The Bentley Hotel Annually Projected/Fore Total Rooms Available Room Type casted Room Rate Projected /Forecasted Revenue per Available Occupancy days King Suite 20 70% $575 365 room type $ 2,938,250.00 Queen Suite 10 80% $475 365 $ 1,387,000.00 Deluxe Room 50 89% $375 365 $ 6,090,937.50 Standard Room 40 90% $275 365 $ 3,613,500.00 Total $ 14,029,687.50 Monthly Projected/Fore Januar Total Rooms Room Type casted Room Rate Available Occupancy 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 Projected/Fore Total Rooms Februa Room Type casted Room Rate Available Occupancy ry King Suite 20 70% $575 28 $ 225,400.00 Queen Suite 10 80% $475 28 $ 106,400.00 Deluxe Room 50 89% $375 28 $ 467,250.00 Standard Room 40 90% $275 28 $277,200.00 Total $ 1,076,250.00 Monthly Projected/Fore March Total Rooms Room Type Available casted Occupancy Room Rate 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

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

Financial statements

Authors: Stephen Barrad

5th Edition

978-007802531, 9780324186383, 032418638X

More Books

Students also viewed these Finance questions

Question

Find dy/dx for the following functions. x sin x 1 + cos x

Answered: 1 week ago

Question

Is the sample selected related to the target population?

Answered: 1 week ago

Question

Provide signposts as organizational cues for your audience.

Answered: 1 week ago

Question

13.4 Discuss how to prepare and use presentation aids effectively.

Answered: 1 week ago