35 M N One 4 ADR RevPAR A c E F H 1 Question 1- Revenue Calculations 2 Thursday Week 1 Week 2 Week 3 Week 4 Weck 3 Week 6 Week 7 3 Historical Data Occ96 69.5 735 66 721 725 69 77 4 ADR $151.50 $145.95 $161.50 S178.50 $179.95 $129.95 $159 95 5 Rooms Available 486 186 4501 450 486 186 486 Total 6 Rooms Sold 7 Revenue Weeks 1.4 Rev Par 9 Rooms Sold 10 Revenue 11 Weeks 2.5 Ray Par 12 Rooms Sold 13 Revenge 14 Weeks 3.6 Rey Par 15 Rooms Sold 16 Revenue 17 Rev Par 10 PROTECTED VIEW Be carefulfiles trom the internet can contain viruses. Unless you need to edit it's safet to stay in Pratected View Enable to 135 X B D E F G H A Weeks 4-7 11 Rey Pat 18 19 20 Question 2- Occupancy Forecasting 21 Occupancy Report The Doubletree Hotel For Dates May 1-14 22 Run Date: Today Date Day Rooms Reserved Blocked Total Current 23 Available Held Occ. % 24 5-1 Mon 486 210 60 % 25 5-2 Tues 486 175 420 26 5-3 Wed 486 200 50.00% 27 5-4 Thur 486 90 110 28 5-5 Fri 486 220 300 -29 5-6 Sat 486 100 75.00% 30 5-7 Sun 486 275 25 31 5-8 Mon 486 100 350 32 5-9 Tues 486 250 90.00% 33 5-10 Wed 486 60 210 34 5-11 Thur 486 175 420 35 5-12 Fri 450 210 60 36 5-13 Sat 450 175 420 37 5-14 Sun 450 200 50% 38 Total 39 40 AutoSave T BUS8510-Practical Lab 3 - Hotel Rooms Revenue-XF - Protec File Home Insert Page Layout Formulas Data Review View Help Power Pivot PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable 135 B D E F G 40 41 Question 3- Availability Forecasting 42 Availability Report The Doubletree Hotel For Dates May 1-14 43 Run Date: Today Date Day Rooms Reserved Blocked Total Available 44 Available Held for Sale 45 5-1 Mon 486 210 60 46 5-2 Tues 486 175 420 47 5-3 Wed 486 200 250 48 5-4 Thur 486 90 110 49 5-5 Fri 486 220 300 50 5-6 Sat 486 100 125 51 5-7 Sun 486 275 25 5-8 Mon 486 100 350 53 5-9 Tues 486 250 50 54 5-10 Wed 486 60 210 55 5-11 Thur 486 175 420 56 5-12 Fn 450 210 60 57 5-13 Sat 450 175 420 58 5-14 Sun 225 450 200 59 Total 60 61 19 10 Hotel: The Double Tree Size: 486 Rooms & 2 Restaurants Location: Toronto, Ontario 111 12 13 14 15 16 Assignment Using the information on the "calciations" tab, complete the missing information for each category listed. Utilize formula's to expedite the process and assist in the future when making changes 17 118 2. BUS8510 Practical Lab 3 Hotel Rooms Revenue 6 Due Date: In Class Exercise Assignment Value: 5% of the term goal Grade Received: Will be graded out of 100 points 3 2 0 Hotel: The Double Tree Size: 486 Rooms & 2 Restaurants Location: Toronto, Ontario 1 2 3 4 5 Assignment Using the information on the "calculations" tab, complete the missing information for each category listed. Utilize formula's to expedite the process and assist in the future when making changes 5 7 3 Submission You must send your completed presentation through dropbox on econestoga by November 5 2020 at 11:59am - THE LATEST SUBJECT LINE "BUS8510 Instructions calculations 35 M N One 4 ADR RevPAR A c E F H 1 Question 1- Revenue Calculations 2 Thursday Week 1 Week 2 Week 3 Week 4 Weck 3 Week 6 Week 7 3 Historical Data Occ96 69.5 735 66 721 725 69 77 4 ADR $151.50 $145.95 $161.50 S178.50 $179.95 $129.95 $159 95 5 Rooms Available 486 186 4501 450 486 186 486 Total 6 Rooms Sold 7 Revenue Weeks 1.4 Rev Par 9 Rooms Sold 10 Revenue 11 Weeks 2.5 Ray Par 12 Rooms Sold 13 Revenge 14 Weeks 3.6 Rey Par 15 Rooms Sold 16 Revenue 17 Rev Par 10 PROTECTED VIEW Be carefulfiles trom the internet can contain viruses. Unless you need to edit it's safet to stay in Pratected View Enable to 135 X B D E F G H A Weeks 4-7 11 Rey Pat 18 19 20 Question 2- Occupancy Forecasting 21 Occupancy Report The Doubletree Hotel For Dates May 1-14 22 Run Date: Today Date Day Rooms Reserved Blocked Total Current 23 Available Held Occ. % 24 5-1 Mon 486 210 60 % 25 5-2 Tues 486 175 420 26 5-3 Wed 486 200 50.00% 27 5-4 Thur 486 90 110 28 5-5 Fri 486 220 300 -29 5-6 Sat 486 100 75.00% 30 5-7 Sun 486 275 25 31 5-8 Mon 486 100 350 32 5-9 Tues 486 250 90.00% 33 5-10 Wed 486 60 210 34 5-11 Thur 486 175 420 35 5-12 Fri 450 210 60 36 5-13 Sat 450 175 420 37 5-14 Sun 450 200 50% 38 Total 39 40 AutoSave T BUS8510-Practical Lab 3 - Hotel Rooms Revenue-XF - Protec File Home Insert Page Layout Formulas Data Review View Help Power Pivot PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable 135 B D E F G 40 41 Question 3- Availability Forecasting 42 Availability Report The Doubletree Hotel For Dates May 1-14 43 Run Date: Today Date Day Rooms Reserved Blocked Total Available 44 Available Held for Sale 45 5-1 Mon 486 210 60 46 5-2 Tues 486 175 420 47 5-3 Wed 486 200 250 48 5-4 Thur 486 90 110 49 5-5 Fri 486 220 300 50 5-6 Sat 486 100 125 51 5-7 Sun 486 275 25 5-8 Mon 486 100 350 53 5-9 Tues 486 250 50 54 5-10 Wed 486 60 210 55 5-11 Thur 486 175 420 56 5-12 Fn 450 210 60 57 5-13 Sat 450 175 420 58 5-14 Sun 225 450 200 59 Total 60 61 19 10 Hotel: The Double Tree Size: 486 Rooms & 2 Restaurants Location: Toronto, Ontario 111 12 13 14 15 16 Assignment Using the information on the "calciations" tab, complete the missing information for each category listed. Utilize formula's to expedite the process and assist in the future when making changes 17 118 2. BUS8510 Practical Lab 3 Hotel Rooms Revenue 6 Due Date: In Class Exercise Assignment Value: 5% of the term goal Grade Received: Will be graded out of 100 points 3 2 0 Hotel: The Double Tree Size: 486 Rooms & 2 Restaurants Location: Toronto, Ontario 1 2 3 4 5 Assignment Using the information on the "calculations" tab, complete the missing information for each category listed. Utilize formula's to expedite the process and assist in the future when making changes 5 7 3 Submission You must send your completed presentation through dropbox on econestoga by November 5 2020 at 11:59am - THE LATEST SUBJECT LINE "BUS8510 Instructions calculations