1. Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrollment from 2011 -2020.

YearEnrollmentYearEnrollment

20115,20020167,000

20125,50020178,800

20136,00020189,400

20146,50020199,600

20156,800202010,500

a)Develop a forecast of enrollment 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.

c) Using exponential smoothing and smoothing constant of .30 and 2011 previous forecast of 5200, develop a forecast of enrollment from 2012 to 2021.

d)Forecast enrollment using Trend line Projection from 2011 to 2021

e) Evaluate forecast accuracy of each forecast model using MSE. Which model should you recommend?