Moving average for forecasting demand
Not what you're looking for?
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?
Purchase this Solution
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.
Solution Preview
Day Demand 3-day moving average 5-Day moving average MAD 3-Day MA MAD 5-Day ...
Purchase this Solution
Free BrainMass Quizzes
Operations Management
This quiz tests a student's knowledge about Operations Management
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
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.
Learning Lean
This quiz will help you understand the basic concepts of Lean.