Question: Use the data set below to answer the questions that follow. Show your work Period Demand Sales Volume 1 1000 2 1200 3 1450 4
Use the data set below to answer the questions that follow. Show your work
Period Demand Sales Volume
1 1000
2 1200
3 1450
4 1700
5 1850
6 1950
a. Find the four-period simple moving average forecasts for Periods 5 and 6.
b. Find the four-period weighted moving average forecasts for Periods 5 and 6 using weights of 0.05, 0.25, 0.30, and 0.40 from the earliest period to the latest period, respectively.
c. Which set of forecasts is more accurate, the simple moving average forecasts or the weighted moving average forecasts? Why is that set of forecasts more accurate in this particular case?
d. Will that type of forecast always be more accurate? Why or why not?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
