Question 1 The monthly demand of a company is showed below, please use the static method to forecast demand for Year 6. Sales JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total Year 1 Year 2 3,000 4,000 3,000 5,000 5,000 8,000 3,000 8,000 Assignment 2 2,000 3,000 3,000 3,000 4,000 6,000 7,000 6,000 10,000 12,000 12,000 12,000 14,000 16,000 8,000 10,000 78,000 89,000 Year 3 2,000 5,000 5,000 3,000 4,000 6,000 7,000 10,000 15,000 15,000 18,000 8,000 98,000 Year 4 5,000 4,000 4,000 2,000 5,000 7,000 10,000 14,000 Year 5 5,000 2,000 3,000 2,000 7,000 6,000 8,000 10,000 20,000 20,000 22,000 8,000 16,000 16,000 20,000 12,000 115,000 113,000
Question 1 The monthly demand of a company is showed below, please use the static method to forecast demand for Year 6. Sales JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total Year 1 Year 2 3,000 4,000 3,000 5,000 5,000 8,000 3,000 8,000 Assignment 2 2,000 3,000 3,000 3,000 4,000 6,000 7,000 6,000 10,000 12,000 12,000 12,000 14,000 16,000 8,000 10,000 78,000 89,000 Year 3 2,000 5,000 5,000 3,000 4,000 6,000 7,000 10,000 15,000 15,000 18,000 8,000 98,000 Year 4 5,000 4,000 4,000 2,000 5,000 7,000 10,000 14,000 Year 5 5,000 2,000 3,000 2,000 7,000 6,000 8,000 10,000 20,000 20,000 22,000 8,000 16,000 16,000 20,000 12,000 115,000 113,000
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
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 with 3 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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