The Badrutt's Palace Hotel St$.$ Moritz which is one of the best Alpine hotels in

Switzerland has provided you with their quarterly bookings data over the last $6$ years

as follows:

Required:

i$)$ Calculate the seasonal indices for each season using multiplicative index

Marks$)$

ii$)$ Forecast the demand for each season of the year $2023$ given that the annual

demand forecast is $324,000$ units.

$(2$ Marks$)$

iii$)$ Deseasonalize the actual demand data $(2017-2022)$ above using the seasonal

indices obtained in $($a$)$ above.

Marks$)$

iv$)$ Generate OLS equation using the Deseasonalized data in $($iii$)$ above $($in thousand

units$)$

$(3$ Marks$)$

$($Total: $10$ Marks$)$