complete the excel sheet with the correct formulas given the information.

1 The Aqua Springs group desires to book a meeting of 600 rooms per night for four nights. 2 The month they require the rooms is July, which is the peak summer season for the hotel. 3 The meeting planner for the group is offering a $139 room rate and is requiring the hotel to pay her a 10% commission on the gross room revenue. 4 The transient rate is forecast to be $180 over this period. 5 It is estimated that the 2,400 room nights for the meeting guests will displace 2,000 forecasted transient room nights. 6 Variable costs per occupied room are $30, regardless of the segment (transient or group). 8 The banquet food cost is 25%, while restaurant food cost is 33%. 9 The labor percentage in banquets is 24%, while in the restaurant it is 30%. 10 The property's audiovisual (AV) department will generate $50,000 in revenue from the meeting. The related costs are 50%. 11 The meeting planner wants to erect a tent on the tennis courts at a cost of $50,000, to be paid by the hotel. 13 Parking revenues will be reduced by an estimated $2,000 as most attendees will fly in rather than drive. 14 There will be no change in fixed costs or any other changes in variable cost. Given the facts above, complete the analysis on the Displacement Analysis Tab