Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 670 Jun 652 Jul ??? Using a 2 month weighted moving average with weights of 80% for the previous month and 20% for two months back, what is the forecast for July. Round your answer to 1 decimal place. ??? 400 —— --

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
icon
Related questions
Question
Given the following original forecast and actual data:
Month Actual
Forecast
Jan
600
Feb
475
Mar
550
Apr
575
May
670
Jun
652
Jul
???
Using a 2 month weighted moving average with weights of 80% for the
previous month and 20% for two months back, what is the forecast for July.
Round your answer to 1 decimal place.
Answer:
???
400
——
Transcribed Image Text:Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 670 Jun 652 Jul ??? Using a 2 month weighted moving average with weights of 80% for the previous month and 20% for two months back, what is the forecast for July. Round your answer to 1 decimal place. Answer: ??? 400 ——
Expert Solution
steps

Step by step

Solved in 3 steps

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,
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
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