Question: Use the information below for the multiple choice questions Q1-Q3 For this problem, you will need to develop three types of forecasts and answer the

 Use the information below for the multiple choice questions Q1-Q3 For
this problem, you will need to develop three types of forecasts and
answer the questions: 1. Simple moving average (use four months) : e.g.,

Use the information below for the multiple choice questions Q1-Q3 For this problem, you will need to develop three types of forecasts and answer the questions: 1. Simple moving average (use four months) : e.g., to calculate forecast for Jan 2021, you use the four-period actual demand between Sep 2019 and Dec 2019; to calculate forecast for Feb 2021, you use the four-period actual demand between Oct 2019 and Jan 2020. 2. Weighted moving average (four-period with weights (0.5,0.25,0.15,0.10) ) where 0.5 is the weight for the most recent period and 0.1 is the weight for the most remote period. The relative time periods used are similar to the examples used in simple moving average. 3. Exponential smoothing with alpha =0.4, Jan forecast of 2020( LL1 =6,000 cases; e.g., to calculate forecast for Feb 2021, you use the actual demand of Jan 2020 and forecast of Jan 2020. Question 1 Which method produces the best MAPE? Simple moving average Weighted moving average Exponential smoothing Question 2 Which method produces the worst rMSE? Weighted moving average Simple moving average Exponential smoothing Which method produces the largest bias? Weighted moving average Simple moving average Exponential smoothing

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!