Question: Question 4 It was the 27th December. 2016. Jane just started working at a marketing department for a resort hotel. Her rst duty was to


Question 4 It was the 27th December. 2016. Jane just started working at a marketing department for a resort hotel. Her rst duty was to forecast how many bookings the hotel would receive in 2017. (a) Jane's processor had completed some work on the forecasting. The seasonal index (SI) for the number of bookings in 2015 and 2016 is given below: Year Quarter 51 2015 1 0.5318 1A482 03393 10554 0 .6122 16246 08008 1.1208 2016 bUJMI-I-bU-IM Use the techniques of time series modelling to determine the quarterly seasonal indexes for time series. Compute the normalized quarterly seasonal indexes. (10 marks) (b) The actual number of bookings in 2016 are given below. Year Qu arter Bookings 2016 1 1'4 2 211 3 106 4 145 Use the normalized quarterly seasonal indexes you computed in Question 4(a) to obtain the deseasonalised data for the year 2016. (5 marks) (c) While Jane was working, her 9 years old nephew who was in Primary 3 dropped by. He was quite puzzled by the word "deseasonalise" and asked her what it meant. Explain what "deseasonalised" means in plain English that even Primary 3 pupils can understand. (5 marks) (d) Jane was almost done with her work. She obtained the trend line from the deseasonalised time series as below: Number of Bookings in time t = 65 + 10t Assume the 1" quarter in 2015 was time 1. 2nd quarter in 2015 was time 2. etc. What should be Jane's forecast for the 3id quarter in 2017?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
