Purchase Solution

The ABC Floral Shop sold the following number of geraniums d

Not what you're looking for?

Ask Custom Question

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 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? i also need the names of the resources that you uses

Purchase this Solution

Solution Summary

The solution provides detailed explanations and calculations for the problem. The solution also provides Excel graphs as per requirements.

Solution Preview

Moving averages smooth the price data to form a trend following indicator. They do not predict price direction, but rather define the current direction with a lag. Moving averages lag because they are based on past prices. Despite this lag, moving averages help smooth price action and filter out the noise.

Calculate a ...

Purchase this Solution


Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Operations Management

This quiz tests a student's knowledge about Operations Management

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.