The monthly sales for Yazici Batteries, Inc., were as follows:| Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec ||-------|-----|-----|-----|-----|-----|-----|-----|-----|------|-----|-----|-----|| Sales | 20 | 21 | 16 | 14 | 11 | 16 | 17 | 19 | 22 | 20 | 20 | 24 |**This exercise contains only parts b and c.**b) The forecast for the next month (Jan) using the naive method = [ ] sales (round your response to a whole number).The forecast for the next period (Jan) using a 3-month moving average approach = [ ] sales (round your response to two decimal places).The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.10, 0.20, 0.30, where the heaviest weights are applied to the most recent month = [ ] sales (round your response to one decimal place).Using exponential smoothing with α = 0.30 and a September forecast of 18.00, the forecast for the next period (Jan) = [ ] sales (round your response to two decimal places).Using a method of trend projection, the forecast for the next month (Jan) = [ ] sales (round your response to two decimal places).c) The method that can be used for making a forecast for the month of March is [ ].(Note: The exercise contains placeholders for calculated responses that students need to fill in based on provided methods and formulas.)

Answered: b) The forecast for the next month…

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

please answer within 30 minutes.
The following data are for calculator sales in units at an electronics store over the past nine weeks: Week Sales Week Sales 1 45 6. 53 2 50 7 59 3 44 59 4 51 9 64 5 57 Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, G. MAD, and MAPE) for this forecasting procedure? How about ? Obtain the trend projection with regression forecast for weeks 10 - 13. (Enter your responses rounded to two decimal places.) Period Forecast, F, 10 11 12 13
a) Using the trend-projection (regression) method, develop a forecastfor the sales of Volkswagen Beetles in Nevada through year 6.b) What is the MAD?~c) What is the MSE?
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
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
Stationarity in a time Series refers to A.) The size of the RMSE of a Forecasting model B) the size of Variances of the model's estimates C) a method of forecast optimization D) lack of trend in a given time Series E) None of the options are correct.
Please do not give solution in image formate thanku.
Which of the following are common metrics for measuring the relative quality of different forecasting methods? OAbsolutely Mean Mean Squared Accuracy O Mean Absolute Percent Error Mean Squared Response OMean Squared Error Mean Absolute Error (a.k.a. Mean Absolute Deviation)
Discuss the basic assumptions made when using time series forecasting techniques as apposed to casual techniques ?
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
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…
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? Stock A Stock B ... Jan 0.11 Jan 14 Feb 0.20 Feb 11 Mar 0.03 Mar Apr May 1.20 Apr May 6. 0.50 9 Jun 0.03 Jun 12 Jul 0.10 Jul 16 Aug 0.11 Aug Sep 14 Sep 0.56 8 Oct 0.78 Oct Nov 0.44 Nov 4 Dec 0.10 Dec

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