Forecast demand using 3 and 5 period moving average
Not what you're looking for?
The ABC Floral Shop sold the following number of geraniums during the last 2 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.
Calculate a forecast of the above demand using a 3- and 5-period moving average.
Graph these forecasts and the original data using Excel. What does the graph show?
Which of the above forecasts is best? Why?
Purchase this Solution
Solution Summary
The forecast demand using 3 and 5 period moving average is examined.
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
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.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.