The historical demand for the Panasonic Model 304 Pencil Sharpener is: January, 80; February, 100; March, 60;

Question:

The historical demand for the Panasonic Model 304 Pencil Sharpener is: January, 80; February, 100; March, 60; April, 80; and May, 90 units.

a. Using a four-month moving average and the Moving Average Excel template, what is the forecast for June?

b. Develop a linear regression model using Excel and compute a forecast for June, July, and August.

c. The regression trend line is flat with a slope of 0, so the regression is not statistically significant. The forecast for each month would simply be 82. This is not the appropriate model to use. A good problem to discuss with students the statistical significance of a simple regression model.

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

Step by Step Answer:

Related Book For  book-img-for-question

Operations And Supply Chain Management

ISBN: 9780357131695

2nd Edition

Authors: David A. Collier, James R. Evans

Question Posted: