(Hi, I tried by myself. But I don't know. Please teach me)

Chapter 13 - Measuring Revenue Assignment

Hotel Facts:

Kapiolani Resort & Spa - Total Rooms: 200

Room Type	Category	Number of Rooms	Rack Rate
Single	Standard	32	$185.00
Single	Moderate	32	$205.00
Single	Deluxe	32	$225.00
Single	Mountain Suite	12	$325.00
Single	Diamond Head Suite	12	$350.00
Double	Standard	24	$210.00
Double	Moderate	20	$230.00
Double	Deluxe	20	$250.00
Double	Mountain Suite	8	$350.00
Double	Ocean Suite	8	$375.00

Potential Average Rack Rate: $270.50

1. Calculate the Potential Average Single Rate

Please show your work.

Room Type	Category	Number of Rooms	Single Rack Rate	Revenue at 100% Occupancy
Single	Standard	32	$185.00	$5,920
Single	Moderate	32	$205.00	$6,560
Single	Deluxe	32	$225.00	$7,200
Single	Mountain Suite	12	$325.00	$3,900
Single	Diamond Head Suite	12	$350.00	$4,200
	TOTAL	120		$27,780

27,780 / 120 = 0.2315

1. Calculate the Potential Average Double Rate

Please show your work.

Room Type	Category	Number of Rooms	Double Rack Rate	Revenue at 100% Occupancy
Double	Standard	24	$210.00	$5,040
Double	Moderate	20	$230.00	$4,600
Double	Deluxe	20	$250.00	$5,000
Double	Mountain Suite	8	$350.00	$2,800
Double	Diamond Head Suite	8	$375.00	$3,000
	TOTAL	80		$20,440

20,440 / 80 =0.2555

1. Calculate the Multiple Occupancy Percentage

Please show your work.

At Kapiolani Resort & Spa, if 125 rooms of the 160 rooms (at 80% occcupancy) sold are occupied by more than one person, what is the multiple occupancy percentage?

125 / 160 =0.78125

1. Calculate the Rate Spread

Please show your work.

Using the answers from Question 1 and Question 2, calculate the rate spread.

1. Calculate the Potential Average Rate for a Particular Period of Time

Please show your work.

Using the answers from Question 1, Question 3 and Question 4, calculate the Potential Average Rate for this particular period of time.

1. Calculate the Room Rate Achievement Factor (AF)

Please show your work.

The Kapiolani Resort & Spa has a total rooms revenue of $32,200 with 155 rooms sold. The Potential Average Rate is $270.50. Calculate the Room Rate Achievement Factor.

( 32,200 / 155

The targeted AF was 82.5% set by your Revenue Director. Were we over or under our target? By what percent?

1. Calculate the Yield Statistic

Please show your work.

The Kapiolani Resort & Spa sold 170 rooms for a total rooms revenue of $43,500. The Potential Average Rate is $270.50. Calculate the Yield Statistic.

43,500 / 170 = 0.255

The targeted Yield Statistic set by the Revenue Director was 80%. Were we over or under our target? By what percent?

1. Calculate RevPAR (Revenue per Available Room)

Please show your work.

The Kapiolani Resort & Spa has a total of 200 rooms and sold 148 rooms for a total rooms revenue of $29,800. Calculate the RevPAR using both formula methods.

29.800 / 200

The targeted RevPAR set by the Revenue Director was $209.00. Were we over or under our target? By what amount?

1. Calculate the RevPAG (Revenue per Available Guest)

Please show your work.

For the date of November 1st, the Kapiolani Resort & Spa earned total room revenue of $39,600 and total other revenue (Food and Beverage, Spa and Retail) of $21,300. Total number of guests 352. Calculate the Revenue per Available Guest.

Describe 3 ideas that the Front Office Department can help generate guest interest in spending in the hotel's F&B, Retail and Spa businesses?

1. Calculate the GOPPAR (Gross Operating Profit per Available Room)

Please show your work

For the month of October 2021, use the following data to calculate the GOPPAR.

Departmental Revenue = $175,249

Departmental Expenses = $121,322

Number of Available Rooms = 200

The targeted GOPPAR set by the Revenue Director and General Manager was $259.00. Were we over or under our target? By what amount?