Calculate a shop forecast of demand

Assignment Help Business Management

Reference no: EM1333443

The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

Key:

Day | Demand

1 | 200

2 | 134

3 | 157

4 | 165

5 | 177

6 | 125

7 | 146

8 | 150

9 | 182

10 | 197

11 | 136

12 | 163

13 | 157

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?

Reference no: EM1333443

Questions Cloud

Elucidate why the us would subsidize the short run : Elucidate why the US would subsidize the short run costs of production for tobacco farmers in foreign countries.

Strategic or operational role in compliant work environment : Summarize how the new proposed policy supports either the strategic or operational role in maintaining a compliant work environment.

Explain kentucky fried chicken- supply chain : Explain Kentucky Fried Chicken- Supply Chain and describe the supply chain of Kentucky Fried Chicken Company when in a brick and mortar

Analyze the importance of hrm''s role : Analyze the importance of HRM's role to manage risk for the organization and give at least two examples that illustrate the application of human resources role

Calculate a shop forecast of demand : The ABC Floral Shop sold the following number of geraniums during the last 2 weeks. Calculate a shop forecast of demand

Explain what the database roles : Describe steps necessary to setup SQL Server security.

Non-interest-bearing promissory note : If an employee receives the non-interest-bearing promissory note from his employer as compensation, how much income does that employee have to include in his income?

What are your most important roles : What are your most important roles and responsibilities and describe the most difficult challenges that you face as an HR professional.

Examine present global economic and political policies : Examine present global economic and political policies and their impact on business decisions.

User Account

All Pages