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
![gnment 1.d X
ment%202.pdf
.xlsx
HP Work & Supply Chain Marakane
Sales
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Total
-
1 / 2 -
Question 1
The monthly demand of a company is showed below, please use the static method to forecast the
demand for Year 6.
Year 1
Q Search
2,000
3,000
3,000
3,000
4,000
6,000
7,000
6,000
10,000
12,000
14,000
8,000
78,000
Catherine Caramp....pdf
Z
Year 2
140%
3,000
4,000
3,000
5,000
5,000
8,000
3,000
8,000
12,000
12,000
16,000
10,000
89,000
LDE
+ @
I
Assignment 2
Year 3
Question 2
Historical demand for Peeps is as displayed in the table.
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
T2202- 2022.pdf
0
Year 4
}})
5,000
4,000
4,000
2,000
5,000
7,000
10,000
14,000
16,000
16,000
20,000
12,000
115,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
113,000
Q☆
l
EN
US](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F330c150f-919c-4488-aa5e-47a1ac0c214a%2Fc82e1df1-21df-459a-aca0-b343390641c3%2Fulpc9ad_processed.jpeg&w=3840&q=75)
Transcribed Image Text:gnment 1.d X
ment%202.pdf
.xlsx
HP Work & Supply Chain Marakane
Sales
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Total
-
1 / 2 -
Question 1
The monthly demand of a company is showed below, please use the static method to forecast the
demand for Year 6.
Year 1
Q Search
2,000
3,000
3,000
3,000
4,000
6,000
7,000
6,000
10,000
12,000
14,000
8,000
78,000
Catherine Caramp....pdf
Z
Year 2
140%
3,000
4,000
3,000
5,000
5,000
8,000
3,000
8,000
12,000
12,000
16,000
10,000
89,000
LDE
+ @
I
Assignment 2
Year 3
Question 2
Historical demand for Peeps is as displayed in the table.
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
T2202- 2022.pdf
0
Year 4
}})
5,000
4,000
4,000
2,000
5,000
7,000
10,000
14,000
16,000
16,000
20,000
12,000
115,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
113,000
Q☆
l
EN
US
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
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](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
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