Explore BrainMass
Share

Forecast demand using 3 and 5 period 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:

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, 10:02 pm ad1c9bdddf
https://brainmass.com/business/accounting/forecast-demand-period-moving-average-402119

Solution Summary

The forecast demand using 3 and 5 period moving average is examined.

$2.19