1.what is the purpose of looking at each day and deciding the number of rooms to be sold and the rate?

2. looking at the number of room being aold each day and the rate

what suggesttions would you submit to improve the total revenue?

BOD B A D E F G H 1 L K M N o The rate Categories 2 Numer of rooms forecasted to be sold in rach rate catego 100 Room ski resort Lake Tahoe Day Date Rack BAR Package OTA Sun 1 60 20 5 Mon 2 60 20 7 Tues 3 20 20 8 Wed 4 20 20 B 9 Thurs 5 60 20 10 Fri 6 100 11 Sat 7 100 12 Sun 8 60 20 13 Mon 9 60 20 14 Tues 10 20 20 15 Wed 11 20 20 16 Thurs 12 60 20 17 F 13 100 18 Sat 14 100 19 Sun 15 M60 20 20 Mon 16 LAW 6020 21 Tues 17 22 Wed 18 20 20 23 Thurs 19 20 24 Fri 20 25 Sat 21 100 26 Sun 22 50 20 27 Mon 23 60 20 28 Tues 24 20 20 29 Wed 25 2020 30 Thurs 26 50 20 31 Fri 27 100 32 Sat 28 100 33 Sun 29 20 34 Mon 30 60 20 C 35 Tues 31 MLL50 20 36 Total rooms sold 800 900 150 460 37 2320 Forecasted total rooms Sheet1 + Normal View Ready Total rooms forescated to be sold Sumo 22 AM TXO 60 60 60 900 20 20 20 460 2320 Forecasted total rooms 160 Total rooms forescated to be sold D 31 Fri 27 100 32 Sat 28 100 33 Sun 29 34 Mon 30 35 Tues 31 36 Total rooms sold 800 37 38 Rack $ 250.00 $ 200,000.00 39 BAR $ 175.00 $ 157,500.00 40 Packages $ 125.00 $ 20,000.00 41 Ota $ 99.00 $ 45,540.00 42 $ 423,040.00 43 44 Yield max 100 at $250 45 3100 $ 775,000.00 46 47 48 49 Rate times the number of rooms E Wf every room was sold every night at the rack rate