All Submissions must be in Microsoft Word file format. Do not include the assignment or parts of theassignment in your submission.ScenarioYou are the revenue manager for the South Side Suites, a $450-$room, busy downtown hotel. The monthof March is historically a high$-$demand period. During your daily revenue management meeting you sitdown with your team to discuss the upcoming busy period of the $3$rd week of March.One of your team members, Raj, reminds everyone that the Mandalorian Madness Fan Group hasbooked $140$ rooms for $3$ nights with a Wednesday arrival date for the $3$rd week of March. This group isguaranteed and will be paying $$200$ per night, per room. They have arranged for a $$Star Wars themed$$dinner on their last night and will be paying $$55$ per person for dinner that evening. The group expects$125$ guests to attend the dinner.Another member of the revenue management team, Aliya, mentions that they have another potentialgroup, Save the Tigers Wildlife Foundation, for the same week. This group would like to book for $5$nights with a Monday arrival, and would like to book $300$ rooms. This group is price$-$sensitive and iswilling to pay the group rate of $$150$ per night. Aliya mentions that this group will need $5$ meeting roomsfor each day.At this point, Elizabeth, another member of the team, mentions that they have a prospective groupbooking for the same week. The group Elizabeth has lined up$,$ Wacky Windsor$$s Royal Fan Club, islooking to book $100$ rooms for $4$ nights with a Wednesday arrival and is willing to pay $$210$ per roomnight. The group is also looking to have a formal banquet on Wednesday and Saturday for $100$ peopleand is willing to pay $$105$ per plate.

Knowing that your hotel cannot accommodate all $3$ groups during the week in question, you and theteam decide to look at the expected transient business during that week. Your group has decided thatyou could expect the following transient business during the week in question:Sunday Monday Tuesday Wednesday Thursday Friday SaturdayExpectedTransientRoomSales$15$ Rooms First $3$digits ofyourstudent IDLast $2$digits ofyourstudent IDFirst $3$digits ofyourstudent IDLast $3$digits ofyourstudent ID$55$ Rooms $76$ RoomsRate $$190$ $$175$ $$195$ $$220$ $$225$ $$230$ $$245$Some other information to help you make a decision:Meeting Room Rate $-$ $$1,000$ per dayMeeting Room Variable Cost $10\%$Variable Cost for Dinner or Banquet $26\%$Required Questions:$(10$ Marks$)$ Which group, if any, should the South Side Suites accept? Why? Include allcalculations in your submission.Your analysis must be supported by financial calculationsincluding:Total revenue for each possible scenario calculatedTotal occupancy for each possible scenarioADR for each possible scenarioRevPar for Each Scenario