Purchase Solution

Question about Quality Control & Supply Chain Management

Not what you're looking for?

Ask Custom Question

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.