forcasting ( using excel)

C F G J9 XV fx A B D E F H 1 Chapter 9: Forecasting 2 3 4 DIRECTIONS Enter your 4-digit number to generate the homework key. 5 6 Name: 7 4-digit number: 2000 8 9 10 Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. 11 Each time you develop a forecast, round your answer off to a whole number (ex. - 2012.6 = 2013). 12 Use a smoothing constant value of 0.3. 13 14 Actual Week Demand Forecast 16 17 1 2000 18 2 1800 19 3 1900 20 2040 21 5 1840 22 2140 23 7 1920 24 8 2080 25 9 15 oor coon 26 OT