11-4 - Period Actual value Forecast Error Month 1 10 10.000...

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

View Full Document Right Arrow Icon
Wallace Garden Supply Forecasting Exponential smoothing Input Data Forecast Error Analysis Period Actual value Forecast Error Month 1 10 10.000 Month 2 12 10.000 2.000 2.000 4.000 16.67% Month 3 16 10.200 5.800 5.800 33.640 36.25% Month 4 13 10.780 2.220 2.220 4.928 17.08% Month 5 17 11.002 5.998 5.998 35.976 35.28% Month 6 19 11.602 7.398 7.398 54.733 38.94% Month 7 15 12.342 2.658 2.658 7.067 17.72% Month 8 20 12.607 7.393 7.393 54.650 36.96% Month 9 22 13.347 8.653 8.653 74.879 39.33% Month 10 19 14.212 4.788 4.788 22.925 25.20% Month 11 21 14.691 6.309 6.309 39.806 30.04% Month 12 19 15.322 3.678 3.678 13.529 19.36% Average 5.172 31.467 28.44% Alpha 0.1 MAD MSE MAPE Next period 15.690 Absolute error Squared error Absolute % error Enter the data in the cells shaded YELLOW. Enter the data in the cells shaded YELLOW.
Background image of page 1

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

View Full DocumentRight Arrow Icon
1 2 3 4 5 6 7 8 9 10 11 12 0 5 10 15 20 25 Exponential smoothing Actual value Forecast Time Value
Background image of page 2
Wallace Garden Supply Forecasting Exponential smoothing Input Data Forecast Error Analysis
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Period Actual value Forecast Error Month 1 10 10.000 Month 2 12 10.000 2.000 2.000 4.000 16.67% Month 3 16 10.838 5.162 5.162 26.649 32.26% Month 4 13 13.000 0.000 0.000 0.000 0.00% Month 5 17 13.000 4.000 4.000 16.000 23.53% Month 6 19 14.675 4.325 4.325 18.702 22.76% Month 7 15 16.487 -1.487 1.487 2.211 9.91% Month 8 20 15.864 4.136 4.136 17.106 20.68% Month 9 22 17.596 4.404 4.404 19.391 20.02% Month 10 19 19.441 -0.441 0.441 0.194 2.32% Month 11 21 19.256 1.744 1.744 3.041 8.30% Month 12 19 19.987 -0.987 0.987 0.973 5.19% Average 2.608 9.842 14.70% Alpha 0.419 MAD MSE MAPE Next period 19.573 Absolute error Squared error Absolute % error Enter the data in the cells shaded YELLOW. Enter the data in the cells shaded YELLOW....
View Full Document

Page1 / 3

11-4 - Period Actual value Forecast Error Month 1 10 10.000...

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

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