Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.   Part 1 a. Use​ Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3.   Complete the exponential smoothing forecast model for stock B. ​(Type integers or decimals rounded to two decimal places as​ needed.) Date Forecast B 09/03/2010   09/07/2010   09/08/2010   09/09/2010   09/10/2010   09/13/2010   09/14/2010   09/15/2010   09/16/2010   09/17/2010   09/20/2010   09/21/2010   Date    A    B    C    D    Stock Exchange 09/03/2010    128.82    18.38    21.22    15.37    10,462.55 09/07/2010    124.78    18.27    20.54    15.54    10,262.84 09/08/2010    126.03    17.86    20.68    15.77    10,351.68 09/09/2010    125.91    17.98    20.43    15.99    10,319.13 09/10/2010    126.87    17.87    20.56    15.84    10,421.86 09/13/2010    128.66    18.47    21.45    16.23    10,502.87 09/14/2010    128.53    18.59    21.56    16.32    10,463.49 09/15/2010    128.92    18.64    21.75    16.43    10,654.59 09/16/2010    128.71    19.14    21.91    16.37    10,531.53 09/17/2010    129.71    18.69    21.65    16.17    10,709.94 09/20/2010    131.65    18.79    21.67    16.41    10,800.02 09/21/2010    132.27    19.02    21.62    16.63    10,680.45

Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.   Part 1 a. Use​ Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3.   Complete the exponential smoothing forecast model for stock B. ​(Type integers or decimals rounded to two decimal places as​ needed.) Date Forecast B 09/03/2010   09/07/2010   09/08/2010   09/09/2010   09/10/2010   09/13/2010   09/14/2010   09/15/2010   09/16/2010   09/17/2010   09/20/2010   09/21/2010   Date    A    B    C    D    Stock Exchange 09/03/2010    128.82    18.38    21.22    15.37    10,462.55 09/07/2010    124.78    18.27    20.54    15.54    10,262.84 09/08/2010    126.03    17.86    20.68    15.77    10,351.68 09/09/2010    125.91    17.98    20.43    15.99    10,319.13 09/10/2010    126.87    17.87    20.56    15.84    10,421.86 09/13/2010    128.66    18.47    21.45    16.23    10,502.87 09/14/2010    128.53    18.59    21.56    16.32    10,463.49 09/15/2010    128.92    18.64    21.75    16.43    10,654.59 09/16/2010    128.71    19.14    21.91    16.37    10,531.53 09/17/2010    129.71    18.69    21.65    16.17    10,709.94 09/20/2010    131.65    18.79    21.67    16.41    10,800.02 09/21/2010    132.27    19.02    21.62    16.63    10,680.45

Practical Management Science
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...
See similar textbooks
icon
Related questions
Question
 

 

Part 1
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
 
Part 1
a. Use​ Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of
0.3.
 
Complete the exponential smoothing forecast model for stock B.
​(Type integers or decimals rounded to two decimal places as​ needed.)
Date
Forecast B
09/03/2010
 
09/07/2010
  
09/08/2010
  
09/09/2010
  
09/10/2010
  
09/13/2010
  
09/14/2010
  
09/15/2010
  
09/16/2010
  
09/17/2010
  
09/20/2010
  
09/21/2010
  
Date    A    B    C    D    Stock Exchange
09/03/2010    128.82    18.38    21.22    15.37    10,462.55
09/07/2010    124.78    18.27    20.54    15.54    10,262.84
09/08/2010    126.03    17.86    20.68    15.77    10,351.68
09/09/2010    125.91    17.98    20.43    15.99    10,319.13
09/10/2010    126.87    17.87    20.56    15.84    10,421.86
09/13/2010    128.66    18.47    21.45    16.23    10,502.87
09/14/2010    128.53    18.59    21.56    16.32    10,463.49
09/15/2010    128.92    18.64    21.75    16.43    10,654.59
09/16/2010    128.71    19.14    21.91    16.37    10,531.53
09/17/2010    129.71    18.69    21.65    16.17    10,709.94
09/20/2010    131.65    18.79    21.67    16.41    10,800.02
09/21/2010    132.27    19.02    21.62    16.63    10,680.45
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE 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.
SEE MORE TEXTBOOKS