2. Simple moving average using Excel: Calculate demand forecast for weeks 6-20 using 5 week simple moving average. Calculate demand forecast for weeks 10-20 using 9 week simple moving average. Plot the two simple moving average forecasts together with the actual demand. Comment on the obtained graph. Using the forecasting error measures seen in class, evaluate the forecasting error of each method. Accordingly which method is better? 2.1 2.2 2.3 2.4
2. Simple moving average using Excel: Calculate demand forecast for weeks 6-20 using 5 week simple moving average. Calculate demand forecast for weeks 10-20 using 9 week simple moving average. Plot the two simple moving average forecasts together with the actual demand. Comment on the obtained graph. Using the forecasting error measures seen in class, evaluate the forecasting error of each method. Accordingly which method is better? 2.1 2.2 2.3 2.4
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
Related questions
Question
![Forecasting assienment
A clothing company wants to forecast the demand for its main product, based on the data below.
Week Sales
1
7800
7725
3
4
7500
8550
9000
5
8925
17
8
14063
15075
9
10
11
12
17670
17442
18468
18354
13
18126
14
22040
15
16
17
30800
29568
30184
18
31108
19
20
32032
31416
Management would like you to experiment with different forecasting methods, using Excel, to determine
which forecasting method to be implemented.
2. Simple moving average using Excel:
2.1
2.2
Calculate demand forecast for weeks 6-20 using 5 week simple moving average.
Calculate demand forecast for weeks 10-20 using 9 week simple moving average.
Plot the two simple moving
on the obtained graph.
Using the forecasting error measures seen in class, evaluate the forecasting error of each
method. Accordingly which method is better?
2.3
age forecasts together with the actual demand. Comment
2.4](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F99b2eb41-7dc4-4350-b7d6-db30dd2c8eb9%2Fd11dad96-28e4-4694-aeaf-c3dbe0a009a8%2Fq4vibdn_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Forecasting assienment
A clothing company wants to forecast the demand for its main product, based on the data below.
Week Sales
1
7800
7725
3
4
7500
8550
9000
5
8925
17
8
14063
15075
9
10
11
12
17670
17442
18468
18354
13
18126
14
22040
15
16
17
30800
29568
30184
18
31108
19
20
32032
31416
Management would like you to experiment with different forecasting methods, using Excel, to determine
which forecasting method to be implemented.
2. Simple moving average using Excel:
2.1
2.2
Calculate demand forecast for weeks 6-20 using 5 week simple moving average.
Calculate demand forecast for weeks 10-20 using 9 week simple moving average.
Plot the two simple moving
on the obtained graph.
Using the forecasting error measures seen in class, evaluate the forecasting error of each
method. Accordingly which method is better?
2.3
age forecasts together with the actual demand. Comment
2.4
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 5 steps with 7 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