ABC Floral Shop
mulungThe 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?
7 years ago
Purchase the answer to view it
abc_floral.xlsx
The ABC Floral Shop
NOT RATEDThe 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 …
7 years agoUnit 4 – Quality Control & Supply Chain Management Assignment
NOT RATEDThe 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 …
5 years agoThe ABC Floral Shop sold the following number of geraniums during the last 2 weeks ...
NOT RATEDThe ABC Floral Shop sold the following number of geraniums during the last 2 weeks: Day Demand Day Demand 1 200 8 150 …
2 years agoThe ABC Floral Shop sold the following number of geraniums during the last 2 weeks:
NOT RATEDThe 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 …
7 years ago
