Period12345NewAccounts Period201215212229236678910NewAccounts Period2332492532542681112131415NewAccounts282276281289311 Wb. Use trend-adjusted smoothing with a .3 and B-2 to smooth the new account data. What is theforecast for period 16?

Forecasting means predicting in advance about the uncertainties of the future. One of the methods to…

Answered: b. Use trend-adjusted smoothing with a…

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

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 120 February 145 March 146 April 171 May 154 June 182 July 138 August 135 September 146 a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of 0.20 to estimate April through September, using the average of January through March as the initial forecast for April. c-1. Calculate MAD for Three-month moving average and Exponential smoothing. c-2. Use MAD to decide which method produced the better forecast over the six-month period.
Give typed explanation Part 2: Using exponential smoothing, the forecasted demand for period 5 using the smoothing constant determined in image= ?
Develop two exponential smoothing forecasts for periods 2 through 11. For the first forecast, use a=0.1. For the second, use a=0.7. Assume that your forecast for period 1 was 205. Click the icon to view the time series data. Find the exponential smoothing forecast for each period when a=0:1 (enter your responses rounded to one decimal place). Period Forecast (0.1) 205 1 2 More Info Period 1 2 3 4 5 6 7 8 9 10 Print Demand 228 249 229 238 231 154 166 157 Demand 228 249 164 161 Done
Answer this using excel on a spreads
a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) compute the forecast for the week of Oct 12 using exponential smoothing with a forecast for august 31 of 360 and alpha 0.2
Discuss the basic assumptions made when using time series forecasting techniques as apposed to casual techniques ?
Give typed full explanation not a single word hand written otherwise leave it
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 Value 17 14 15 3 (b) mean squared error MSE = % 4 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. (a) mean absolute error MAE = 5 6 (d) What is the forecast for week 7? 12 16 15 (c) mean absolute percentage error (Round your answer to two decimal places.) MAPE =
Use the following information to compute a single exponential smoothing model forecast with a smoothing constant (α = 0.30) to produce the actual demand for the period.) Use 115 as the initial forecast. Click the icon to view the demand for the previous 9 periods. Fill-in the table below for a single exponential smoothing forecast (enter your responses rounded to one decimal place). Period F(SES) 1 2 3 4 5 6 7 8 9 The forecast for period 10 is Period 1 115 117 182 23456789 133 107 96 177 176 (Enter your response rounded to one decimal place.) 144 U at 115 117 182 133 107 96 177 176 144 forecast for period 10. (Note: a, is
2
Please answer fast please arjent help please
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 Value 18 13 (a) Construct a time series plot. 20T 18 16- 14- Time Series Value O Week 1 2 3 4 5 6 What type of pattern exists in the data? O The data appear to follow a cyclical pattern. O The data appear to follow a trend pattern. 8 6 O The data appear to follow a seasonal pattern. O The data appear to follow a horizontal pattern. Week 1 2 0 1 3 4 5 6 18 13 15 12 (b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Time Series Value 16 14 18 + 2 13 15 4 5 6 15 12 16 3 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? 12 16 4 14 Week (c) Use a = 0.2 to compute the exponential smoothing values for the time series. Time Series Value 5 14 Forecast 6 Forecast 7 20 18 16 14 12 WE 10 2 + 7 @o 20 18 0 1 2 3 4 Week 5 6 00 0 1 2 3 4 5 Week 6 7…

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

b. Use trend-adjusted smoothing with a - .3 and B-.2 to smooth the new account data. What is the forecast for period 16?