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

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)

5.0

7.0

3.0

4.0

9.0

8.0

7.0

11.0

12.0

14.0

17.0

This exercise contains only parts a and b.

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

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

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

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

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) 5.0 7.0 3.0 4.0 9.0 8.0 7.0 11.0 12.0 14.0 17.0 This exercise contains only parts a and b. 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 registra 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

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!