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:
a Using a fourmonth moving average To calculate the forecast for June using a fourmonth moving average we take the average of the historical demand fo...View the full answer
Answered By
User l_917591
As a Business Management graduate from Moi University, I had the opportunity to work as a tutor for undergraduate students in the same field. This experience allowed me to apply the theoretical knowledge I had gained in a practical setting, while also honing my teaching and communication skills.
As a tutor, I was responsible for conducting tutorial sessions, grading assignments and exams, and providing feedback and support to my students. I also assisted with the preparation of course materials and collaborated with other tutors and professors to ensure consistency in teaching and assessment.
0 Reviews
10+ Question Solved
Related Book For 
Operations And Supply Chain Management
ISBN: 9780357131695
2nd Edition
Authors: David A. Collier, James R. Evans
Question Posted:
