Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use Excel to help me answer these. whether TE IT SON w The www th The 5. Makayla Jenning is the general manager at

Please use Excel to help me answer these.
image text in transcribed
image text in transcribed
whether TE IT SON w The www th The 5. Makayla Jenning is the general manager at the Hampworth Inn Le'Veon is the property front office manager (FOM) and Latisha is the hotel's Director of Sales and Marketing (DOSM). All three serve on the hotel's RM commit tee. The hotel has 175 rooms available for sale Next month, the hotel will serve as the headquarter hotel for the Retired Firefighters Association. The Association originally blocked 90 rooms per night for Thursday, Friday, and Saturday nights at a rate of $99,00 per night. All the rooms in their block have been picked up. The current rooms availability forecast for the three days of the meeting is as follows Current Rooms Sales ADR (5) Thursday 175 Friday 175 Saturday 175 99.00 90 90 90) 129.00 55 15 Reserved Total room available for sale Firefighters rooms reserved All other room reserved Total reserved Rooms available Additional group rooms requested 125 125 SO 20 30 20 20 20 The group has requested that Latisha adel 20 rooms each night to their block at the originally contacted rate of $99.00. They state that they will use all of the additional rooms if they are made available, but if not they will more their remaining 20 attendees down the street to the Comfort Inn Latisha is in favor of increasing the block and keeping the group together. Le Veon is opposed. He is convinced that he can sell additional rooms at an ADR of $119.00 as indicated in the following spreadsheet he has prepared Le'Veon's Forecast Thursday Friday Saturday Additional rooms to be 40 50 solde $149.00 ADR Test Your Skills 329 Under his plan, he states," the hotel can maximize its ADR. Based on Le Veon's estimate of future sales to be made atrack rate, Makala knows the hotel would sell any remaining rooms not held for the firefighters at the hotel's full rack rate of $149 and thus maximize its occupancy percentage if she takes Latisha's vice. Help Makayla analyze the data she needs to answer the questions that follow by filling in the chart Under Lalisha's Plan Under Le'Veon's Plan Rooms Sold Group Revenue Tramunt Rene Total Reven Occupancy ADR R PAR a. What would the hotel's ADR he under Le'Veon's plana b. What would the hotel's RevPAR betande Le Veon's plan c. What would the hotel's ADR be under Latisha's plan? d. What would the hotel's RevPAR be under Latisha's plan e. Whose plan would you acvise Makyla to support. Explain your rationale

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Blockchain Technology In Accounting And Auditing

Authors: Prof Oleksandr Melnychenko

1st Edition

1976900328, 978-1976900327

More Books

Students also viewed these Accounting questions