This paper circulates around the core theme of 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? together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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?