1. Topic 1 [Question 13]:Inventory management on the forthcoming football Grand Final night

The front office manager enthusiastically reports about the benefits of the new data analysis software integrated into the property management system (PMS). She goes on to explain that the careful review of the report of the past 5 years' data identified average no-shows of 10% for Standard rooms on that Grand Final night. Given this information and the high unconstrained demand exceeding the capacity for the standard room type, the front-office team was highly confident when engaging in the common overbooking practice for standard rooms. She also noted that this would be the second time in the hotel's history to engage in overbooking. The first time was an unintentional overbooking, while this time constitutes an intentional overbooking. To show the impact on the current bookings, she attached an extract of the current PMS (see below).

However, the team agrees to weigh up all possible outcomes in case all guests of the overbooked rooms will show. The Hilton London Metropole hotel has an arrangement with the neighbouring hotel to pay $120 per night for accepting walked guests.

Note: The cost per occupied room is $15/ room night

Current PMS Extract before the Football Grand Final

Room Type	Rack Rate	Available rooms	Nights Reserved (with overbooking)
Superior Parlour Suite	$240.00	50	6
City Skyline View Deluxe	$170.00	100	10
Standard	$155.00	200	222
Total Room Nights	350	238

To conduct a comprehensive financial analysis of the strategic effectiveness of the overbooking approach:

1. Compare the room-related revenue, ADR, occupancy rate, and RevPar for the Hilton London Metropole hotel under the two scenarios
   1. Scenario 1: With overbooking, due to border closure the reservations experience an unexpected no-show rate of 13.51% for standard rooms, equivalent to 30 rooms, and 10% for City Skyline View Delux, equivalent to 1 room. (5 marks)
   2. Scenario 2: With overbooking in place, all guests showed and the excess guests must be walked to the neighbouring hotel. (4 marks)
2. What is the percentage change in the total revenue? (1 mark)
3. Under consideration of the additional costs and benefits in each scenario, without calculations explain how the GOPPAR would be affected. (4 marks)
4. Comment on the effectiveness of the overbooking with respect to the goals of revenue maximisation and optimisation and discuss other factors which need to be considered. [ Ensure the address the financial measures relevant to support your conclusion.] (4 marks)
5. As the RM is genuinely concerned about overbooking, she asks you to explain an alternative inventory management strategy to deal with the overbooking situation as it unfolds when all guests show. (2 marks)