Read the following scenario which will be the basis for the assignment: Cornelia Roberts is the Revenue Manager at the 400-Room Sweetwater Branch Inn. The Inn has five different room types, each with a rack rate that reflects its guests view of each room types value. Cornelia knows she cannot upsell guests who stay in her highest rated rooms; however, she feels there is a good potential to impact her hotels revenue performance via upsells to guests who originally booked one of two lower-priced room types (standard & deluxe). She created and implemented a comprehensive upsell training program for her hotels front desk. The cost of providing the upsell training to the Inns eight front desk staff members was $250.00 per employee. At the end of the first week of the programs implementation, she found that her clerks were successful at upselling approximately 50 rooms from each type of guest room arriving at the hotel. Some guests upgraded to the Junior Parlor and Parlor Suites while most upgraded to the Superior Parlor Suite. A summary of the Inns guest reservation/actual stay records is displayed in the Word document below. Help Cornelia by completing the summary and providing her with the answers she needs.

A. Assume this first week represents the typical week for the upsell program. What would the hotel's 52-week revenue increase be as the result of implementing it?

B. Please compare the cost of the program and the benefits that its implementation brought to the hotel on an annual base. Assume the Inn needs to train/retrain employees every quarter. What is your overall evaluation of the programs profits?

C. List at least four benefits that the program would supply. Surmise you would share part of the wealth with the staff?

Actual Nights Reserved Night Actual Room Room Type Rack Rate Reserved Room Rates Usage Revenue Superior Parlor Suite $399.99 200 $79,998.00 250 $99,997.50 Parlor Suite $349.99 125 $43,748.75 150 $52,498.50 Jr. Parlor Suite $319.99 100 $31,999.00 125 $39,998.75 Deluxe $259.99 275 $71,497.25 225 $58,497.75 Standard $209.99 500 $104,995.00 450 $94,495.50 Total Nights 1200 1200 Totals X $332,238.00 $345,488.00 ADR (Total revenue/Tot al nights) $276.87 $287.91