5) Develop a linear trend line model for the following series of demand. (Use Microsoft Excel, you are free to use Excel formulas for this question) Period Demand Period Demand 2 + 3 6 7 34 35 39 38 40 49 48 52 9 10 11 12 13 14 IS 16 54 54 56 59 66 68 67 75 a) What is the trend formula for this demand series? b) Provide your forecasts for the next 4 periods. Present your forecasts in your Excel worksheet, below the periods 1-16. c) Provide your solution for this question using the exponential smoothing technique. d) Which forecasting technique looks more promising for this question? Provide your answer by referencing the success criteria (what were they?) for those forecasts