Summary Exercises Revenue Management

Exercises Revenue Management – Travel Accommodations



Holiday park:

Situation 1- Calculate Bungalow occupancy % and Bed occupancy %:

Formula = occupied bungalows / max. occupied bungalows in inventory .100 = Occ % Bungalows

Formula = occupied beds / max. occupied beds in inventory.100 = Occ % Beds

5 Bungalows with max capacity 6 people

Number of occupied Bungalows: 4

1 x 6 persons

1 x 5 persons

2 x 3 persons


Occupancy % Bungalows:

4/5 * 100 = 80%

Occupancy % Beds:

17/30 * 100 = 57%

Situation 2 - Calculate Bungalow occupancy % and Beds occupancy %:

Formula = occupied bungalows / max. occupied bungalows in inventory.100= Occ % Bungalows

Formula = occupied beds / max. occupied beds in inventory.100 = Occ % Beds

5 Bungalows with max capacity 6 people

Number of occupied Bungalows: 4

2 x 6 persons

2 x 5 persons



Occupancy % Bungalows:

4/5 * 100 = 80%

Occupancy % Beds:

22/30 * 100 = 73%




1

, Situation 3 – Calculate Yield % or Sales Efficiency for the month of December 2018

Formula = realized rooms revenue / potential maximum rooms revenue .100 = Yield %

Hotel 10 double rooms:

Max price: €90

Average room rate : €80

Average occupancy December 2018: 80% (or 248 rooms sold)

 MAXIMUM ROOMS = 248/80% = 310 IN TOTAAL



Yield % =

248**90 = ( )* 100= 71%



Situation 4 – Calculate Yield % or Sales Efficiency for the month of December 2018

Formula = realized rooms revenue / potential maximum rooms revenue = Yield %

Hotel 250 rooms: 200 double rooms and 50 single rooms

Max price double room: €80

Max price single room: €65

Average room rate : €71

Average occupancy December 2018: 60% (or 4650 rooms sold)



Yield % =

Max revenue

(200*80 + 50*65) * 31

(16 000 + 3250) * 31

596 750

Realized Revenue

4650 * 71

330 150

Yield %

(330 750) * 100 = 55%




2