Explore BrainMass
Share

Moving Average

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:
1. Calculate the demand for day 15
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.
2. Calculate a forecast of the above demand using a 3- and 5-period moving average.
3. Graph these forecasts and the original data using Excel. What does the graph show?
4. Which of the above forecasts is best? Why?
Use the following spread sheet to began

Day Dt Demand At 3-Period Mov. Avg. Ft 3-Period Forecast Dt-Ft Error At 5-Period Mov. Avg Ft 5-Period Forecast Dt-Ft Error
1 200
2 134
3 157 163.7
4 165 152 163.7 1.3
5 177 166.3 152 25 166.6

6 125 155.7 166.3 -41.3 151.6 166.6 -41

© BrainMass Inc. brainmass.com March 21, 2019, 11:04 pm ad1c9bdddf
https://brainmass.com/business/accounting/444510

Solution Summary

The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

$2.19