Explore BrainMass

Explore BrainMass

    Exponential Smoothing and Moving average technique

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 7:28 pm ad1c9bdddf
    https://brainmass.com/statistics/central-tendency/exponential-smoothing-and-moving-average-technique-100094

    Attachments

    Solution Summary

    Forecasting based on Exponential Smoothing and Moving average technique.

    $2.19

    ADVERTISEMENT