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\mathrm{.}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 $100510330960380640250375300250680260230300340360280750$ Customer Type Bate January Ponery March Abo May Juno July August September CODE November December $3603903501400212522400251247020801784124121061841194019001000900714660965980400510320300540$ C$0031032035040039290200481850300440300700-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?