Using the following demand data: Month 1 2 3 4 Demand 108 116 118 124 1. Compute a 2-month moving average forecast for months 3 through 5. 2. Compute a weighted 2-month moving average forecast for months 3 through 5. Assign weights of 0.70 and 0.30 to the more recent and more distant data respectively. 3. Compute an exponentially smoothed forecast for periods 3 through 5 using an a value of 0.25. Assume that the first period's forecast is the same as its demand. 4. Compare the three forecasting methods using MAD. Which method is more accurate? Provide details answers on how to get to your results, using excel with formulas

Transcribed Image Text:

Using the following demand data: Month Demand 108 1 2 3 4 116 118 124 1. Compute a 2-month moving average forecast for months 3 through 5. 2. Compute a weighted 2-month moving average forecast for months 3 through 5. Assign weights of 0.70 and 0.30 to the more recent and more distant data respectively. 3. Compute an exponentially smoothed forecast for periods 3 through 5 using an a value of 0.25. Assume that the first period's forecast is the same as its demand. 4. Compare the three forecasting methods using MAD. Which method is more accurate? Provide details answers on how to get to your results, using excel with formulas. Using the following demand data: Month Demand 108 1 2 3 4 116 118 124 1. Compute a 2-month moving average forecast for months 3 through 5. 2. Compute a weighted 2-month moving average forecast for months 3 through 5. Assign weights of 0.70 and 0.30 to the more recent and more distant data respectively. 3. Compute an exponentially smoothed forecast for periods 3 through 5 using an a value of 0.25. Assume that the first period's forecast is the same as its demand. 4. Compare the three forecasting methods using MAD. Which method is more accurate? Provide details answers on how to get to your results, using excel with formulas.