Analyse and Calculate ADR, REVPAR, profit for Laila and Marys offers (Here you need to calculate the ADR and REVPAR with the data provided and comment on the ADR and RevPAR

Assessment Task: Lingham Hotels in Melbourne CBD has 85 fully services rooms. The DOSM – Laila wants to plan for the Christmas holiday period and thus started to see if they have any offers on the way. Last year 2021 records showed that the hotel had suffered a heavy blow because of the governments lockdown restriction and customers were not ready to risk their money and life because of the lockdown scenarios. This year they are getting offers from everywhere and they are worried that they will be overbooked. During the summer season from 21st December 2022 – 4th January 2023 the hotel will serve as the host hotel for the Crickets Association. The Association originally blocked 35 rooms per night for the period at a rate of $100.00 per night. All the rooms in their block have been picked up. The group has requested that Laila add 15 rooms each night to its block at the originally contracted rate of $100.00. It states that its members will use all of the additional rooms if they are made available, but if not, they will move their remaining 15 attendees down the street to the Comfort Inn. Laila is in favor of increasing the block and keeping the group together. Mary the Sales Manager is opposed. She is convinced she can sell 30 more rooms at the normal rack rate of $110. Under her plan, she states, “The hotel can maximize its ADR.” There are two offers that currently need to be considered. You as a revenue manager is required by the RM committee requires to calculate and differentiate explain which of their costs are fixed and variable and any recommendations to change from the variable to fixed costs or would that be better to stay as variable costs according to the cost behaviour and driver and provide a report with the information provided below Forecasted Expenses from for the Christmas period break 21st December 2022 – 4th January 2023 with 80% occupancy Casual staff wages $27,000.00 Electricity charges $12,750.00 Full time staff Salary $45,000.00 Guests’ laundry charges $1,200.00 Phone and internet charges $780.00 Room Cleaning charges $3,750.00 Travel agent Commissions $2,250.00 Water charges $4,200.00 Property Maintenance charges $510.00 Sewage cleaning charges $7,350.00 Superannuation charges $7,200.00 Required: The DOSM, head of the RM committee has asked you to prepare the following and submit a report to the RM committee with the following requirements below to decide. Task 3A: Prepare a short 6 to 8 mins video presentation about your findings and recommendations to the RM committee of Purple Resorts. (20 Marks) The DOSM would like to see these following in the video Presentation for the committee. 1. Cost analysis and Break even Analysis (5 marks) 2. Comparison of Laila and Mary Proposal and normal estimated occupancy and which would be yielding more and your recommendation on which one would yield more? (5 marks) The video presentation should be a created using a PowerPoint slide with a maximum of 10 slides and minimum 6 mins duration (anything less than 6 mins would be marked zero) Once the PowerPoint slides are created, you can use Microsoft PowerPoint to Present and record your presentation. (please go to LMS online learning page to see how to create video presentations) (Tip: First finish your draft analysis in task 3c and then do your presentation) Note you must upload the video link (through Google drive) and PowerPoint slide to the Lms Submission box (both Video and the PowerPoint slides) Note: Posting only PowerPoint slides with no video presentation would be awarded no marks. The task requires to upload both using the LMS drop box link provided Task 3B: Forum Discussion (10 Marks) Task requirements: • Develop (thread) for online discussion based on the Video by uploading your video link Task3A onto LMS discussion forum • Request other students to comment on Your presentation by providing suitable discussion point/s • Students respond to other discussion forums: Students receive 1 point (maximum of 5 points) for every response they receive from other students’ on their discussion forums. A response will only receive a point if it provides the opportunity for further discussion (5 marks). Your video submission link should be posted in the discussion forum by (week11 Sunday, 5 June 2022 11:55 pm) week 12 Sunday, 12 June 2022 11:55 pm Forum discussion Report submission in the Assessment 3b submission link after taking screenshot of the colleague’s discussion. you must paste the discussion forum with replies in a word document and submit in the LMS assessment 3B drop box) Task 3C: Your report should be presented in this format: 30% – week 12 Sunday, 12 June 2022 11:55 pm Contents Page: A. Executive summary (250 – 500 words) (Note- this should be posted in task 3b discussion forum) B. Body of the Report (total 30 Marks) (body of the report should comprise the following) 1. Cost Analysis & Break even Analysis: (Here you must differentiate cost as fixed cost / variable cost and state the reason why they are fixed / variable related to their cost behaviours and recommendations to transform from variable to fixed costs or would that be better to stay as variable costs according to the cost behaviour and driver calculate your BEP using the BEP formula so you need your Fixed cost and variable cost per unit calculated for each room and find out what the Breakeven rooms per day and propose the committee what would be the BEP in units and dollars for 80% occupancy.) (750 – 1000 words) (5 Marks) 2. Analyse and Calculate ADR, REVPAR, profit for Laila and Marys offers (Here you need to calculate the ADR and REVPAR with the data provided and comment on the ADR and RevPAR (10 marks) C. Decision / Recommendation (Explain the reason which offer should the committee accept or be better not accepting any offer with reasons for your explanation with comparison of the offers for your decision (10 marks) (750 words) D. References: Overall Report presentation with no grammar, formatting errors, proper APA style referencing (please check the video on how to properly reference and format in LMS ) (5 Marks)