Please use excels and give formulas on hiw ti get each section.

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