Question: Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Registrations (000) 1

Data collected on the yearly registrations for a
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Registrations (000) 1 2 3 4 5 6 7 8 9 10 11 4 6 4 5 10 8 7 9 12 14 15 a. Develop a 3-year moving average to forecast registrations from year 4 to year 12. What is the forecast? 13.67 What is the MAD? 2.33 b. Estimate demand again for years 4 to 12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1. What is the forecast? (Select] What is the MAD? 2.31 c. Use exponential smoothing with (a 47), assume the initial period forecast is 5. What is the forecast for the next period? 13.33 What is the MAD? 2.12 d. Based on Error Analysis, which of the forecasting methods seems better? Exponential Smoothing Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Registrations (000) 1 2 3 4 5 6 7 8 9 10 11 4 6 4 5 10 8 7 9 12 14 15 a. Develop a 3-year moving average to forecast registrations from year 4 to year 12. What is the forecast? 13.67 What is the MAD? 2.33 b. Estimate demand again for years 4 to 12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1. What is the forecast? (Select] What is the MAD? 2.31 c. Use exponential smoothing with (a 47), assume the initial period forecast is 5. What is the forecast for the next period? 13.33 What is the MAD? 2.12 d. Based on Error Analysis, which of the forecasting methods seems better? Exponential Smoothing

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 General Management Questions!