Question: Please help me with questions 4-6 actual forecast demand error 215 210 220 225 20 2019 3Q 2019 40 2019 1Q 2020 20 2020 3Q

Please help me with questions 4-6

Please help me with questions 4-6 actual forecast

actual forecast demand error 215 210 220 225 20 2019 3Q 2019 40 2019 1Q 2020 20 2020 3Q 2020 4Q 2020 1Q 2021 20 2021 260 240 260 270 1. Using the 4 quarter moving average: What is the forecast for 3Q 2020, 4Q 2020, 10 2021, and 2Q 2021 2. Compute the forecast for 3Q 2020, 4Q 2020, 1Q 2021, and 2Q 2021 using exponential smoothing (start with 2Q 2020) with a smoothing factor of .6. 3. Which forecast method provides a more accurate forecast? 4. Compute the forecast for 3Q 2020, 4Q 2020, 1Q 2021, and 2Q 2021 using a weighted moving average technique. The most recent period (for 3Q 2020 that will be 2Q 2020) is weighted at .5, second most recent at .35, and 3rd most recent at .10 and 4th most recent at .05. 5. Compare the results from 4 to results from 1 and 2. Now which forecast provides the more accurate forecast? 6. If the exponential smoothing is calculated using a smoothing factor of 8 will the forecast error be smaller or larger

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!