Tourism and Hospitality
Home > Tourism and Hospitality > Hospitality operations (240 hours) > Strand B Accommodation services > Additional units > Provide accommodation reception services > Provide accommodation reception services
Exercise - Calculate Occupancy Statistics
The Rivendell Manor House has a total of 560 rooms. The night auditor has prepared a report giving you the number of rooms occupied per day, the daily room revenue and the number of guests in house for May 9 to May 15 inclusive.Calculate the occupancy percentage, the average room rate per room, the average room rate per person and the density for each day and for the week. All answers must be calculated to two (2) decimal points and rounded up or down as required. Recalculate the total week. Do not use averages.
|
|
May 9 |
May 10 |
May 11 |
May 12 |
May 13 |
May 14 |
May 15 |
Week |
|
Rooms Available |
560 |
560 |
560 |
560 |
560 |
560 |
560 |
3920 |
|
Rooms Sold |
148 |
360 |
530 |
220 |
559 |
558 |
560 |
|
|
Room Revenue |
24790.00 |
60570.00 |
90630.00 |
38500.00 |
91843.70 |
93409.20 |
94080.00 |
|
|
# Guests |
185 |
414 |
689 |
271 |
1006 |
947 |
1014 |
|
|
Occ. % |
|
|
|
|
|
|
|
|
|
AVG Room Rate |
|
|
|
|
|
|
|
|
|
AVG RR per pers |
|
|
|
|
|
|
|
|
|
Density |
|
|
|
|
|
|
|
|
The Leisure Resort has 80 available rooms. Calculate these statistics
|
|
May 9 |
May 10 |
May 11 |
May 12 |
May 13 |
May 14 |
May 15 |
Week |
|
Rooms Available |
80 |
80 |
80 |
80 |
80 |
80 |
80 |
|
|
Rooms Sold |
76 |
80 |
79 |
48 |
59 |
68 |
75 |
|
|
Room Revenue |
12540.00 |
13400.00 |
13100.00 |
8560.00 |
10089.00 |
11526.00 |
12675.00 |
|
|
# Guests |
150 |
155 |
151 |
65 |
72 |
110 |
140 |
|
|
Occ. % |
|
|
|
|
|
|
|
|
|
AVG Room Rate |
|
|
|
|
|
|
|
|
|
AVG RR per pers |
|
|
|
|
|
|
|
|
|
Density |
|
|
|
|
|
|
|
|
The Corporate Hotel has 285
available rooms. Calculate these statistics
|
|
May 9 |
May 10 |
May 11 |
May 12 |
May 13 |
May 14 |
May 15 |
Week |
|
Rooms Available |
285 |
285 |
285 |
285 |
285 |
285 |
285 |
|
|
Rooms Sold |
148 |
280 |
278 |
220 |
260 |
284 |
125 |
|
|
Room Revenue |
31080.00 |
57400.00 |
58241.00 |
45540.00 |
51740.00 |
59356.00 |
26875.00 |
|
|
# Guests |
181 |
310 |
395 |
275 |
315 |
398 |
180 |
|
|
Occ. % |
|
|
|
|
|
|
|
|
|
AVG Room Rate |
|
|
|
|
|
|
|
|
|
AVG RR per pers |
|
|
|
|
|
|
|
|
|
Density |
|
|
|
|
|
|
|
|
|