Given the following historical data,what is the moving-average forecast for period 6 based on the last three periods?
A)67.
B)68.
C)69.
D)100.
E)115.

Question

Given the following historical data,what is the moving-average forecast for period 6 based on the last three periods? 
A)67. 
B)68. 
C)69. 
D)100. 
E)115.

Quizplus · Accepted Answer

To calculate the moving-average forecast, we take the average of the sales for the last three periods.

Period 1: 60 
Period 2: 65 
Period 3: 70 
Period 4: 75 
Period 5: 80

For period 6, we will take the average of periods 4, 5, and 6:

(75 + 80 + x) / 3 = 78

Solving for x, we get x = 69

Therefore, the moving-average forecast for period 6 is 69. The closest answer choice is B) 68.

Given the Following Historical Data,what Is the Moving-Average Forecast for Period