The 150-room NoTel Hotel experienced an 80 percent paid occupancy and a BAR rate of $125 for 20X3. The hotel has four market segments. The percentage of room nights and the percentage of BAR rate for each segment are as follows: Percentage Percentage total rooms ADR Per Annual NOTE: BAR or Best Available Rate is the of Rooms of BAR Rate Segment Revenue Per rate displayed in all transient booking Sold Segment channels that is not subject to any type of discount Business Transient 35% 99% 42 Leisure Transient 25% 95% 30 Corporate Group 20% 90% 24 Association Group 15% 80% 18 Government 5% 85% 6 100% 120 Required: Calculate the ADR for each segment in Column E above. Enter the Total ADR on Row 8 Calculate the Annual Revenue for each segment in Column Fabove, entering the total revenue on Row 8