Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets for the month of August are Week 1 250 Week 2 350 Week 3 550 Week 4 650 a. Using a three-week moving average, what would you forecast the next week to be? b. Using exponential smoothing with α = 0.30, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(250 + 350)/2 = 300], what would you forecast week 5 to be?
Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets for the month of August are Week 1 250 Week 2 350 Week 3 550 Week 4 650 a. Using a three-week moving average, what would you forecast the next week to be? b. Using exponential smoothing with α = 0.30, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(250 + 350)/2 = 300], what would you forecast week 5 to be?
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...
Related questions
Question
Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to
Week 1 | 250 |
Week 2 | 350 |
Week 3 | 550 |
Week 4 | 650 |
a. Using a three-week moving average, what would you forecast the next week to be?
b. Using exponential smoothing with α = 0.30, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(250 + 350)/2 = 300], what would you forecast week 5 to be?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing