Explore BrainMass

Explore BrainMass

    Operational management: Calculate Sales Forecasts

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

    3 The following tabulations are actual sales of units for six months and a starting forecast in January.

    a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.2.

    b. Calculate MAD for the forecasts.
    ACTUAL FORECAST
    January 100 80
    February 94
    March 106
    April 80
    May 68
    June 94

    © BrainMass Inc. brainmass.com June 3, 2020, 9:45 pm ad1c9bdddf
    https://brainmass.com/business/business-management/operational-management-calculate-sales-forecasts-with-simple-exponential-smoothing-197613

    Solution Preview

    Please see the attached file.

    t Month Actual Smoothed Forecast % error
    1 January 100 84.0 ...

    Solution Summary

    This solution shows step-by-step calculations in an Excel file to determine sale forecast from January to June using simple exponential smoothing. A mean squared error, mean absolute percent error and percent positive errors are also calculated.

    $2.19

    ADVERTISEMENT