Explore BrainMass

Explore BrainMass

    Moving average for forecasting demand

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

    The ABC Floral Shop sold the following number of geraniums during the last two weeks:
    Day Demand Day Demand
    1 200 8 150
    2 134 9 182
    3 157 10 197
    4 165 11 136
    5 177 12 163
    6 125 13 157
    7 146 14 169
    Develop a spreadsheet to answer the following questions.
    1. Calculate a forecast of the above demand using a three- and five-period moving average.
    2. Graph these forecasts and the original data using Excel. What does the graph show?
    3. Which of the above forecasts is best? Why?

    © BrainMass Inc. brainmass.com June 3, 2020, 5:26 pm ad1c9bdddf
    https://brainmass.com/business/business-management/moving-average-for-forecasting-demand-25594

    Attachments

    Solution Preview

    Day Demand 3-day moving average 5-Day moving average MAD 3-Day MA MAD 5-Day ...

    Solution Summary

    The solution includes Excel spreadsheet to calculate 3-day and 5-day moving average with graph. Finally which forecast is better is suggested based on graphical representation.

    $2.19

    ADVERTISEMENT