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?
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.

Attachments

Solution Summary

Forecasting based on Exponential Smoothing and Moving average technique.

$2.19