2:20 y y OK . Call HOTL701 Fin Man... Questions 041221 - Unsaved . . . fx Name V C D E F G H K L lumber O W lowing missing items 20 Last Year This Year Rooms Occupancy % 800 Sold Occupancy % ADR Revenue RevPar Rooms Sold % ADR Revenue RevPar Change 980 40% 135.35 1,326,430 53.4 9950 40% 149.12 1,483,706 59.83 112% 9975 459 137.25 1,369,069 61.12 9840 1,492,662 66.64 109%% 1450 151.50 2,196,750 38.58 14775 60%% 162.40 2,399,460 96.75 82% 162.50 3 185.000 132.71 83% 170.61 3,418,133 142.42 107% 92% 188.66 173.45 23290 94% 199.8 4,654,157 187.67 108% 22900 95%% 93.60 4,433,440 184.73 23175 204.48 4,738,766 197.45 107% 22850 925 180.30 4,119,855 166.12 23200 94%% 182.7 4,239,394 170.94 103% 23100 170.22 3.932.082 158.55 23825 96% 179.90 4,286,108 172.83 109% 22855 95% 191.66 182.52 23240 97%% 204.68 4 756.862 109% 83% 187.30 3,832,158 154.52 22120 89% 190.16 169.61 110% 16275 68% 160.25 2,608,069 108.6 15890 66%% 166.75 2,649,650 110.40 9765 39% 138.66 1,354,015 54.60 9715 39% 146.73 1,425,514 57.48 105% 37,038,705 219,055 75% 39,750,696.64 136.13 375 Room Hotel 10 Rooms Occ % ADR RevPar 300 35 93% $ 176.86 372 189.82 335 344 142.39 Revenues Sales F&B Sales Mix Profit Profit Mix F&B Profit Mix Profit Margins 1.250.375 Rooms 73% leverage Total Lounge 55% Lounge 48,800 All Day 32% All Day Dinner 7% 152,79 Dinne 137,385 Room Service 2% Room Service 38,600 Banquets 43% Banquets / Catering 435,685 Other 85% artments 36.725 Total F&B Margin 36 Questions + O2:21 Byy . Call HOTL701 Fin Man... Questions 041221 - Unsaved . . . fx Name V O C D E F G H 1 J K N student Number O Find the following missing items 20 Last Year This Year Rooms Occupancy 800 Sold Occupancy % ADR Revenue RevPar Rooms Sold ADR Revenue RevPar Januray 980 40% 135.35 1,326,430 53.49 9950 40% 149.12 1,483,706 59.83 February 9975 452 137.25 1,369,069 61.12 9840 1,492,662 66.64 March .4500 151.50 2,196,750 88.58 14375 60% 162.40 2,399,460 96.75 April 19600 82% 162.50 3.185.000 132.7 83% 170.61 3,418,133 142.42 May 92% 188.66 173.45 23290 942 199.84 4,654,157 187.67 11 June 22900 95% 193.60 4,433,440 184.73 2317 204.48 4,738,766 197.45 12 July 22850 92%% 180.30 4,119,855 166.12 23200 94% 182.73 4,239,394 170.94 13 August 23100 170.22 3.932.082 158.5 23825 96% 179.90 1,286,108 172.83 September 22855 95% 191.66 182.52 23240 97% 204.68 4.756.862 15 October 83% 187.30 3,832,158 154.5 22120 89% 190.16 169.61 November .6275 68% 160.25 2,608,069 08.67 15890 66% 56.7 2,649,650 110.40 December 9765 39% 138.66 1,354,015 54.60 9715 39% 145.72 1,425,514 57.48 Total 37,038,705 19,055 75% 39,750,696.64 136.13 375 Room Hotel 10 Rooms ADR levPar Mar 300 Tue 350 93% $ 176.86 Wed 372 WHEN _ $ 189.82 Thu WHUA Fri 344 142.39 Total Sales F&A Sales F&B Profit Revenues Mix Profit Profit Mix Mix Profit Margins Roams 1.250.375 Rooms 73% Food and Beverage Total Lounge 55% Loung 18,800 All Day 32% All Day 152,790 Dinner 7% 137,385 Room Service Dinner 2% Room Service 38,600 Banquets 43% Banquets / Catering 435,685 Other 85% Other Departments 36.725 Total What is the ERB Margin 28 36 Questions + O
