G H B C D E F Please complete the assignment in the shaded cells below. Be sure to use (and show) Excel formulas to obtain full points! Niagara Hotel Occupancy and RevPAR with Coupon Sales Rooms Available for Sale 200 200 200 200 200 Non-coupon Rooms Sold Per night 40 40 40 Coupon Rooms Sold Per night 0 10 25 50 40 40 50 100 Total Rooms Sold Per Night 40 Occupancy% 20.0% Rooms Revenue 0 Non-coupon rooms revenue $ 8,000 1 Coupon rooms revenue $ 12 Total Rooms Revenue $ 8,000 13 RevPAR 14 15 16 17 18 19 20 21 22 23 24 A. What will be the hotel's RevPAR per night if no coupons are sold? B. What will be the hotel's RevPAR per night if coupon sales result in 100 redeemed coupon rooms per night? C. In addition to changes in RevPAR, what factors would you suggest this revenue manager consider prior to agreeing to a partnership with the "Great Deals" coupon company? 25 26 27 28 29 +