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 January 10 1 February 12 2 March 13 3 April 16 12.17 3.83 3.83 14.69 May 19 14.33 4.67 4.67 21.78 June 23 17.00 6.00 6.00 36.00 July 26 20.50 5.50 5.50 30.25 August 30 23.83 6.17 6.17 38.03 September 28 27.50 0.50 0.50 0.25 October 18 28.33 -10.33 10.33 106.78 November 16 23.33 -7.33 7.33 53.78 December 14 18.67 -4.67 4.67 21.78
Background image of page 1

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

View Full DocumentRight 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

Page1 / 2

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

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online