TEST 60 (1).xlsx - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do X Cut Calibri BB Copy - A A ab Wrap Text Paste Format Painter IU- Merge & Center - $ . % 68 08 Cell Clipboard IS Font Alignment i UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Conditional Format as Formatting Table - Styles - Styles Number Update now L6 fa 149 B D E F G H K Student M 1 Name Hussanpreet Singh 301097152 2 Hotel Room Nights Room night share ADR ADR Penetration Student Number DO NOT USE ANY % OR S SYMBOLS. Room Room Occ Revenue Revenue Occ% Share Penetration $ 29,500 82% $ 27,550 90% $ 28,450 79% $ 85,500 83.5% RevPar sold Capacity Number Market of Rooms Share 175 150 190 RevPar Penetration A s von un au B c 145 135 150 168.57 183.66 $ 203.44 $ 204.07 $ 189.66 $ 597.17 S 149 Total 515 430 9 10 11 12 13 14 15 16 Answer the questions below in the yellow box to their right: Which hotel had the best ADR: Which hotel had the worst RevPAR Index (RPL): Which hotel had the best Oce Penetration: What was the Room Night Share for Hotel B: Room Hotel Capacity Number Market of Rooms Share Room Nights sold night share 3 DO NOT USE ANY % OR $ SYMBOLS. Room Room Occ Revenue Occ % ADR Revenue Penetration Share $ 29,500 82% $ 203.44 $ 27,550 90% S 204.07 $ 28,450 79% $ 189.66 $ 85,500 83.5% $ 597.17 4 A 175 145 5 B 150 135 6 190 150 7 Total 515 430 8 9 10 12 13 Answer the questions below in the yellow box to their right: Which hotel had the best ADR: Which hotel had the worst RevPAR Index (RPI): Which hotel had the best Occ Penetration: 14 cou w What was the Room Night Share for Hotel B What is the ADR Index for Hotel C: Sheet 1 Enter Type here to search TEST 60 (1).xlsx - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do X Cut Calibri BB Copy - A A ab Wrap Text Paste Format Painter IU- Merge & Center - $ . % 68 08 Cell Clipboard IS Font Alignment i UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Conditional Format as Formatting Table - Styles - Styles Number Update now L6 fa 149 B D E F G H K Student M 1 Name Hussanpreet Singh 301097152 2 Hotel Room Nights Room night share ADR ADR Penetration Student Number DO NOT USE ANY % OR S SYMBOLS. Room Room Occ Revenue Revenue Occ% Share Penetration $ 29,500 82% $ 27,550 90% $ 28,450 79% $ 85,500 83.5% RevPar sold Capacity Number Market of Rooms Share 175 150 190 RevPar Penetration A s von un au B c 145 135 150 168.57 183.66 $ 203.44 $ 204.07 $ 189.66 $ 597.17 S 149 Total 515 430 9 10 11 12 13 14 15 16 Answer the questions below in the yellow box to their right: Which hotel had the best ADR: Which hotel had the worst RevPAR Index (RPL): Which hotel had the best Oce Penetration: What was the Room Night Share for Hotel B: Room Hotel Capacity Number Market of Rooms Share Room Nights sold night share 3 DO NOT USE ANY % OR $ SYMBOLS. Room Room Occ Revenue Occ % ADR Revenue Penetration Share $ 29,500 82% $ 203.44 $ 27,550 90% S 204.07 $ 28,450 79% $ 189.66 $ 85,500 83.5% $ 597.17 4 A 175 145 5 B 150 135 6 190 150 7 Total 515 430 8 9 10 12 13 Answer the questions below in the yellow box to their right: Which hotel had the best ADR: Which hotel had the worst RevPAR Index (RPI): Which hotel had the best Occ Penetration: 14 cou w What was the Room Night Share for Hotel B What is the ADR Index for Hotel C: Sheet 1 Enter Type here to search