A B D J NOTE: BAR or Best Available Rate is the rate displayed in all transient booking channels that is not subject to any type of discount 35% D E F F G H The 150-room No Tel 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 ADR Per Annual of Rooms of BAR Rate Segment Revenue Sold Per 2 2 Segment 3 Business Transient 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 Fabove, entering the total revenue on Row 8 15 16 17 18 19 20 21 22 23 24 25 26 27 28 an