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
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.