School of Hotel and Tourism Management
酒店收入管理代考 For questions that require you to draw graphs, use PowerPoint to draw your graphs and paste them in your Word answer file.
Programme Title : | MSc INTERNATIONAL HOSPITALITY MANAGEMENT |
Programme Code : | 24045 |
Year and Semester : | 2022/23 Semester Two |
Subject Title : | Hospitality Revenue management |
Subject Code : | HTM539 |
Distributed Date & Time: | 9:00 am 25th April |
Submission Date & Time: | 9:00 am 28th April |
Time Allowed : | 72 hours |
This examination paper contains | 4 | pages (including this one) |
INSTRUCTIONS TO CANDIDATES 酒店收入管理代考
- This take-home examination contains 7 short-essay questions.
- You should prepare your answers in a Word file – type-written, Times New Roman, 12 point font size, margins 1” and single line spacing.
- For questions that require you to draw graphs, use PowerPoint to draw your graphs and paste them in your Word answer file.
- Your answers are to be submitted through Blackboard by 9:00 am 28thApril(Hong Kong Date and Time).
- Late submissions will not be accepted.
- You should NOT discuss the answers or questions with other people in particular your classmates.
- Please make sure to add the following disclaimer at the end of your answers and SIGNby it: “I declare that the answer is my own work”
- In case of plagiarism, you will be failed.
1.(25 marks)
Black circles below represent actual demands for time periods 1 – 7. If you have to choose either one of the two lines (dashed line and solid line) below to make a forecast for time period 8 using Least Square method, which line do you have to choose and what is the forecast for time period 8?
Instruction: show all your work to get to your answer.
2.(30 marks)
Suppose that you are given the time-series data as below and have to make a forecast for the next time period using either one of Simple Moving Average method or Naive method. Explain which of the two methods would work better for the forecasting.
Instruction: Make your answers as detailed as possible.
3.(30 marks)
The equation below is the equation of Simple Exponential Smoothing. Given the basic assumption of Simple Exponential Smoothing, explain why alpha (α) factor cannot be greater than 1 or less than 0.
Note: F refers to forecasted value and A refers to actual value.
Instruction: Use any arbitrary (α) factor greater than 1 or less than 0 and the corresponding weights to supplement your answer.
4.(30 marks)
When comparing 5-stars luxury hotels and 2-stars budget hotels, discuss why an increase in an equilibrium price is likely to generate more revenue for the former than the latter.
Instruction: Explain your answer in terms of price elasticity of demand.
5.(30 marks) 酒店收入管理代考
Suppose you are given the time series data as below. If you have to choose either one of Simple Exponential Smoothing or Decomposition method to make forecasts for Q1. 2023, which method do you have to choose and what is the forecast for Q1. 2023 provided by that method?
Instruction: Must use Excel to provide your answer. Screenshot the results that you get using Excel and past them here and use your own words to explain your answers.
Time Period | Actual Demand |
Q1. 2020 | 400 |
Q2. 2020 | 500 |
Q3. 2020 | 700 |
Q4. 2020 | 300 |
Q1. 2021 | 300 |
Q2. 2021 | 650 |
Q3. 2021 | 950 |
Q4. 2021 | 260 |
Q1. 2022 | 420 |
Q2. 2022 | 710 |
Q3. 2022 | 1200 |
Q4. 2022 | 420 |
6.(30 marks)
We can commonly observe that room prices of hotels generally increase as check-in dates are approaching. Graphically explain why room prices of hotels generally increase as check-in dates are approaching. 酒店收入管理代考
Instruction: Must use graphs to supplement your explanation.
7.(25 marks)
The two lines below represent the price elasticity of demand for group customers (solid line) and non-group customers (dashed line) for Hotel Y. Assuming that Hotel Y has only 5 rooms and accommodate only the aforementioned two types of guests, explain how the hotel can maximize its revenue and what is the maximized revenue that can be achieved.
Instruction: Must use graphs to supplement your explanation.