(7 marks: 3, 4) 4. For planning production in the medium term, auto producers forecast the total demand for new cars sold in Canada. The following data are number of new cars sold in Canada (in thousands) during each quarter of 2014 to 2017 (Source: Statistics Canada's CANSIM series V42169911). Use Excel and the Annual Averages method to do the following and include a screenshot of your Excel results below: a. b. Quarter 2014 2015 2016 2017 1 366 378 411 429 234 561 576 596 628 528 539 528 563 436 447 449 450 Compute the seasonal relative for each quarter. Forecast the sales of new cars in each quarter of 2018.