Data collected on the yearly registrations for a Six Sigma seminar at the Qualit

Question

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year 1235678910 11 Registrations (000) 30 50 30 40 90 80 80 90 130 140 170 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 Forecast 37 40 5.3 70 8.3 83 10.0 120 147 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 5 6 9 101112 Forecast O

Explanation / Answer

Year 4 = weightage*year1 + weightage*year2 + weightage*year3

= 1*3 + 1*5 + 2*3 = 14

Year Registrations(000) Forecast 1 3 2 5 3 3 4 4 14 5 9 16 6 8 25 7 8 29 8 9 33 9 13 34 10 14 43 11 17 50 12 61

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.