Share
Explore BrainMass

# Exponential Smoothing and Moving average technique

1. Given the following data on 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?

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

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.

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.

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?