How do you answer task 2, 3, 4?

Case Study C - Analysing Historical Data This data below is for the previous twelve months from a 100 room city centre hotel with standard rooms. Rack rate is 100.00, and there are three other rates used. This table shows the number of reservations for each customer type for each month. Commercial Agency (Group! Weekend Total Rooms Rack 100 510 330 960 380 640 250 375 300 250 680 260 230 300 340 360 280 750 Customer Type Bate January Ponery March Abo May Juno July August September CODE November December 360 390 350 1400 2125 2240 0251 2470 2080 1784 1241 2106 1841 1940 1900 1000 900 714 660 965 980 400 510 320 300 540 C00 310 320 350 400 39 290 200 481 850 300 440 300 700 -500 From this historical data you are required to calculate the following: Task 1 Occupancy % achieved for each month Room Revenue achieved per month Average Room Rate achieved for each month Task 2 Calculate: Based on the total number of rooms sold, the percentage mix of business achieved per month from each customer type. Task 3 . From these calculations, comment on the demand patterns from each of the customer types. You might want to consider some of the following yield-orientated issues: demand at specific times of the year from each type of customer . additional promotions that should have been carried out the need for attracting higher paying groups to the property Task 4 What additional historical data would assist you in analysing the data, evaluating performance, forecasting and in making yield-oriented decisions