Explore BrainMass

Explore BrainMass

    Moving Average

    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 2 weeks:
    1. Calculate the demand for day 15
    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.
    2. Calculate a forecast of the above demand using a 3- and 5-period moving average.
    3. Graph these forecasts and the original data using Excel. What does the graph show?
    4. Which of the above forecasts is best? Why?
    Use the following spread sheet to began

    Day Dt Demand At 3-Period Mov. Avg. Ft 3-Period Forecast Dt-Ft Error At 5-Period Mov. Avg Ft 5-Period Forecast Dt-Ft Error
    1 200
    2 134
    3 157 163.7
    4 165 152 163.7 1.3
    5 177 166.3 152 25 166.6

    6 125 155.7 166.3 -41.3 151.6 166.6 -41

    © BrainMass Inc. brainmass.com June 4, 2020, 2:11 am ad1c9bdddf
    https://brainmass.com/business/accounting/444510

    Solution Summary

    The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

    $2.19

    ADVERTISEMENT