Calculate the missing values in the grey boxes


Assignment:

Paul is performing a displacement analysis for the Beach hotel. He received a group request with a total of 90 room nights at a group rate of $130.00 Paul had forecasted high occupancies over this time frame and forecasted mostly transient rooms at an ADR of $195.00. The group request includes breakfast.

 

90

Group Room Rate

$ 130.00

Total Group Room Revenue

 

Total Group Room Cost 

$1,935.00

Total NET group Room Revenue 

 

 

 

Total Displaced Transient Room nights

55

Displaced Transient Room Rate

$195.00

Displaced Transient Room Revenue

 

Total Transient Room Cost 

$1,306.25

Total Displaced Transient Rooms Revenue 

 

 

 

Net Room Revenue Differential 

 

Net Room Revenue Differential 

 

Net Food contribution differential 

$561.25

Other Revenue contribution 

$0

Total Increase/Decrease from Group 


1. Calculate and fill out the missing values in the grey boxes (use 2 decimal places for dollar values).

2. Analyzing this displacement analysis, would you recommend Paul to accept this group? In maximum 150 words explain your answer.

Solution Preview :

Prepared by a verified Expert
Other Management: Calculate the missing values in the grey boxes
Reference No:- TGS03211097

Now Priced at $25 (50% Discount)

Recommended (95%)

Rated (4.7/5)