Question about Quality Control & Supply Chain Management
Not what you're looking for?
Deliverable Length: 3-4 pages
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 77 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?
Please no previous submitted post. List references also.
Purchase this Solution
Solution Summary
The financial forecast with the provided demand of the moving average is given. An analysis of the graph is given. The solution is an attached excel file.
Purchase this Solution
Free BrainMass Quizzes
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.
Motivation
This tests some key elements of major motivation theories.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Introduction to Finance
This quiz test introductory finance topics.