112 fx A B D E F H 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 1 follows: Percentage Percentage of Rooms of BAR Rate Sold ADR Per Segment Annual Revenue Per Segment 2 3 Business Transient 35% 99% 4 Leisure Transient 25% 95% 5 Corporate Group 20% 90% 6 Association Group 15% 80% 7 Government 5% 85% 8 100% 9 10 11 Required: 12 Calculate the ADR for each segment in Column E above. Enter the Total ADR on Row 8 13 14 Calculate the Annual Revenue for each segment in Column F above, entering the total revenue on Row 8 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NOTE: BAR or Best Available Rate is the rate displayed in all transient booking channels that is not subject to any type of discount J K