Moving Average
Not what you're looking for?
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
Purchase this Solution
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.
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.