Question: Based on the table below, develop a two - period weighted moving average forecast with a weight of 0 . 6 5 for the most

Based on the table below, develop a two-period weighted moving average forecast with a weight of
0.65 for the most recent day and 0.35 for the next most recent day for each appropriate period until
period 13. Show work. (5 pts)
b) Based on the table below, develop a four-period moving average forecast for each appropriate period
until period 13. Show work. (5 pts)
c) Based on the table below, develop an exponential smoothing forecast with a smoothing coefficient of
0.26 and a starting forecast value at period 2 of 168(i.e.,2=168). Create the forecast for each
appropriate period until period 13. Show work. (5 pts)
d) For each forecast (two-period weighted moving average, 4-period moving average, and exponential
smoothing), calculate the mean squared error. Show work. (10 pts)
2-period WMA MSE =2252.2

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!