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 V$42169911).$ Use Excel and the Annual Averages method to do the following and include a screenshot of your Excel results below:

$\backslash$table$[[$Quarter$,2014,2015,2016,2017],[1,366,378,411,429],[2,561,576,596,628],[3,528,539,528,563],[4,436,447,449,450]]$

a$.$ Compute the seasonal relative for each quarter.

b$.$ Forecast the sales of new cars in each quarter of $2018.$

Search