Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Below you are given the first five values of a quarterly time series of sales. Year Time Series Value Y, 36 Quarter 24 3 16 4 20 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2. а. 20 b. 27 d. 44 с. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is the forecast on the sales in Quarter 2 of Year 2. 20.5 b. 44.3 26.7 a. с. d. 30.2 23. Refer to data in Q21. When a three-quarter weighted moving average (W1=0.5, W2 0.3, and W3 0.2) is used, what is the forecast on the sales in Quarter 2 of Year 2. (Hint: F1+1 =W1D;+ W2D+ W3D) 24.4 30.2 22.8 d. a. b. с. 31.2

Below you are given the first five values of a quarterly time series of sales. Year Time Series Value Y, 36 Quarter 24 3 16 4 20 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2. а. 20 b. 27 d. 44 с. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is the forecast on the sales in Quarter 2 of Year 2. 20.5 b. 44.3 26.7 a. с. d. 30.2 23. Refer to data in Q21. When a three-quarter weighted moving average (W1=0.5, W2 0.3, and W3 0.2) is used, what is the forecast on the sales in Quarter 2 of Year 2. (Hint: F1+1 =W1D;+ W2D+ W3D) 24.4 30.2 22.8 d. a. b. с. 31.2

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

Q23

Below you are given the first five values of a quarterly time series of sales. Year Time Series Value Y, 36 Quarter 1 24 3 16 4 20 2 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2, a. 20 b. 44 с. 27 d. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is the forecast on the sales in Quarter 2 of Year 2. 20.5 b. 44.3 a. с. 26.7 d. 30.2 23. Refer to data in Q21. When a three-quarter weighted moving average (W1 0.5, W2 0.3, and W3 = 0.2) is used, what is the forecast on the sales in Quarter 2 of Year 2. (Hint: F1+1= WD; + W2D + W3D a. 24.4 b. 30.2 с. 22.8 d. 31.2 24. Refer to data in Q21. When an exponential smoothing model is used with a smoothing parameter alpha of 0.30 and a Q1-Year 2 forecast is 20, what is the forecast on the sales in Quarter 2 of Year 2. (Hint: Fr1 = aY, + (1- a)F,) a. 27.2 29.2 31.2 d. b. с. 33.2 25. Refer to data in Q21. The equation for the trend line of quarterly sales is F, = 24.4 + 1.2t. What is the forecast on the sales in Quarter 2 of Year 2. (Hint: 1=1 for Ql-Year 1, 2 for Q2-year 1, and so on) 31.2 b. 30.4 a. с. 32.2 d. 31.6
Transcribed Image Text:Below you are given the first five values of a quarterly time series of sales. Year Time Series Value Y, 36 Quarter 1 24 3 16 4 20 2 1 44 21. Refer to data above. When a naïve method is used, what is the forecast on the sales in Quarter 2 of Year 2, a. 20 b. 44 с. 27 d. 30 22. Refer to data in Q21. When a three-quarter moving average is used, what is the forecast on the sales in Quarter 2 of Year 2. 20.5 b. 44.3 a. с. 26.7 d. 30.2 23. Refer to data in Q21. When a three-quarter weighted moving average (W1 0.5, W2 0.3, and W3 = 0.2) is used, what is the forecast on the sales in Quarter 2 of Year 2. (Hint: F1+1= WD; + W2D + W3D a. 24.4 b. 30.2 с. 22.8 d. 31.2 24. Refer to data in Q21. When an exponential smoothing model is used with a smoothing parameter alpha of 0.30 and a Q1-Year 2 forecast is 20, what is the forecast on the sales in Quarter 2 of Year 2. (Hint: Fr1 = aY, + (1- a)F,) a. 27.2 29.2 31.2 d. b. с. 33.2 25. Refer to data in Q21. The equation for the trend line of quarterly sales is F, = 24.4 + 1.2t. What is the forecast on the sales in Quarter 2 of Year 2. (Hint: 1=1 for Ql-Year 1, 2 for Q2-year 1, and so on) 31.2 b. 30.4 a. с. 32.2 d. 31.6
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 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