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
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.