Georgette Johnson is the revenue manager at the 700-room Doubletree hotel in Orlando. She also heads her property's Revenue Management committee. Georgette is preparing for the hotel executive committee's weekly meeting and wants to present them with an updated occupancy forecast for the first two weeks of March. Unfortunately, some of the information on the report did not print out. Help Georgette get ready for her meeting by completing her occupancy forecast report. 1. Make the specified calculations for the empty boxes. On the last line (average) you can round up or down since you cannot have a percentage of a room. o Make sure to fill out each blank. Each blank box is worth.25 points. Occupancy Forecast Occupancy Report: The Doubletree Hotel For Dates March 1-14 Date Day Rooms Reserved Blocked Total Held Available Current Occupancy % 1-Mar Tues 700 410 260 2-Mar Wed 700 375 620 3- Mar Thu 700 400 57% 4-Mar Fri 700 190 310 5-Mar Sat 700 420 500 6-Mar Sun 700 300 439 7-Mar Mon 475 225 700 8 Mar Tues 700 300 350 9-Mar Wed 700 450 65% 10- Mar Thu 700 160 410 11-Mar Fri 700 375 520 12-Mar Sat 675 410 230 13-Mar Sun 675 375 650 14-Mar Mon 650 325 50% Total 9700 4290 7200 Average 692 514 74.3% 2. Using your data calculations and what you learned from the module 6 lecture and reading, address the following points: Please provide your overall evaluation of the hotel's occupancy forecast for the first two weeks of March. o Please recall, list and define the stay (duration) control techniques