11-2 - 20.667-1.667 1.667 2.778 8.77 Average 2.000 6.074...

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

View Full Document Right Arrow Icon
Wallace Garden Supply Forecasting 3 period moving average Input Data Forecast Error Analysis Period Forecast Error Month 1 10 Month 2 12 Month 3 16 Month 4 13 12.667 0.333 0.333 0.111 2.56% Month 5 17 13.667 3.333 3.333 11.111 19.61% Month 6 19 15.333 3.667 3.667 13.444 19.30% Month 7 15 16.333 -1.333 1.333 1.778 8.89% Month 8 20 17.000 3.000 3.000 9.000 15.00% Month 9 22 18.000 4.000 4.000 16.000 18.18% Month 10 19 19.000 0.000 0.000 0.000 0.00% Month 11 21 20.333 0.667 0.667 0.444 3.17%
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: Month 12 19 20.667 -1.667 1.667 2.778 8.77% Average 2.000 6.074 10.61% Next period 19.667 MAD MSE MAPE Actual Value Absolute error Squared error Absolute % error Enter the data in the cells shaded YELLOW. Enter the data in the cells shaded YELLOW. 1 2 3 4 5 6 7 8 9 10 11 12 5 10 15 20 25 3 period moving average Actual Value Forecast Time Value...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

11-2 - 20.667-1.667 1.667 2.778 8.77 Average 2.000 6.074...

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