Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June; 3rd quarter July, August, September; and 4th quarter October, November, December. Note: Round final answer to a whole number. JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY Last year 110 130 140 180 190 210 155 AUGUS 145 This year 135 145 190 205 235 270 Forecast for the third quarter 456
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June; 3rd quarter July, August, September; and 4th quarter October, November, December. Note: Round final answer to a whole number. JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY Last year 110 130 140 180 190 210 155 AUGUS 145 This year 135 145 190 205 235 270 Forecast for the third quarter 456
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...
Related questions
Question
i need the answer quickly

Transcribed Image Text:Problem 3-3 (Algo)
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year.
Note that the 1st quarter is January, February, and March; 2nd quarter April, May, June; 3rd quarter July, August, September
and 4th quarter October, November, December.
Note: Round final answer to a whole number.
JANUARY
FEBRUARY
MARCH
APRIL
MAY
JUNE
JULY
Last year
110
130
140
180
190
210
155
AUGUS
145
This year
135
145
190
205
235
270
Forecast for the third quarter
456
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
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
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


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.