Please show all work using pencil & paper.

Also please use Excel,

Thank you.

2. (SHOW YOUR COMPLETE WORK) A store manager has been monitoring the demand for a product. The actual demand data during the last five weeks are shown below: WEEK ACTUAL DEMAND (number of units sold) Five weeks ago 70 Four weeks ago 75 Three weeks ago 78 Two weeks ago 83 One week ago 86 THIS WEEK ACTUAL DEMAND NOT KNOWN Use trend-adjusted exponential smoothing to obtain the demand forecast for THIS WEEK. Use the following: Exponentially smoothed forecast five weeks ago = 65 units Exponentially smoothed trend estimate five weeks ago = 4 units The smoothing constants: a =0.4, B =0.5. (32 points) Use the appropriate label/unit of measurement in your answer. Leave the numbers in decimal and go up to 5 decimal places for higher accuracy. 2. (SHOW YOUR COMPLETE WORK) A store manager has been monitoring the demand for a product. The actual demand data during the last five weeks are shown below: WEEK ACTUAL DEMAND (number of units sold) Five weeks ago 70 Four weeks ago 75 Three weeks ago 78 Two weeks ago 83 One week ago 86 THIS WEEK ACTUAL DEMAND NOT KNOWN Use trend-adjusted exponential smoothing to obtain the demand forecast for THIS WEEK. Use the following: Exponentially smoothed forecast five weeks ago = 65 units Exponentially smoothed trend estimate five weeks ago = 4 units The smoothing constants: a =0.4, B =0.5. (32 points) Use the appropriate label/unit of measurement in your answer. Leave the numbers in decimal and go up to 5 decimal places for higher accuracy