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. 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? Number of reservations for each customer type (or market segment) per month 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. 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? Number of reservations for each customer type (or market segment) per month