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 (000) | 3.0 | 6.0 | 4.0 | 5.0 | 10.0 | 7.0 | 8.0 | 9.0 | 13.0 | 16.0 | 15.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 |
|
|
|
|
|
|
|
|
b) Using a 3-year weighted moving average in which the registrations in the most recent year are given a weight of 2.00, and registrations in the other 2 years are each given a weight of 1.00 and 1.00, the forecasted registrations (in thousands) for year 12 are (round your responses to one decimal place):
| Year | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Forecast | 4.25 | 4.25 | 6.25 | 7.75 | 8.50 | 9.75 | 10.25 | 12.50 |
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
