Let's say you are playing the stock market and below period 2020 data was provided. For "stock A" you use a 2 month movingaverage. For "stock B" you use exponential smoothing with (a = 0.3).What is the Forecast in Stock B for January 2021?Stock AStock B...Jan0.11Jan14Feb0.20Feb11Mar0.03MarAprMay1.20AprMay6.0.509Jun0.03Jun12Jul0.10Jul16Aug0.11AugSep14Sep0.568Oct0.78OctNov0.44Nov4Dec0.10Dec

Answered: Let's say you are playing the stock…

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

Similar questions

Hi, I need help with solving for the following values (boxed). Thank you.
If month one has 240,000 demands, month two 250,080 demands, month three 325,00 demands, month four 370,000 demands, month five 420,000 demands and month six 509,00 demands. Use a forecast for the first month of 240,000, an initial trend forecast of 50,000, and smoothing parameters of 0.35 for both demand smoothing and trend smoothing. Compute the forecasts and trends using double exponential smoothing
Income at the law firm of Smith and Jones for the period February to July was as follows: Month February March April May June July Income (in $ thousand) 90.0 91.5 96.0 85.4 92.2 96.0 Assume that the initial forecast for February is $85,000 and the initial trend adjustment is 0. The smoothing constants selected are a = 0.1 and ß = 0.2. Using trend-adjusted exponential smoothing, the forecast for the law firm's August income =O thousand dollars (round your response to two decimal places).
Using the photo uploaded, answer the following 1. Using a numerical example, demonstrate to Mr. John how he can use the manual trend projection method of forecasting to forecast demand for the next two years.
A forecast is usually classified by the future time horizon that it covers. True or false? Describe the three categories of time horizon?
In a retail store, the actual sales of a particular product (in thousands of units) over the past few months are as follows: Month Sales 1 16 2 22 3 18 4 20 5 23 Using exponential smoothing method with α (smoothing constant) of 0.75 and the given forecast for month 1 equal to 10, what is the forecast for month 6?
You have the data on the application during the 8 consecutive year period below Wanted / Find the forecast demand for the year 2008 using the simple moving average method and on a 4-period basis the years 2000 2001 2002 2003 2004 2005 2006 2007 2008 Order quantity 24 48 50 68 60 66 70 90
Forecast sales for the 11th period. For leveling, use exponential smoothing 0.20 and moving average 3 for averaging; and linear and exponential functions for trend data. Assume an initial exponential forecast of 60 units in period 2 if you decide to use it (i.e., no forecast for period 1). Period 1 2 3 4 5 6 7 8 9 10 Sales 748 690 731 869 845 956 1200 1062 1090 1200
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances 3 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herex
If the weights for a moving average forecast with a span of 4 are: 0.3,0.2,0.2,0.4 Problem: Under prediction Problem: Over prediction No problem
please answer in 30 minutes.
The manager of a travel agency asked you to come up with a forecasting technique that will best fit to the actual demand for packaged tours. You have observed and recorded the actual demand for the last 10 periods. You also identified two possible techniques for consideration: 2-month moving averages (F1), and exponential smoothing (F2) with a smoothing constant of 0.25. Using Cumulative Forecasting Error (CFE) and Mean Absolute Deviation (MAD) as your performance measures you will determine the technique that will best fit to the actual demand data provided in the following table.STEP 1: Given start forecast values in period 3, compute forecast values from period 4 to 10. You are asked to provide the forecast values for period 6 and 10 for both techniques. 2-Month MA Exponential Period Demand F1 F2 1 115 -- -- 2 176 -- -- 3 97 146 129 4 141 5 98 6 132 7 114 8 129 9 107…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Let's say you are playing the stock market and below period 2020 data was provided. For "stock A" you use a 2 month moving average. For "stock B" you use exponential smoothing with (a = 0.3). What is the Forecast in Stock B for January 2021?