Question 2 (8 marks) The following data are quarterly sales of engine oil (in thousands of...

Transcribed Image Text:

Question 2 (8 marks) The following data are quarterly sales of engine oil (in thousands of gallons) in the Montreal region. Year Q1 Q2 Q3 Q4 2018 11.5 19.2 17.4 12.7 2019 11.9 15.1 17.4 12.1 2020 10.6 19.1 13.9 11.5 2021 10.2 6.2 5.6 The CMA method provided the following seasonal relatives: Quarter Seasonal relative Q1 Q2 Q3 Q4 0.858 1.184 1.098 0.860 The linear trend is observed and the following linear trend equation is obtained based on the deseasonalized data: Yt17.2 0.535 t Extend the model to forecast the sales of engine oil in 2022. Question 2 (8 marks) The following data are quarterly sales of engine oil (in thousands of gallons) in the Montreal region. Year Q1 Q2 Q3 Q4 2018 11.5 19.2 17.4 12.7 2019 11.9 15.1 17.4 12.1 2020 10.6 19.1 13.9 11.5 2021 10.2 6.2 5.6 The CMA method provided the following seasonal relatives: Quarter Seasonal relative Q1 Q2 Q3 Q4 0.858 1.184 1.098 0.860 The linear trend is observed and the following linear trend equation is obtained based on the deseasonalized data: Yt17.2 0.535 t Extend the model to forecast the sales of engine oil in 2022.