Consider you are the revenue analyst for W Brisbane, a 312-room 5-star hotel located in the
Data Set
Consider you are the revenue analyst for W Brisbane, a 312-room 5-star hotel located in the
city centre. The Rugby Championship is an annual rugby competition between four countries:
Australia, New Zealand, South Africa, and Argentina. This year, Brisbane hotels welcomed the
news that the Wallabies (Australias national team) will be hosting their game against the
Springboks (South Africa) at Suncorp Stadium.
With the news, your revenue manager is looking to understand the impact of the event on
hotel performance. To do this, they have gathered historical data from the last time this game
DATA SET
Assessment Revenue Management Scenario Presentation
Length 5 minutes
Scenario Presentation
Your assigned task is to analyse the data, focusing on performance per day-of-week. You will
have to present the findings of your analysis in a video presentation.
Instructions:
Analyse your hotels performance for the given weeks. Questions you might consider
include, but are not limited to:
o Have the Occupancy %, ADR and RevPAR performance measures increased,
decreased, or stayed the same? What could explain these changes?
o Has the event had any impact on performance? Add a separate part to
compare performance between weekdays and weekends. What are the main
differences between these time periods? What could explain these?
o Note:
Week -1 refers to the week prior to the event, Week 0 the week of the
event, and Week +1 to the week after the event
Create at least one (1) visual aid (table, figure, graph) to assist with the data analysis.
The figure(s) created must align with your observations and interpretation of the data.
Ensure that it does not repeat information provided, but instead enhance the data
analysis.
If applicable, you must include any calculations you compute as an Appendix to the
submission.
This is a hypothetical scenario and thus, you must ignore the impact of the COVID-19
pandemic on the mar
Assessment Task
Analyse key performance indicators in a dataset and create analytical visual figure(s).
Please refer to the Instructions for details on how to complete this task.
Context
Revenue Management (RM) takesitsrootsin understanding, analysing and evaluating hotel data in order
to make tactical and strategic revenuerelated decisions, including pricing, inventory controls, channel
and distribution management, and so forth. The RM Scenario Presentation assessment will provide you
with the opportunity to have handson experience with RM data. It will help you to gain an understanding
regarding what RM is, what its main functions are and how these can be used in hotel settings. Gaining
this knowledge will assist you in becoming well versed in this interdepartmental topic and enable you to
identify its application in any hotel department. To successfully complete this assessment, you will need
to demonstrate strong research skills, as well as critical thinking and analysis.
Task Instructions
The presentation can be video recorded or presented live during tutorial, per your lecturers instructions.
If recorded, ensure the video file has sound, that you speak clearly, and that you wear corporate
Please refer to the dataset handout provided to prepare your Revenue Management Scenario
Presentation.
When analysing the dataset, focus your observations on increases, decreases, and plateaus in key
performance indicators (KPIs) and indexes. You will then need to interpret the data changes and
explaining probable causes for the changes. This means that strong market research is necessary to offer
support to your interpretations.
The recommended structure of the presentation is as follow:
Introduction
o Introduce the context (hotel/market, time, report/data set).
o Provide a brief outline to your presentation.
Analysis
o Make observations regarding the main positive and negative changes.
o Interpret and explain the observed changes.
o Create and use a graph/table/figure to showcase the critical observations.
Conclusion
o Summarise the scenario, the key issue(s) and relevant observation(s) identified.
You must prepare a short presentation (as a PowerPoint document) to support your analysis.
PowerPoint presentation will include:
o Hotel Cover Page (1 slide)
o Analysis(12 slides maximum inclusive of graphs/tables/figures)
o References (if any)
Notes:
This presentation is based on the data set provided. You will need to create your own visual
representation of the data analysis, under the form of graphs, tables, or other figures. There are no
minimum requirements to the number of visual aids you must create
