Revenue Management Scenario Evaluation Essay

Exclusively available on IvyPanda Available only on IvyPanda

Introduction

Inventory allocation decisions are critical in hotel management, especially in driving marketing moves. Different performance matrices such as average daily rate (ADR), occupancy (Occ), and on-the-books (OTB) are used to determine the performance of the business. The data collected on the client segmentation, trends in bookings, seasonality, and setting rate makes it possible for the hotel managers to integrate and analyze these datasets to forecast their services’ demands1. The following observations on the Parmelia Hilton Perth data are essential to make recommendations for the Perth Royal Show expected within the city.

We will write a custom essay on your topic a custom Essay on Revenue Management Scenario Evaluation
808 writers online

Observations

Based on the hotel data and calculations done, the current occupancy rate is 53.57% compared to the same time last year when it was 51.61%. This reveals that the current bookings are higher than it was over the same period. However, the data also reveal that the hotel could actualize a 78.12% bookings rate at the end of the year. Based on the trend in the same period, it indicates that the current business operation is better than the previous year.

Analysis

The hotel has a total of 1,988 rooms, which is a constant value that the hotel operates. As of the current statistics, 1,065 rooms have been booked compared to 1,026 booked at the same time the previous year. The current bookings generated total revenue of $275,865 compared to $279,895 generated at the same time a year ago. Consequently, this resulted in the last year’s ADR of $272.8 compared to this year’s $259.03. This trend is inconsistent as a higher rate booking rate experienced in the current period should result in more revenues. This indicates that the sales in the pricing of the rooms were lower in the current period.

Recommendations

Based on the trend and analysis conducted, the hotel should consider the following recommendations:

  1. Increase marketing to reach the maximum possible number of clients possible. This is critical because the customers are increasing and showing great interest in the hotel.
  2. The hotel should increase its booking prices since the number of customers is likely to increase due to the event

Reference

Bai, Yunmei, and Chun-Hung Tang. “Determining the optimal group rate in the hotel industry.” Journal of Revenue and Pricing Management (2020): 1-11.

Appendix

Calculation Result

* Total Available Room: 284rooms * 7 days = 1,988 rooms

DOWEventCurrent OTBSame Time Last YearLast Year Actuals
RoomsADRRoomsADRRoomsADR
WednesdayPerth Royal Show142$260.00151$255.00242$265.00
ThursdayPerth Royal Show150$260.00156$290.00284$350.00
FridayPerth Royal Show190$300.00188$320.00284$369.00
SaturdayPerth Royal Show200$315.00196$340.00284$380.00
SundayPerth Royal Show – Last Day160$200.00145$210.00200$250.00
Monday123$215.00100$200.00142$210.00
Tuesday100$215.0090$210.00117$210.00
Total for the periodOcc=53.57%$259.03Occ=51.61%$272.80Occ = 78.12%$309.49

The process I calculated

  • Current OTB:
    • OCC: 1,065(room sold) / 1,988 (Total available room) = 53.57%
    • ADR: $275,865(Revenue) / 1,065 (Room sold) = $259.03
RoomsADRRevenue
142$260.00$36,920
150$260.00$39,000
190$300.00$57,000
200$315.00$63,000
160$200.00$32,000
123$215.00$26,445
100$215.00$21,500
1,065$259.03$275,865
  • Same Time Last Year:
    • OCC: 1,026 / 1,988 = 51.61%
    • ADR: $279,895(Revenue) / 1,026(Room sold) = $272.80
RoomsADRRevenue
151$255.00$38,505
156$290.00$45,240
188$320.00$60,160
196$340.00$66,640
145$210.00$30,450
100$200.00$20,000
90$210.00$18,900
1,026$272.80$279,895
  • Last Year Actuals:
    • OCC: 1,553 / 1,988 = 78.12%
    • ADR: $480,636(Revenue) / 1,553(Room sold) = $309.49
RoomsADRRevenue
242$265.00$64,130
284$350.00$99,400
284$369.00$104,796
284$380.00$107,920
200$250.00$50,000
142$210.00$29,820
117$210.00$24,570
1,553$309.49$480,636

Footnotes

  1. Bai, Yunmei, and Chun-Hung Tang. “Determining the optimal group rate in the hotel industry.” Journal of Revenue and Pricing Management (2020): 1-11.
Print
Need an custom research paper on Revenue Management Scenario Evaluation written from scratch by a professional specifically for you?
808 writers online
Cite This paper
Select a referencing style:

Reference

IvyPanda. (2022, September 29). Revenue Management Scenario Evaluation. https://ivypanda.com/essays/revenue-management-scenario-evaluation/

Work Cited

"Revenue Management Scenario Evaluation." IvyPanda, 29 Sept. 2022, ivypanda.com/essays/revenue-management-scenario-evaluation/.

References

IvyPanda. (2022) 'Revenue Management Scenario Evaluation'. 29 September.

References

IvyPanda. 2022. "Revenue Management Scenario Evaluation." September 29, 2022. https://ivypanda.com/essays/revenue-management-scenario-evaluation/.

1. IvyPanda. "Revenue Management Scenario Evaluation." September 29, 2022. https://ivypanda.com/essays/revenue-management-scenario-evaluation/.


Bibliography


IvyPanda. "Revenue Management Scenario Evaluation." September 29, 2022. https://ivypanda.com/essays/revenue-management-scenario-evaluation/.

Powered by CiteTotal, online essay citation maker
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda. Request the removal
More related papers
Cite
Print
1 / 1