Question: Please kindly help on this question. Thanks 2. Data collected on the yearly registration for a Six Sigma seminar at the Quality College are shown

Please kindly help on this question. Thanks Please kindly help on this question. Thanks 2. Data collected on the

2. Data collected on the yearly registration for a Six Sigma seminar at the Quality College are shown in the following table: a) Develop a 4 year moving average to forecast registrations from year 5 to year 12 . ( 7pts) b) Estimate demand again for years 5 to 12 within a 4 year weighted moving average in which registrations in the most recent year are given a weight of 3 and 2 , and registrations in the other 2 years are each given a weight of 1 . ( 8pts) c) Compute the forecasts for each year using exponential smoothing, with an initial forecast for year 5 of 8 . Use =0.3. ( 8 pts) d) Using MAD, which of the three forecasting methods is bestr ( 8pts ) c) Using MAPE, which of the three forecasting methods is best? ( 8pts) f) Forecast registrations for year 15 , using trend projection. ( 8 pts)

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!