{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch04Ex2 - Total 4.33 49.00 323.33 Average 0.48 5.44 35.93...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CHAPTER 4: Example 2 Forecasting Weighted moving averages - 3 period moving average Data Forecasts and Error Analysis Period Demand Weights Forecast Error Absolute Squared Abs Pct Err January 10 1 February 12 2 March 13 3 April 16 12.17 3.83 3.83 14.69 23.96% May 19 14.33 4.67 4.67 21.78 24.56% June 23 17.00 6.00 6.00 36.00 26.09% July 26 20.50 5.50 5.50 30.25 21.15% August 30 23.83 6.17 6.17 38.03 20.56% September 28 27.50 0.50 0.50 0.25 01.79% October 18 28.33 -10.33 10.33 106.78 57.41% November
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Total 4.33 49.00 323.33 Average 0.48 5.44 35.93 Bias MAD MSE SE 6.80 Next period 15.33 Enter the data in the shaded area. Enter weights in INCREASING order from top to bottom. Abs Pct Err 23.96% 24.56% 26.09% 21.15% 20.56% 01.79% 57.41% 45.83% 33.33% 254.68% 28.30% MAPE 1 2 3 4 5 6 7 8 9 10 11 12 5 10 15 20 25 30 35 Forecasting Demand Forecast Time Value...
View Full Document

{[ snackBarMessage ]}