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.

$\backslash$table$[[$Customer Type,Rack,Commercial,Agency $($Group$),$Weekend,Total Rooms$],[$Rote $E,100,115,76,45,],[$January$,510,380,260,250,1400],[$Funiten:$,300,840,2020,\frac{3}{5},2126],[$March$,960,680,300,300,2240],[4,981,(30),340,250,251],[$May$,1000,750,360,360,2470],[$hats$,$$$00,710,280,390,2080$:$],[$July$.,714,320,350,400,1784],[$figut$.,660,300,100,39.,124],[$September$,965,540,310,290,2105],[$Groser:$,580,481,300.,200,1047],[$November$,850,440,350,300,1940],[$Liecemper$,700,300,400,5060,8900]]$

From this historical data you are required to calculate the following:

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 &

$-$What additional historical data would assist you in analysing the data, evaluating performance, forecasting and in making yield$-$oriented decisions?