An additive Holt-Winters forecast is being performed on accounting industry revenue data. Revenue Date Time (Sbillions) be St Forecast Q1-2012 38.5 31,861 0.188 6.752 Q2-2012 34.5 32.591 0.603 1.857 Q3-2012 29.0 33.182 0.594 4.180 94-2012 8. 29.5 33,876 0.671 4.386 Q1-2013 6. 39.3 32.848 0.630 6.616 Q2-2013 10 35.2 1.933 The number that would go in this cell is what you're looking for for the final answer. Q3-2013 1 Using a 0.85. 8-0.77, and y- 0 45. find a Hoit-Winters forecast for 2013-Q3. Hint: you only need to calculate the quantities indicated by the que with the correct seasonal index. You don't have to calculate any seasonal indexes. 6.

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...
icon
Related questions
Question
8
An additive Holt-Winters forecast is being performed on accounting industry revenue data.
Revenue
(Sbillions)
Date
Time
It
bt
St
Forecast
Q1-2012
38.5
31.861
0.188
6.752
Q2-2012
6.
34.5
32.591
0.603
1.857
Q3-2012
7.
29.0
33.182
0.594
4.180
Q4-2012
8
29.5
33.876
0.671
4.386
Q1-2013
39.3
32.848
0.630
6.616
Q2-2013
10
35.2
1.933
The number that
would go in this cell
is what you're
looking for for the
final answer.
Q3-2013
11
Using a 0.85,B-0.77, and y -045. find a Hoit-Winters forecast for 2013-Q3. Hint: you only need to calculate the quantities indicated by the que
with the correct seasonal index. You don't have to calculate any seasonal indexes.
A Koing to another question will save this response
O
Transcribed Image Text:An additive Holt-Winters forecast is being performed on accounting industry revenue data. Revenue (Sbillions) Date Time It bt St Forecast Q1-2012 38.5 31.861 0.188 6.752 Q2-2012 6. 34.5 32.591 0.603 1.857 Q3-2012 7. 29.0 33.182 0.594 4.180 Q4-2012 8 29.5 33.876 0.671 4.386 Q1-2013 39.3 32.848 0.630 6.616 Q2-2013 10 35.2 1.933 The number that would go in this cell is what you're looking for for the final answer. Q3-2013 11 Using a 0.85,B-0.77, and y -045. find a Hoit-Winters forecast for 2013-Q3. Hint: you only need to calculate the quantities indicated by the que with the correct seasonal index. You don't have to calculate any seasonal indexes. A Koing to another question will save this response O
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.