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.00 6.00 4.00 5.00 10.00 8.00 7.00 9.00 12.00 14.00 15.00 a) Calculate forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (α) of 0.30 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): Year 1 2 3 4 5 6 7 8 9 10 11 12 Forecast (000) 5.00 4.7 5.1 4.8 4.8 6.4 6.9 6.9 7.5 8.9 10.4 11.8 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (α)= 0.30 and a starting forecast of F1= 5.00) is ___ responses (round your response to one decimal place).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

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	4	5	6	7	8	9	10	11
Registrations (000)	4.00	6.00	4.00	5.00	10.00	8.00	7.00	9.00	12.00	14.00	15.00

a) Calculate forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (α) of 0.30 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place):

Year

Forecast (000)

5.00

4.7

5.1

4.8

6.4

6.9

7.5

8.9

10.4

11.8

b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (α)= 0.30 and a starting forecast of F1= 5.00) is ___ responses (round your response to one decimal place).

Expert Solution