Answer the following questions:

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. Racik rate is f100.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 \%o achioved 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 frem 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 pyying groups to the property Task 4 - What adorticnal historical data would assist you in analysing the data, evaluating performance, forecasting and in making yield-oriented decisions