A B C D E F G 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 follows: Percentage Percentage of Rooms of BAR Rate Sold Business Transient 35% 99% 1 Leisure Transient 25% 95% 5 Corporate Group 20% 90% Association Group 15% 80% Government 5% 85% : 100% 0 ADR Per Segment Annual Revenue Per Segment 1 Required: 2 Calculate the ADR for each segment in Column E above. Enter the Total ADR on Row 8 3. 4 Calculate the Annual Revenue for each segment in Column F above, entering the total revenue on Row 8 5 6 7 8