a clearer version:

how to calculate the following questions, Q1-5?

clearer numbers

1 calculation till You are the revenue manager for the Hotel SHITM (300). The below information was the booking report for two weeks in July that you gerated on 25 June July. Please the following infor 25 25 June dy 2 holy 25 June As you were on Shine 25 June 2 oly As you were on 2 July Tin Tin Transit Train Croup Group Group Book Group Book Hook Rook Book Book Book Book 4 Dale Occupancy Day of weekCon ADR Total Cord ADR Coast) ADR Occupancy Total Count ADR 5 ADR 2-1 Thursday 1275 891 ROPAR 107 5 858 Reve RIPAR Reve 23 S ADR 742 335 3- Priday 1045 731 984 1205 945 10 S 780 7 335 798 4- Satuday OTS 970 1125 963 10 $ 750 $$$ 5- Sunday 791 745 MS 575 678 915 671 0 6 Monday 42-5 855 105 367 1095 741 100 S 241 10 5.1 Tuesday 325 220 BE 445 739 565 601 11 - Wednesday 025 167 705 812 SES 684 885 701 12 9. Thuriday 935 189 110 S 912 708 195 60 1 10- Friday 715 902 890 345 762 34 5 14 11- Saturday 66 5 1.013 365 973 535 777 . 761 15 12.30 Stay 9 635 512 2005 644 2005 041 16 11. Monday 325 87 $ 877 1135 683 1215 64 17 14-1 Thesday 56S 171 685 343 1905 650 170 S 052 18 15- Wednesday 357 105 198 105 70 19 20. 01. Fill out the colonne rom column to R) for each date as you were on 25 kme and 2 oy (5 points) 21 22 92: What were the RePAR for the Hotel SHTMwen you were on 25 und 2 uy? (5 points) NOS 59 5 195 25 26 2Y 03 If you were on 2 July, what were the ADR for weekends (Priday and Saturday) in these two weeks for stoppest? (5 points) 29 31 11 Come the booking sports fies these two date as line and 2 July). Sponta) 11 Answer 15 O se pode ter with gestions for the Hot SHM's performance Lopes Answer B @ D E FI G H 1. Calculation questions (30 points in total) 2 You are the revenue manager for the Hotel SHTM (300 rooms). The below information was the booking report 3 25 June 25 June 2 July 2 July 25 June 25 June 2 July 2 July Transient Transient Transient Transient Group Group Group Group Book Book Book Book Book Book Book Book Occi 4 Date Day of week Count ADR Count ADR Count ADR Count ADR % 5 2-Jul Thursday 127 S 891 167 $ 888 23 $ 742 53 $ 731 6 3-Jul Friday 104 $ 984 120$ 945 10 S 789 55 $ 798 7 4-Jul Saturday 97 $ 979 112 $ 963 10 S 789 55$ 798 8 5-Jul Sunday 74 S 865 83 $ 877 57 S 678 57 $ 678 9 6-Jul Monday 42 855 105 $ 867 109 $ 741 109 $ 741 10 7-Jul Tuesday 32 $ 854 120 $ 831 44 $ 735 56 $ 691 11 8-Jul Wednesday 62 $ 867 70 $ 812 58 S 684 88 701 12 9-Jul Thursday 93 $ 889 110 $ 912 44 S 708 89 $ 13 10-Jul Friday 74 $ 913 89 $ 899 34 S 762 34 $ 762 14 11-Jul Saturday 66 $ 1,013 76 $ 973 53 $ 777 89 $ 761 15 12-Jul Sunday 59 $ 899 63 $ 812 200 $ 644 200 S 644 16 13-Jul Monday 52 $ 877 87 $ 877 113 $ 683 123 $ 674 17 14-Jul Tuesday 54 S 871 68 $ 843 170 $ 659 170 $ 659 18 15-Jul Wednesday 54 $ 868 59 $ 857 10 S 798 10 $ 798 19 20 Q1: Fill out the columns (From column K to R) for each date as you were on 25 June and 2 July (5 points) 21 22 Q2: What were the RevPAR for the Hotel SHTM when you were on 25 June and 2 July? (5 points) 23 24 25 26 27 03:1f you were on 2 Iuly what were the ADR for landeid 689