A large Portland manufacturing would like to forecast the monthly demand for a piece of pollutioncontrol equipment. Suppose the monthly sales figures for the past five months have been as follows: Month 1 2 3 4 5 Actual Demand 14 17 20 21 25 a. Make a forecast for 6th month using a three-period moving average (MA). What would be the forecast for 6th month? b. The manager would like to use simple expo

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...
icon
Related questions
Question

3. A large Portland manufacturing would like to forecast the monthly demand for a piece of pollutioncontrol equipment. Suppose the monthly sales figures for the past five months have been as follows:
Month 1 2 3 4 5
Actual Demand 14 17 20 21 25
a. Make a forecast for 6th month using a three-period moving average (MA). What would be the forecast
for 6th month?
b. The manager would like to use simple exponential smoothing to forecast. Use alpha = 0.25. What
would be the forecast for 6th month?
c. Find the better forecast out of Moving Average and Simple Exponential Smoothing

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Knowledge Booster
Forecasting methods
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing