The number of component parts used in a production process each of the last 10 weeks is

Question:

The number of component parts used in a production process each of the last 10 weeks is as follows.

image


a. Use the Moving Average Excel template to develop moving average models with two, three, and four periods. Compare them using MSE to determine which is best. From the results below, the four-period forecast is the best.

b. what is the best alpha value (smoothing constant) to begin your analysis using exponential smoothing based on the results of part (a)?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Operations And Supply Chain Management

ISBN: 9780357131695

2nd Edition

Authors: David A. Collier, James R. Evans

Question Posted: