Question: Using the provided data set, compute the Nave, Two-period Moving Average, Three- period Moving Average, Two-period Weighted Moving Average with weights (0.6, 0.4), Three- period

Using the provided data set, compute the Nave, Two-period Moving Average, Three- period Moving Average, Two-period Weighted Moving Average with weights (0.6, 0.4), Three- period Weighted Moving Average with weights (0.5, 0.3, 0.2), Linear Trend, and Exponential Smoothing with alpha=0.4 and alpha=0.8 forecasts for sales.

MM-YY Period Sales
t St
Jul-09 1 3,924
Aug-09 2 2,619
Sep-09 3 6,920
Oct-09 4 5,676
Nov-09 5 8,348
Dec-09 6 6,044
Jan-10 7 6,877
Feb-10 8 6,535
Mar-10 9 6,395
Apr-10 10 6,684
May-10 11 5,414
Jun-10 12 3,180
Jul-10 13 4,350
Aug-10 14 3,175
Sep-10 15 6,935
Oct-10 16 6,356
Nov-10 17 8,919
Dec-10 18 7,146
Jan-11 19 7,763
Feb-11 20 7,397
Mar-11 21 7,286
Apr-11 22 7,498
May-11 23 6,386
Jun-11 24 4,209
Jul-11 25 4,825
Aug-11 26 3,764
Sep-11 27 7,066
Oct-11 28 7,015
Nov-11 29 9,535
Dec-11 30 8,278
Jan-12 31 8,773
Feb-12 32 8,393
Mar-12 33 8,288
Apr-12 34 8,432
May-12 35 7,455
Jun-12 36 5,346

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!