Read the following scenario which will be the basis for the assignment Camelia Roberts is the Revenue Manager at the 400- Room Sweetwater Branch Inn. The Inbus five different room type, each with a rack rate that reflects its est view of each room type's value. Comellanows she cannot sell guests who stay in her highest rated room, bowever, she feels there is a good potential to impact her hotel's revenue performance in pells to guests who originally booked one of two lower priced room types (standard & deline). She created and implemented comprehensive pell training program for ber hotel's front desk. The cost of providing the well training to the Insight front desk staff members was $250,00 per moloyee. At the end of the first week of the program implementation, she found that her clarks were accessful at upselling approximately 50 rooms from each type of pestroom uriving at the wel. Some guests upgraded to the Junior Parlor and Parlor Suites while most upgraded to the Superior Parlor Suite. A summary of the Inn's guest reservation'actual stay records is displayed in the Word document below. Help Comelia by completing the way and providing her with the answers she needs 1. Complete the missing boxes for Cornelia este programs Ramil New Men Sale 125 100 IPS 31 100 1300 * 2 Based on Comelia's first week data, answer the following question What would the Inn's ADR have been if all arriving guests had been assigned to their originally reserved rooms! What was the ADR actually achieved by the In the result of the upiell program? What would the Inn's revenue have been if all arriving quests had been assigned to their originally Perved room? What was the revenue achieved by the Inn as the result of the psell program? o What was the amount of the increased revenue that resulted from Sherri's pel program? What was the percent increase rounded to one decimal place) in revenue achieved by the fun as a result of the program Asume this for week represent the typical week for the upucll program. What would the ho 52-weck revenue increase be as the result of plementing Please comporte cost of the propram and the benefits that its implemention bought to the below bus Assume the mode to retrin employees every quarto. Wat is your overall evaluation of the program List at least for benefits that there would Read the following scenario which will be the basis for the assignment Camelia Roberts is the Revenue Manager at the 400- Room Sweetwater Branch Inn. The Inbus five different room type, each with a rack rate that reflects its est view of each room type's value. Comellanows she cannot sell guests who stay in her highest rated room, bowever, she feels there is a good potential to impact her hotel's revenue performance in pells to guests who originally booked one of two lower priced room types (standard & deline). She created and implemented comprehensive pell training program for ber hotel's front desk. The cost of providing the well training to the Insight front desk staff members was $250,00 per moloyee. At the end of the first week of the program implementation, she found that her clarks were accessful at upselling approximately 50 rooms from each type of pestroom uriving at the wel. Some guests upgraded to the Junior Parlor and Parlor Suites while most upgraded to the Superior Parlor Suite. A summary of the Inn's guest reservation'actual stay records is displayed in the Word document below. Help Comelia by completing the way and providing her with the answers she needs 1. Complete the missing boxes for Cornelia este programs Ramil New Men Sale 125 100 IPS 31 100 1300 * 2 Based on Comelia's first week data, answer the following question What would the Inn's ADR have been if all arriving guests had been assigned to their originally reserved rooms! What was the ADR actually achieved by the In the result of the upiell program? What would the Inn's revenue have been if all arriving quests had been assigned to their originally Perved room? What was the revenue achieved by the Inn as the result of the psell program? o What was the amount of the increased revenue that resulted from Sherri's pel program? What was the percent increase rounded to one decimal place) in revenue achieved by the fun as a result of the program Asume this for week represent the typical week for the upucll program. What would the ho 52-weck revenue increase be as the result of plementing Please comporte cost of the propram and the benefits that its implemention bought to the below bus Assume the mode to retrin employees every quarto. Wat is your overall evaluation of the program List at least for benefits that there would