You may choose to do this Homework in Excel. But you may do it in a Word document like we did in class. You are the Revenue Manager of the 200 room Piermont Hotel. The hotel has five different room types, each with a BAR rate that reflects the product value. You know you cannot "upsell" guests who have reserved your highest rated rooms, however, you feel there is good potential to increase revenues through upsells to guests who previously reserved one of the lower rated room types. You create an incentive program that if achieved will reward each of your eight front desk clerks $100.00 a week. a) At the end of the first week, the team was successful in upselling one out of every ten guests arriving at the hotel. Calculate the change in revenue, ADR, and ReyPar.note in class in class I did not show ADR and RexPar numbers. But you should know how to do this. We only need total ADR and total RexPar before and after the upsell program. You don't need ADR and RexPar per room type) then answer the questions below: Room Type BAR Rate Room Nights Reserved 1 Superior Parlor Suite $289.99 75 Parlor Suite $239.99 100 $219.99 125 Jr. Parlor Suite Deluxe Room $149.99 250 Standard Rm $119.99 450 Total Nights 1,000 a) At the end of the first week, the team was successful in upselling one out of every ten guests arriving at the hotel. Calculate the change in revenue, ADR, and RevPar (note in class in class I did not show ADR and RexPar mumbers. But you should know how to do this. We only need total ADR and total RexPar before and after the upsell program. You don't need ADR and RexPar per room type) then answer the questions below: Room Type BAR Rate Room Nights Reserved $289.99 75 Superior Parlor Suite Parlor Suite $239.99 100 $219.99 125 Jr. Parlor Suite Deluxe Room $149.99 250 Standard Rm $119.99 450 Total Nights 1,000 1 b) What was the percentage increase in revenue growth (rounded to one decimal place) as a result of the program? C) Assume this first week represents the average week for the upsell program. What would the hotel's 52-week revenue increase be as a result of implementing the program? d) What would the "net" profit from the program be? You may choose to do this Homework in Excel. But you may do it in a Word document like we did in class. You are the Revenue Manager of the 200 room Piermont Hotel. The hotel has five different room types, each with a BAR rate that reflects the product value. You know you cannot "upsell" guests who have reserved your highest rated rooms, however, you feel there is good potential to increase revenues through upsells to guests who previously reserved one of the lower rated room types. You create an incentive program that if achieved will reward each of your eight front desk clerks $100.00 a week. a) At the end of the first week, the team was successful in upselling one out of every ten guests arriving at the hotel. Calculate the change in revenue, ADR, and ReyPar.note in class in class I did not show ADR and RexPar numbers. But you should know how to do this. We only need total ADR and total RexPar before and after the upsell program. You don't need ADR and RexPar per room type) then answer the questions below: Room Type BAR Rate Room Nights Reserved 1 Superior Parlor Suite $289.99 75 Parlor Suite $239.99 100 $219.99 125 Jr. Parlor Suite Deluxe Room $149.99 250 Standard Rm $119.99 450 Total Nights 1,000 a) At the end of the first week, the team was successful in upselling one out of every ten guests arriving at the hotel. Calculate the change in revenue, ADR, and RevPar (note in class in class I did not show ADR and RexPar mumbers. But you should know how to do this. We only need total ADR and total RexPar before and after the upsell program. You don't need ADR and RexPar per room type) then answer the questions below: Room Type BAR Rate Room Nights Reserved $289.99 75 Superior Parlor Suite Parlor Suite $239.99 100 $219.99 125 Jr. Parlor Suite Deluxe Room $149.99 250 Standard Rm $119.99 450 Total Nights 1,000 1 b) What was the percentage increase in revenue growth (rounded to one decimal place) as a result of the program? C) Assume this first week represents the average week for the upsell program. What would the hotel's 52-week revenue increase be as a result of implementing the program? d) What would the "net" profit from the program be
