The ABC Floral Shop sold the following number of geraniums d
Not what you're looking for?
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.