Task Summary

HFR603_Assessment_2_Brief_RM Scenario Evaluation_Due Week 7 Page 1 of 3
Task Summary
Please refer to the Assessment Brief for details on how to complete this task.
Data Set
Consider you are the revenue manager for Parmelia Hilton Perth, a newly renovated 309‐
room hotel, located in the Perth CBD. You are approaching summer, after a slightly busy
spring and are forecasting a strong season. Below is a snapshot of your hotel’s figures for the
last week of 2022, as of today (October 1
st 2022). The figures include current On‐The‐Books
(= rooms sold as of today’s date), same day‐of‐week last year (= rooms sold as of Wednesday
the same week in 2021) and actual figures (= actual rooms sold for the same week in
December 2021). You know that the hotel demand in West Perth and the Perth CBD jump
during the weekend.
Today’s date: October 1
st 2022

DOW Current OTB Same DOW Last Year Last Year Actuals
Rooms ADR RevPAR Rooms ADR RevPAR Rooms ADR RevPAR
Wednesday 140 $297.00 $146.41 137 $164.00 $79.11 177 $181.00
Thursday 137 $297.00 $143.27 130 $170.00 $77.82 175 $187.00
Friday 212 $241.00 $179.90 183 $195.00 213 $228.00 $171.00
Saturday 225 $343.00 $271.74 187 $216.00 230 $228.00 $184.65
Sunday 161 $241.00 141 $172.00 $85.39 176 $187.00 $115.89
Monday 139 $319.00 134 $163.00 $76.91 170 $185.00 $110.74
Tuesday 152 $305.00 141 $163.00 $80.93 172 $184.00 $111.44
Total for
the period
Occ = 53.91% $157.21 Occ % = $180.17 $87.71 Occ = 60.70% $199.37

 

DATA SET
Subject Code and Title HFR603 Hotel Finance and Revenue
Assessment Revenue Management Scenario Evaluation
Individual/Group Individual
Length 1,500 words (+/‐ 10%)
Submission Due by 11:55 PM AEST/AEDT/ACST/ACDT Sunday (Week 7)

HFR603_Assessment_2_Brief_RM Scenario Evaluation_Due Week 7 Page 2 of 3
Below is also a competitors’ rate report dated October 1st 2022.

DOW Parmelia
Hilton Perth
The Westin
Perth
InterContinental
Perth City Centre
Hyatt
Regency
Perth
QT Perth
WED 28 DEC 297 389 297 247 255
THU 29 DEC 297 419 297 246 247
FRI 30 DEC 241 389 360 275 309
SAT 31 DEC 343 629 427 345 495
SUN 1 JAN 241 339 324 226 279
MON 2 JAN 319 399 297 230 285
TUE 3 JAN 305 369 297 238 255

You have a revenue meeting tomorrow. You are to write your analysis, evaluation and
recommendations in a 1,500‐word report to hand out to the revenue manager before the
meeting tomorrow. Make sure you specify which day recommendations are applicable for.
Instructions:
You must calculate missing figures (Occupancy %, ADR and RevPAR) highlighted in
yellow in the table provided above, to two decimal points. Calculations that are not
accurately rounded will not receive full marks. Add the table in your report. You must
show your calculations in an appendix.
Analyse and evaluate your hotel’s performance for December 2022 using the data
provided.
o Compare Current OTB and Same DOW Last Year.
Has your hotel been selling its rooms faster or slower than last year?
Has the ADR increased, decreased, stayed the same?
Are these changes positive, negative, mixed or neutral for the hotel’s
performance? Use occupancy, ADR and RevPAR to show performance.
o Use the comparison between Same DOW Last Year and Last Year Actuals (i.e.:
the hotel’s pick‐up) to analyse how your performance this year would compare
to that of last year’s.
Use the competitors’ rate report to determine what is your current
pricing and positioning strategy; and what strategies your competitors
are using.
Explain whether the current hotel’s strategy is working or not.
HFR603_Assessment_2_Brief_RM Scenario Evaluation_Due Week 7 Page 3 of 3
Propose two (2) revenue management recommendations for your hotel.
o They must be grounded in your analysis and evaluation, and use data as
support, explaining why the hotel should implement them.
o One recommendation must be around inventory controls.
o The other recommendation must be around pricing.
o You may also choose not to implement recommendations. If this is the case,
explain why you are choosing not to make any change to the current strategy.
Remember:
Write your analysis, evaluation and recommendations in a 1,500‐word report to hand
out to the revenue manager before a revenue maximisation meeting tomorrow.
When writing your recommendations, make sure that they are specific. Broad or
generic recommendations will be dismissed by your manager as they would not be
applicable.
Inventory management relate to room inventory, not F&B inventory. They include
length‐of‐stay controls and restrictions, cancellations policies, credit card and deposit,
overbooking and many others. Be original and creative in your application of these
controls.
PLEASE ALSO NOTE THE IMPACT COVID‐19 PLAYED IN YOUR HOTEL DEMAND IN
2021.