11-3 - Period Actual value Weights Forecast Error Month 1...

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

View Full Document Right Arrow Icon
Wallace Garden Supply Forecasting 3 period weighted moving average Input Data Forecast Error Analysis Period Actual value Weights Forecast Error Month 1 10 1 Month 2 12 2 Month 3 16 3 Month 4 13 13.667 -0.667 0.667 0.444 5.13% Month 5 17 13.833 3.167 3.167 10.028 18.63% Month 6 19 15.500 3.500 3.500 12.250 18.42% Month 7 15 17.333 -2.333 2.333 5.444 15.56% Month 8 20 16.667 3.333 3.333 11.111 16.67% Month 9 22 18.167 3.833 3.833 14.694 17.42% Month 10 19 20.167 -1.167 1.167 1.361 6.14% Month 11 21 20.167 0.833 0.833 0.694 3.97% Month 12 19 20.500 -1.500 1.500 2.250 7.89% Average 2.259 6.475 12.20% Next period 19.667 MAD MSE MAPE 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 3 period weighted moving average Actual value Forecast Time Value
Background image of page 2
Wallace Garden Supply Forecasting 3 period weighted moving average 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 Weights Forecast Error Month 1 10 0.2218 Month 2 12 0.5927 Month 3 16 0.1855 Month 4 13 12.298 0.702 0.702 0.492 5.40% Month 5 17 14.556 2.444 2.444 5.971 14.37% Month 6 19 14.407 4.593 4.593 21.093 24.17% Month 7 15 16.484 -1.484 1.484 2.202 9.89% Month 8 20 17.814 2.186 2.186 4.776 10.93% Month 9 22 16.815 5.185 5.185 26.889 23.57% Month 10 19 19.262 -0.262 0.262 0.069 1.38% Month 11 21 21.000 0.000 0.000 0.000 0.00% Month 12 19 20.036 -1.036 1.036 1.074 5.45% Average 1.988 6.952 10.57% Next period 20.185 MAD MSE MAPE Sum of weights = 1.000 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-3 - Period Actual value Weights Forecast Error Month 1...

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