Question: Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year 1 2 3
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations 5.0 5.0 5.0 6.0 9.0 7.0 6.0 10.0 13.0 12.0 12.0
a) Using a 3-year moving average, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal
place):
| Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Forecast | 55 | 5.35.3 | 6.76.7 | 7.37.3 | 7.37.3 | 7.77.7 | 9.79.7 | 11.711.7 | 12.312.3 |
b) Using a 3-year weighted moving average in which the 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, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal
place):
| Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Forecast |
|
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
