1. A bike manafacturer is preparing plans for production for the next year. The data below shows the sales in units of total number of bikes per quarter over the three year period 2012 to 2014. Total sales of bikes in 1000 of units Quarter 1 Quarter 2 Quarter 3 Quarter 4 2012 25 32 35 68 2013 31 35 43 72 20141 38 43 52 75 Use the data from the table above to answer the following questions: a) Draw a time series graph of this sales data using the graph paper provided. b) Briefly comment on the pattern of sales shown on your graph in part a) above. c) Calculate a centred four point moving average for the sales data. Sketch the trend line on your time series graph produced in a) above. d) Using the multiplicative model calculate the seasonal factors. e) Using trend values of 53 and 55 respectively, forecast the expected sales for 2015 Q1 and 2015 Q2. 1. A bike manafacturer is preparing plans for production for the next year. The data below shows the sales in units of total number of bikes per quarter over the three year period 2012 to 2014. Total sales of bikes in 1000 of units Quarter 1 Quarter 2 Quarter 3 Quarter 4 2012 25 32 35 68 2013 31 35 43 72 20141 38 43 52 75 Use the data from the table above to answer the following questions: a) Draw a time series graph of this sales data using the graph paper provided. b) Briefly comment on the pattern of sales shown on your graph in part a) above. c) Calculate a centred four point moving average for the sales data. Sketch the trend line on your time series graph produced in a) above. d) Using the multiplicative model calculate the seasonal factors. e) Using trend values of 53 and 55 respectively, forecast the expected sales for 2015 Q1 and 2015 Q2