3) Part C Which group, if any. should the Diamond Peak Hotel accept? Explain your answer based on: (8 Marks} at Total Revenue bl Rev PAR c. Total Contribution d1 TRev PAR Based purely on information that is NOT a part of your nancial analysis. which group do you feel the General Manager should choose. Indicate a least three reasons for your decision that are evidenced in the narrative. (7' Marks) On an overall basis what would your decision be if you were the General Manager? Explain yourthinking in detail. (10 Marks} x Apps and Oranges SS Complete.> X Bb 19024663 X Q Which group, if any, should the [ X *Part0 1) Which group, if any. shot x *Course Hero X + X C https://georgiancollege-my.sharepoint.com/:x:/g/personal/erin_wilson_georgiancollege_ca/ESo51JgkvZtOr6v42qZfST8B_XxVfnyNNayxbV2bR-fR6g?e=vVzF2C SG SE . . . s Student Portal Smart Service AMEengage (accoufirst Aid Certificate Gym Booking OPERA Cloud wow Training | Typsy Me... TCPS 2: RESEARCH OntarioLearn Excel Apps and Oranges SS Complete - Saved Search (Alt + Q) ST File Home Insert Draw Formulas Data Review View Automate Help Viewing v Comments Catch up 8 Share 12 By v A v ... Ev ab Merge General v $ v :00 . . . i X You don't have permission to download or print this file. J41 ~ X V fx A B C D E F G H J K L M N O P "Comparing Apples and Oranges: Which Group Yields the Best Profit?" Sunday Monday Tuesday Wednesday Thursday Friday Total 575 2 Room Revenue Fraternity Business Rooms 0.00 125.00 125.00 125.00 125.00 0.00 500.00 525.00 w ADR 130.00 130.00 130.00 130.00 130.00 130.00 50.00 Revenue 0.00 16250.00 16250.00 16250.00 16250.00 0.00 65000.00 40 Transient business budge Rooms 50.00 30.00 150.00 150.00 90.00 100.00 620.00 ADR 135.00 135.00 135.00 135.00 135.00 135.00 Revenue 6750.00 10800.00 20250.00 20250.00 12150.00 13500.00 83700.00 Religious Group Rooms 50.00 100.00 400.00 400.00 400.00 20.00 1670.00 10 ADR 109.00 109.00 109.00 109.00 109.00 109.00 11 Revenue 5450.00 43600.00 43600.00 43600.00 43600.00 2180.00 182030.00 12 Corporate Group Rooms 0.00 0.00 300.00 300.00 300.00 0.00 900.00 13 ADR 120.00 120.00 120.00 120.00 120.00 120.00 14 Revenue 0.00 0.00 36000.00 36000.00 36000.00 0.00 108000.00 15 Total Hotel Performance Total Rev 12200.00 66600.00 66600.00 66600.00 66600.00 15680.00 294280.00 16 Religious Group Scenario ADR 122.00 115.83 115.83 115.83 115.83 130.67 116.78 17 17.39% 100.00% 100.00% 100.00% 100.00% 20.87% 73.04% E Sheet1 Sheet2 Sheet3 + - 100% + Workbook Statistics Give Feedback to Microsoft ENG 2:11 AM -3 . C Q Search US 2022-12-09 Cloudyx Apps and Oranges SS Complete.> X Bb 19024663 X Q Which group, if any, should the [ X *Part0 1) Which group, if any. shot x *Course Hero X + X C https://georgiancollege-my.sharepoint.com/:x:/g/personal/erin_wilson_georgiancollege_ca/ESo51JgkvZtOr6v42qZfST8B_XxVfnyNNayxbV2bR-fR6g?e=vVzF2C SG SE . . . s Student Portal Smart Service AMEengage (accoufirst Aid Certificate Gym Booking OPERA Cloud wow Training | Typsy Me... TCPS 2: RESEARCH OntarioLearn Excel Apps and Oranges SS Complete - Saved Search (Alt + Q) ST File Home Insert Draw Formulas Data Review View Automate Help Viewing Comments Catch up 8 Share 12 v By My Av ... Ev ab Merge General v $ v . . . . i You don't have permission to download or print this file. X J41 - X V fx A B C D E G H K L M N O P 18 RevPAR 21.22 115.83 115.83 115.83 115.83 27.27 85.30 19 Total Hotel Performance Total Rev 6750.00 27050.00 72500.00 72500.00 64400.00 13500.00 256700.00 20 Corporate Group ScenariQADR 135.00 131.95 126.09 126.09 125.05 135.00 127.08 21 Occ/ 8.70% 35.65% 100.00% 100.00% 89.57% 17.39% 58.55% 675.00 22 RevPAR 11.74 47.04 126.09 126.09 112.00 23.48 74.41 23 Transient Lost, Religious (Rooms) 0.00 30.00 100.00 100.00 40.00 0.00 270.00 24 Transient Lost, Religious ($) 0.00 4050.00 13500.00 13500.00 5400.00 0.00 36450.00 25 Transient Lost, Corporate (Rooms) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 26 Transient Lost, Corporate ($) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27 Projected Total Conribution (neither group) 4750.00 18850.00 25500.00 25500.00 19800.00 9500.00 103900.00 103900.00 28 Total Contribution with Religious 8200.00 43600.00 43600.00 43600.00 43600.00 10880.00 193480.00 193480.00 29 Total Contribution with Corporate 4750.00 18850.00 49500.00 49500.00 43800.00 9500.00 175900.00 175900.00 an 31 Additional Revenues Religious F&B Outlet 0.00 8000.00 8000.00 8000.00 4000.00 0.00 28000.00 32 Catering 0.00 1200.00 1200.00 1200.00 11200.00 0.00 14800.00 33 Meeting Rooms & Equip. 0.00 1600.00 1600.00 1600.00 1600.00 0.00 6400.00 34 Total Additional Rev 0.00 10800.00 10800.00 10800.00 16800.00 0.00 49200.00 Sheet1 Sheet2 Sheet3 + Workbook Statistics Give Feedback to Microsoft - 100% + -3 . C ENG 2:12 AM Cloudy Q Search US 2022-12-09x Apps and Oranges SS Complete.> X Bb 19024663 X Q Which group, if any, should the [ X *Part0 1) Which group, if any. shot x *Course Hero X + X C https://georgiancollege-my.sharepoint.com/:x:/g/personal/erin_wilson_georgiancollege_ca/ESo51JgkvZtOr6v42qZfST8B_XxVfnyNNayxbV2bR-fR6g?e=vVzF2C SG SE . . . s Student Portal Smart Service AMEengage (accoufirst Aid Certificate Gym Booking OPERA Cloud wow Training | Typsy Me... TCPS 2: RESEARCH OntarioLearn Excel Apps and Oranges SS Complete - Saved Search (Alt + Q) ST File Home Insert Draw Formulas Data Review View Automate Help Viewing Comments Catch up 8 Share 12 v By My A v ... Ev ab Merge General v $ v . . . . i You don't have permission to download or print this file. X J41 - X V fx A B C D E F G H K L M N O P Total Contribution with Religious 8200.00 43600.00 43600.00 43600.00 43600.00 10880.00 193480.00 28 193480.00 29 Total Contribution with Corporate 4750.00 18850.00 49500.00 49500.00 43800.00 9500.00 175900.00 175900.00 31 Additional Revenues Religious F&B Outlet 0.00 8000.00 8000.00 3000.00 4000.00 0.00 28000.00 32 Catering 0.00 1200.00 1200.00 1200.00 11200.00 0.00 14800.00 33 Meeting Rooms & Equip. 0.00 1600.00 1600.00 1600.00 1600.00 0.00 6400.00 34 Total Additional Rev 0.00 10800.00 10800.00 10800.00 16800.00 0.00 49200.00 35 TRevPAR 21.22 134.61 134.61 134.61 145.04 27.27 99.56 36 Corporate F&B Outlet 0.00 0.00 3000.00 3000.00 3000.00 0.00 9000.00 37 Catering 0.00 0.00 15500.00 15500.00 20500.00 0.00 51500.00 38 Meeting Rooms & Equip. 0.00 0.00 2400.00 2400.00 2400.00 0.00 7200.00 39 Total Additional Rev 0.00 0.00 20900.00 20900.00 25900.00 0.00 67700.00 40 TRevPAR 11.74 47.04 162.43 162.43 157.04 23.48 94.03 41 42 43 44 Sheet1 Sheet2 Sheet3 + Workbook Statistics Give Feedback to Microsoft - 100% + -3 . C ENG 2:12 AM Q Search Cloudy US 2022-12-09