show work, round dollars to 2 decimals and percents to 1 decimal.
4. Sherri Lamar is the manager in charge of room sales at the 200-room Bradford in. The inhas five different room types. each with a rack rate that reflects its guests' view of each room type's value. Sherri knows that she cannot upseil guests who stay in her highest-rated rooms, however, she feels that there is good potential to impact her hotel's revenue performance via upsells to guests whe originally reserved one of the four lower-priced room types but would actually prefer a higher-priced room To improve revenue, Sherri created and implemented a comprehensive upe training program for her hotel's front desk staff. The program helped the desk staff stress the benefits to arriving guests of each higher priced room type. At the end of the first week of the program's implementation, Sherri found that her clerks were successful in upselling approximately 1 of every 10 guests arriving at the hotel. A summary of the inn's guest reservation/actual stay records is displayed here. Using the revenue summary for Sherri and her first week's data, provide the answers she needs for the questions that follow. (3 points each) Bradford Inn Upsell Results: Week 1 Room Type Rack Rate (5) Reserved Revenue 151 Nights Reserved Actual Night Usage Actual Revenue 15) 75 75 299.99 110 Superior Parlor Suite Parlor Suite Jr. Parlor Suite Deluxe Standard Total Nights Total Rooms Revenue ADR 249.99 219.99 159.99 109.99 100 125 250 450 1.000 140 275 400 1,000 (1) (a) What is the reserved revenue from deluxe rooms before upselling? What is the actual revenue from deluxe rooms after upselling? (2) What would be the Inn's room revenue if all arriving guests had been assigned to their originally reserved rooms? (3) What was the total room revenue actually achieved by the Inn as the result of the upsell program? Name: (4) What would be the Inn's ADR if all arriving guests had been assigned to their originally reserved rooms? (5) What was the ADR actually achieved by the Inn as the result of the upsell program? (6) What was the amount of the increased room revenue that resulted from Sherri's upsell program? (7) What was the percent increase (rounded to one decimal place) in room revenue achieved by the Inn as a result of the program? (8) Assume that this first week represents the typical week for the upsell program. What would be the hotel's 52-week room revenue increase resulting from the upsell program's implementation? 4. Sherri Lamar is the manager in charge of room sales at the 200-room Bradford Inn. The Inn has five different room types, each with a rack rate that reflects its guests' view of each room type's value. Sherri knows that she cannot upsell guests who stay in her highest-rated rooms, however, she feels that there is good potential to impact her hotel's revenue performance via upsells to guests who originally reserved one of the four lower priced room types but would actually prefer a higher-priced room. To improve revenue, Sherri created and implemented a comprehensive upsell training program for her hotel's front desk staff. The program helped the desk staff stress the benefits to arriving guests of each higher-priced room type. At the end of the first week of the program's implementation, Sherri found that her clerks were successful in upselling approximately 1 of every 10 guests arriving at the hotel. A summary of the inn's guest reservation/actual stay records is displayed here. Using the revenue summary for Sherri and her first week's data, provide the answers she needs for the questions that follow. (3 points each) Bradford Inn Upsell Results: Week 1 Actual Night Usage Actual Revenue (5) Room Type Reserved Revenue ($) Rack Rate ($) Nights Reserved 75 299.99 75 100 249.99 219.99 110 140 125 250 Superior Parlor Suite Parlor Suite Jr. Parlor Suite Deluxe Standard Total Nights Total Rooms Revenue ADR 159.99 109.99 275 400 1,000 450 1,000 (1) (a) What is the reserved revenue from deluxe rooms before upselling? (b) What is the actual revenue from deluxe rooms after upselling? (2) What would be the Inn's room revenue if ali arriving guests had been assigned to their originally reserved rooms? (3) What was the total room revenue actually achieved by the Inn as the result of the upsell program? Name: (4) What would be the Inn's ADR if all arriving guests had been assigned to their originally reserved rooms? (5) What was the ADR actually achieved by the Inn as the result of the upsell program? (6) What was the amount of the increased room revenue that resulted from Sherri's upsell program? (7) What was the percent increase (rounded to one decimal place) in room revenue achieved by the Inn as a result of the program? (8) Assume that this first week represents the typical week for the upsell program. What would be the hotel's 52-week room revenue increase resulting from the upsell program's implementation? material is presented to students enrolled in the withe
