The ABC Floral Shop sold the following number of geraniums during the
last two 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 three- and five-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?
Business Homework Solutions
#25594
Demand Forcast for ABC Floral Shop
The ABC Floral Shop sold the following number of geraniums during the last two 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.
1. Calculate a forecast of the above demand using a three- and five-period moving average.
2. Graph these forecasts and the original data using Excel. What does the graph show?
3. Which of the above forecasts is best? Why?
The solution includes Excel spreadsheet to calculate 3-day and 5-day moving average with graph. Finally which forecast is better is suggested based on graphical representation.
What is this?
By OTA - Overall OTA Rating
Rohtas Kumar, MBA - 4.9/5
Purchase Cost Now
$2.19 CAD (was ~$19.95)
Included in Download
- Plain text response
- Attached file(s):
- Moving Average.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- ABC Floral Shop: forecast the demand for geraniums and graph the results - The ABC Floral Shop sold the following number of geraniums during the last two weeks: Day Demand Day Demand 1 200 8 150 2 134 9 182 3 157 1 ...
- Assume that your stock of sales merchandise is maintained based on the forecast demand. - Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the 1st day of each month, compute your forecast sales by each of ...
- Forecasting demand using exponential smoothing. - Consider the following actual and forecast demand levels for the Burger King Whopper sandwhich at a local Burger King restaurant: Day Actual Demand Forecast Demand Monday 88 88 Tu ...
- Forecast demand for units. Would a naive forecast produce better results? - A manager has been using a certain technique to forecast demand for word processing units for the past six periods. Actual and predicted amounts are shown below. Would a naive forecast have produced b ...
- Spreadsheet simulation using Excel - The owner of Carlo's Computers is planning a 7-day promotion (Sunday-Saturday) to launch a new PC called "PCLink1000." *The shop owner is pricing these PC's at $675 each, and he buys them for $425 eac ...
