Stats Solutions

(Step-by-Step) Using the following data, calculate a 3 period weighted moving average forecast the next period, optimizing the 3 period weights, minimizing

Question: Using the following data, calculate a 3 period weighted moving average forecast the next period, optimizing the 3 period weights, minimizing the standard error, using Solver :

Period Demand Period Demand
1 8,114 11 8,459
2 8,215 12 8,487
3 8,222 13 8,499
4 8,014 14 8,501
5 8,055 15 8,525
6 8,212 16 8,569
7 8,134 17 8,610
8 8,357 18 8,657
9 8,350 19 8,701
10 8,369 20 8,756
  1. Calculate forecasted demand for the period 21.
  2. What weights did you calculate for period t-1, period t-2 and period t-3?
  3. Comment on the forecast error.

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in