Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
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.
NEED HELP WRITING AN ESSAY
Tell us about your assignment and we will find the best writer for your project.
Get Help Now!- Calculate a forecast of the above demand using a three- and five-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?
© BrainMass Inc. brainmass.com March 21, 2019, 10:48 am ad1c9bdddf
https://brainmass.com/business/business-management/moving-average-for-forecasting-demand-25594
Attachments excel problem.doc
Solution Preview
Day Demand 3-day moving average 5-Day moving average MAD 3-Day MA MAD 5-Day …


