Question: Problem 19 (Forecasting): Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrolment for the last 8 years.

 Problem 19 (Forecasting): Suppose that the Perpetual Help College of Rizalhad the following record of its growth of enrolment for the last

Problem 19 (Forecasting): Suppose that the Perpetual Help College of Rizal had the following record of its growth of enrolment for the last 8 years. Year Enrollment Year Enrollment 1 1.200 5 3,000 2 1.500 3,800 2.000 4,000 4 2.500 4.500 Required: 6 | Module 2: Budgeting and Forecasting1. Forecast the enrolment for year 7 to 9 using the naive method. 2. Using the enrolment data for year 1 to 5 to derive the formula, forecast the enrolment for year 7 to 9 using the trend projection method 3. Forecast the enrolment for year 7 to 9 using a 5-year unweighted moving average. 4. Forecast the enrolment for year 7 to 9 using a 3-year weighted moving average. 5. Forecast the enrollment for year 7 to 9 using exponential smoothing forecast if alpha was 0.8 and the previous forecast for Year 6 was 3,500. Problem 20 (Forecasting): Aling Nena had the following sales in her small sari-sari store for the past 3 weeks: P2,500, P3,000, P2,000, P3,400, and P2,800. Required: 1. Using the naive method, what are the forecast for week 2 to 6? 2. Using the trend projection method, what will be the forecast for the sixth week? . Using a 3-week unweighted moving average, forecast the sales for week 4 to 6. 4. Using a 3-week weighted moving average, forecast the sales for week 4 to 6. 5. Forecast the sales for week 4 to 6 using exponential smoothing if alpha was 0.6 and the previous forecast for week 3 was P2,500. 7 | Module 2: Budgeting and Forecasting

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!