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.

$\backslash$table$[[$Customer Type,Rack,Commercial,Agoncy $($Group$),$Weekend,Total Rooms$],[$Rato $E,100,115,76,45,],[$January$,510,380,260,250,1400],[$Fimen:$,300,840,270,3/5,2126],[$March$,960,680,300,300,2240],[,981,090,340,250,\mathrm{.}251],[$May$,1000,750,360,360,2470],[$Jhon$.,$$$00,710,280,300,2080$:$],[$July$,714,320,350,400,1784],[$hioust$,660,300,100,39,124],[$September$,965,540,310,290,2105],[$Grioser:$,888,461,370,200,1041],[$November$,850,440,350,300,1940],[$Urcember$,700,300,400,-5020,$E$900]]$