1. Given the following dataon hotel check-ins for a 6-month period:

July: 45 rooms

August: 36 rooms

September: 52 rooms

October: 48 rooms

November: 56 rooms

December: 60 rooms

With alpha = 0.2 and beta = 0.1, what is the adjusted exponentially smoothed forecast for September?

Put your answer in the form xx.xx with no additional symbols or numbers.

2. Assume that the forecasted demand for 2001 is 15, use the following data set and exponential smoothing with alpha = 0.4 and determine the forecasted demand for 2004.

Year Demand

2001 16

2002 20

2003 18

Put your answer in the form xx.xxx with no additional symbols or numbers

3. The following data summarizes the historical demand for a product.

Month Actual demand

March 20

April 25

May 40

June 35

July 30

August 45

Use a four period moving average and determine the forecasted demand for August.

Put your answer in the form xx.x with no additional numbers or symbols.

4. Given the following data on the number of pints of ice cream sold at a local ice cream store for a 6-period time frame:

Period Demand

1 200

2 245

3 190

4 270

5 280

6 300

Compute a 5-period moving average for period 7.

Put your answer in the form xxx with no additional numbers or symbols.

5. Given the following data on hotel check-ins for a 6-month period:

July: 10 rooms

August: 15 rooms

September: 12 rooms

October: 20 rooms

November: 18 rooms

December: 24 rooms

With alpha = 0.2, what is the simple exponential smoothing forecast for October?

Put your answer in the form xx.x with no additional numbers or symbols.

See attached file for full problem description.

Forecasting based on Exponential Smoothing and Moving average technique.