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)

4.0

6.0

4.0

5.0

10.0

8.0

7.0

9.0

12.0

14.0

15.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

4.7

5.0

6.3

7.7

8.3

8.0

9.3

11.7

13.7

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

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: 1 2 3 4 5 6 7 8 9 10 11 Year Registrations (000) 4.0 6.0 4.0 5.0 10.0 8.0 7.0 9.0 12.0 14.0 15.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 4.7 5.0 6.3 7.7 8.3 8.0 9.3 11.7 13.7 Using 3-year weighted moving average in which the registra ions in the most recent year thousands) for years 4 through 12 are (round your responses to one decimal place): given a weight of and registrations in the other 2 years are each given a weight of 1, the forecasted registrations (in Year 4 5 6 7 8 9 10 11 12 Forecast 0

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!