Excel Online Structured Activity: Moving Average Forecast

Consider the demand for some product over the last 12 periods. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the four-period moving average forecast and answer the following questions.

Open spreadsheet

Moving Average Forecast (4 periods)
						Use the area below to draw a line chart for the four-period moving average.
Period	Actual Demand	Forecast		Formulas
1	1,700
2	2,300
3	2,100
4	1,200
5	2,600			#N/A
6	3,600			#N/A
7	3,300			#N/A
8	3,200			#N/A
9	4,300			#N/A
10	4,700			#N/A
11	4,300			#N/A
12	4,600			#N/A
13				#N/A

Questions

1. Calculate the forecast for the periods from 5 to 13 using a four-period simple moving average. Do not round intermediate calculations. Round your answers to the nearest whole number.

Period Forecast

5

6

7

8

9

10

11

12

13