Purchase Solution

Exponential Smoothing and Moving average technique

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

Forecasting based on Exponential Smoothing and Moving average technique.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Time series using forecast accuracy and suitability of methods

    The two techniques considered is 6 month moving average, which was the recommended technique in question 1 and single exponential smoothing which is having best results in the test sample among the exponential smoothing techniques.

  • Chapter 13 -Problem 17 Operations Management for Competitive

    From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? b.

  • Forecast Analysis

    a) Two month moving average. b) Two month weighted moving average, where the most recent month is weighted 60% and the second most recent month is weighted 40%. c) Exponential smoothing, using a 0.1 smoothing factor and Feb. forecast of $69,000.

  • MCQs on forecasting methods/techniques

    exponential smoothing B. compound growth rate C. trend analysis D. moving averages 9.

  • Smoothing Techniques

    538071 Smoothing Techniques I have been using basic smoothing techniques such as moving average, median smoothing and exponential smoothing to generate forcasts for the time series in the attached excel file.

  • Forecast

    Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average using 0.6, 0.3, and 0.1, and exponential smoothing with alpha = 0.7.

  • Mean Absolute Deviation

    These include: 1)Simple Moving Average 2)Weighted Moving Average 3)Exponential Smoothing 4)Linear Regression 5)Seasonal Forecasting via Regression (i.e., linear trends with multiplicative seasonality or nonlinear trends with multiplicative

  • Time Series Forecasting Methods

    There are two main drawbacks to the moving average as a smoothing technique for time series. The moving averages for the first and last time period for the time series.

  • Operations Management

    In statistics, exponential smoothing refers to a particular type of moving average technique applied to time series data, either to produce smoothed data for presentation, or to make forecasts.

View More Related Solutions