Question: 1. Demand data collected on yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Registrations 1

1. Demand data collected on yearly registrations

1. Demand data collected on yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Registrations 1 4000 2 6000 3 4000 4 5000 5 10000 6 8000 12 Year Registrations 7 7000 8 9000 9 12000 10 14000 11 15000 a. Develop a 3-year moving average to forecast registrations from year 4 to 12. b. Estimate (forecast) demand again for years 4-12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 0.50, 0.25, and 0.25. C. Estimate (forecast) demand again for years 1-12 using exponential smoothing with a smoothing constant of 0.3. To being, assume that the forecast for year 1 was 5,000 people. d. Compute the MAD forecasting error for each forecast. Which forecast is better

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!