a.Plot the monthly demand data using a software OR on a sheet of graph paper.

b.Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in months) and demand (in units sold).

c.Use the equation of the trend line to predict demand for the month of October 2020.

Please show ALL working's to math etc. typed out if possible, thank you!

May 2020 524 June 2020 492 July 2020 472 August 2020 470 September 2020 a. Plot the monthly demand data using a software OR on a sheet of graph paper, 5. Use TREND PROJECTIONS method to determine the equation of the trend line estimating linear relationship between time (in mortl) and demand (in units sold). (25 por . Use the equation of the trend line to predict demand for the month of October 2020. Hint: "February 2020' will have a value of '1' in the equation of the trend line, and by the ogic "September 2020 will have a value of '8' in the equation of the trend line.) @ % TURICE LIST The smoothing constants 04.05. 132 points 3. (SHOW YOUR COMPLETE WORK) The actual demand data over the past eight month for brand new product are shown below. MONTH ACTUAL DEMAND (number of its old) February 2000 656 March 2020 600 April 2020 50 May 2000 June 2020 July 2020 472 470 August 2020 September 2020 466 a. Plot the monthly demand data using a software On a sheet of graph paper b. Use TREND PROJECTIONS method to determine the equation of the trendline estimati linear relationship between time (in mortis) and demand (in units sold) c. Use the equation of the trend line to predict demand for the month of October 2020 492 1 (Hint: February 2020' will have a value of 'l' in the equation of the trend line, and by the logle September 2020' will have a value of '8' in the equation of the trendline.)