Question: Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: begin{tabular}{lccccccccccc} hline Year &

 Data collected on the yearly registrations for a Six Sigma seminar

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: \begin{tabular}{lccccccccccc} \hline Year & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 \\ \hline Registrations (000) & 3.0 & 7.0 & 4.0 & 4.0 & 9.0 & 9.0 & 8.0 & 11.0 & 11.0 & 12.0 & 12.0 \\ \hline \end{tabular} 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): \begin{tabular}{lccccccccc} \hline Year & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 \\ \hline Forecast & 4.7 & 5 & 5.7 & 7.3 & 8.7 & 9.3 & 10 & 11.3 & 11.7 \\ \hline \end{tabular} 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): \begin{tabular}{lccccccccc} \hline Year & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 \\ \hline Forecast & & & & & & & & & \\ \hline \end{tabular}

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!