Develop a forecast  of  enrolment beginning 2014 to 2021  using 3-years moving average forecast model.  b) Using weights of .50 for the most recent data, .30 to the second recent data, and .20 to the 3 months old data, develop a forecast beginning 2014 to 2021 using 3 years weighted moving average forecast model.

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...
icon
Related questions
Question
100%
Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from  2011 -2020.            Year               Enrolment                          Year                Enrolment        2011                 5,200                              2016                 7,000      2012                 5,500                              2017                 8,800                2013                 6,000                              2018                   9,400      2014                 6,500                              2019                 9,600      2015                 6,800                              2020                 10,500       a) Develop a forecast  of  enrolment beginning 2014 to 2021  using 3-years moving average forecast model.  b) Using weights of .50 for the most recent data, .30 to the second recent data, and .20 to the 3 months old data, develop a forecast beginning 2014 to 2021 using 3 years weighted moving average forecast model. 
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.