Question: please help with the wrong answers b. Using the same data, forecast demand using exponential smoothing. You are given an initial forecast for year 1,

please help with the wrong answers
please help with the wrong answers b. Using the
please help with the wrong answers b. Using the
b. Using the same data, forecast demand using exponential smoothing. You are given an initial forecast for year 1, quarter 1 of 17. When generating your forecasts, assume that the smoothing coefficient is 0.10. (Leave no cells blank - be certain to enter "0" wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to 1 decimal place. Then, starting with quarter 1 of year 2, use these rounded forecast values to compute the error and absolute error answers, Enter those answers to 1 decimal place also.) Year Quarter Year 1 04 Year 2 288928892889 Answer is complete but not entirely correct. Absolute Demand Exponential Smoothing Error Value Error 14 17.0 (3.0) 3.0 3 20 16.7 3.33 33% 20 170 3.03 3.0 20 173 2.73 2.763 19 17.6 1.4 1.4 22 17.7 4.3 43 18 18.2 (0:2) 02 18 18.1 (0.1) 0.1 21 18.1 2.9 2.9 22 18.4 3.6 3.6 28 18.8 9.2 92 32 19.7 123 123 Q3 K&NBN 888 Year 3 Year 4 Q1 36 20.9 15.1 15.1 30 22.4 7.6 7.6 Q2 Q3 36 23.2 12.8 12.8 Q4 38 24.5 13.5 13.5 Year 5 Q1 44 25.8 18.2 18.2 Q2 36 27.6 8.4 8.4 . Q3 60 28.5 31.5 31.5 Q4 58 31.6 26.4 26.4 Year 6 Q1 69 34.3 34.7 34.7 62 37.7 24.3 24.3 Q2 Q3 Q4 40.2 22.8 22.8 63 60 42.5 17.5 17.5 Year 7 Q1 61 44.2 16.8 16.8 Q2 70 24.1 45.9 48.3 Q3 69 24.1 20.7 24.6 20.7 Q4 75 50.4 24.6 Year 8 Q1 67 52.8 14.2 14.2 X Q2 75 54.2 x 72 56.3 X Q3 Q4 20.8 x 15.7 X 16.1 x 13.3 X 20.8 x 15.7 x 16.1 x 13.5 X 74 57.9 X MFE MAD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!