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 Transier 35% 99% Leisure Transient 25% 95% Corporate Group 20% 90% Association Group 15% 80% Government 5% 85% 100% ADR Per Segment Annual Revenue Per Segment NOTE: BAR or Best Available Rate is the rate displayed in all transient booking channels that is not subject to any type of discount 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 F above, entering the total revenue on Row 8