Please help using Excel.

5. Makayla Jennings is the general manager at the Hampworth Inn. Le Veon is the property front office manager (POM) and Latisha is the hotel's Director of Sales and Marketing (OSM). All three serve on the hotel's RM comis- 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 Thunday, 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) Thunday 175 Friday 175 Saturday 175 99.00 90 90 20 149.00 Reserved Total rooms available for Firefighters room reserved All other reserved Tour Ted Rooms able Additional group To requested 55 15 145 195 155 50 40 818 20 20 20 The group has requested that Latisha add 20 room each night to their block at the originally contracted rate of $9.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 cominced that he can selladditional rooms at an ADR of $149.00 as indicated in the following spreadsheet he has prepared: Le Veon's Forecast Thursday Friday Saturday Additional rooms to be sold $149.00 ADR Test Your Sales 329 Under hispan, he states the ball can ADR" Based Vestite offre les to be made track rate. Mas the hotel would wamy maining for the fight at the hotel full tack rate of $149 and the maxima ccupancy percentagelse tales Ladice Help Me the datashe needs to answer the questions that follow by Gling in the chart Under Latisha's Plan Under Veons on Bad CR Tul O ADR