Explore BrainMass

Explore BrainMass

    Forecasting Demand Using Exponential smoothing

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

    Consider the following actual and forecast demand levels for the Burger King Whopper sandwich at a local Burger King restaurant:

    Day Actual Demand Forecast Demand
    Monday 88 88
    Tuesday 72 88
    Wednesday 68 84
    Thursday 48 80
    Friday

    The forecast for Monday was derived by observing Monday's demand level and setting Monday's forecast level equal to this demand level. Subsequent forecasts were derived by using exponential smoothing with a smoothing constant of 0.25. Using this exponential smoothing method, what is the forecast for the Whopper sandwich demand for Friday?

    Must show all work via excel.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:37 pm ad1c9bdddf
    https://brainmass.com/business/business-management/forecasting-demand-using-exponential-smoothing-241029

    Solution Summary

    This solution calculates the demand that Burger King will have for a Whopper sandwich on a Friday.

    $2.19

    ADVERTISEMENT