Purchase Solution

Moving average for forecasting demand

Not what you're looking for?

Ask Custom Question

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.