Explore BrainMass
Share

Moving Average Forecasting and Graphing Using Spreadsheet

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

See the following chart The number of geraniums the ABC Floral Shop sold 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?

© BrainMass Inc. brainmass.com March 21, 2019, 11:57 pm ad1c9bdddf
https://brainmass.com/business/business-management/moving-average-forecasting-and-graphing-using-spreadsheet-480742

Solution Preview

The attached files show the step-by-step forecast solution using a three (3) and five (5) - period moving average. The ...

Solution Summary

The solution shows how to graph and forecast data using the moving average method. The solution is found in the attached spreadsheet file.

$2.19