The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-26, where a = 0.5 and y=0.8. Then find the MAD for periods 13-24. Click the icon to view the monthly use of natural gas data. Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26. (Type integers or decimals rounded to two decimal places as needed.) Forecast Period 13 14 15 16 17 18 ☐☐☐☐☐☐ Natural Gas Usage Month Period Gas Usage Jan 1 Feb 2 Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 3 4 5 6 PEREARRANNAN ***₪876ē§§§$**227985 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 241 221 24 155 137 54 34 30 40 90 201 136 34 34 40 X
The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-26, where a = 0.5 and y=0.8. Then find the MAD for periods 13-24. Click the icon to view the monthly use of natural gas data. Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26. (Type integers or decimals rounded to two decimal places as needed.) Forecast Period 13 14 15 16 17 18 ☐☐☐☐☐☐ Natural Gas Usage Month Period Gas Usage Jan 1 Feb 2 Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 3 4 5 6 PEREARRANNAN ***₪876ē§§§$**227985 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 241 221 24 155 137 54 34 30 40 90 201 136 34 34 40 X
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
![The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the
forecast for periods 13-26, where x = 0.5 and y = 0.8. Then find the MAD for periods 13-24.
Click the icon to view the monthly use of natural gas data.
Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26.
(Type integers or decimals rounded to two decimal places as needed.)
Forecast
Period
13
14
15
16
17
18
Natural Gas Usage
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Period Gas Usage
1
2
8699 A WI
3
4
5
7
9
10
11
12
13
14
1516718192021 22 23 24
241
221
155
137
54
34
29
27
30
40
90
201
229
238
242
136
34
34
28
26
27
40
86
187](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd4e67e73-f69c-4069-855a-d229d90c8710%2Fcf372f8a-bfe5-41c4-a1fb-84ac4243f9c6%2Fce0x1gb_processed.png&w=3840&q=75)
Transcribed Image Text:The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement the Holt-Winters multiplicative seasonality model with no trend to find the
forecast for periods 13-26, where x = 0.5 and y = 0.8. Then find the MAD for periods 13-24.
Click the icon to view the monthly use of natural gas data.
Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26.
(Type integers or decimals rounded to two decimal places as needed.)
Forecast
Period
13
14
15
16
17
18
Natural Gas Usage
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Period Gas Usage
1
2
8699 A WI
3
4
5
7
9
10
11
12
13
14
1516718192021 22 23 24
241
221
155
137
54
34
29
27
30
40
90
201
229
238
242
136
34
34
28
26
27
40
86
187
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.
Step by step
Solved in 5 steps with 11 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,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![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,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.