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., 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
Get step-by-step solutions from verified subject matter experts
