Question: please help it is really confusing 1 . Calculate a forecast using a simple three - month moving average. 2 . Calculate a forecast using

please help it is really confusing
1. Calculate a forecast using a simple three-month moving average.
2.Calculate a forecast using a three-period weighted moving average. Use weights of
0.60,0.30, and 0.10 for the most recent period, the second most recent period, and the third most recent period, respectively.
3. Calculate a forecast using the exponential smoothing method. Assume the forecast
for period 1 is 9,500. Use alpha =0.40.
4. Once you have calculated the forecasts based on the above data, determine the error terms by comparing them to the actual sales for 2020 given below:
CASE QUESTIONS
Calculate a forecast using a simple three-month moving average.
Calculate a forecast using a three-period weighted moving average. Use weights of
0.60,0.30, and 0.10 for the most recent period, the second most recent period, and
the third most recent period, respectively.
Calculate a forecast using the exponential smoothing method. Assume the forecast
for period 1 is 9,500. Use alpha =0.40.
Once you have calculated the forecasts based on the above data, determine the error
terms by comparing them to the actual sales for 2020 given below:
Based on the three methods used to calculate a forecast for TFY, which method
produced the best forecast? Why? What measures of forecast error did you use?
How could you improve upon this forecast?
 please help it is really confusing 1. Calculate a forecast using

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!