Question

Given the series of demand data below Period: 1 2 3 4 5 6 7 8 9 10 Demand: 42 35 58 42 27 49 40 41 27 41 a. Calculate the forecasts for periods 7 through 11 using moving average models with n = 2, n = 4, and n = 6. (Round your intermediate calculations and final answers to 1 decimal place.)

Answer 1

Answer:

Kindly check Explanation

Explanation:

Given :

Period: 1 2 3 4 5 6 7 8 9 10

Demand: 42 35 58 42 27 49 40 41 27 41

Using n = 2

Week - - - - - - - - - - n = 2

7 - - - - - - ( 27 + 49)/2 = 38

8 - - - - - - (49 + 40)/2 = 44.5

9 - - - - - - -(40 + 41)/2 = 40.5

10 - - - - - - (41 + 27)/2 =34

11 - - - - - - - (27 + 41)/2 34

Using n = 4

Week - - - - - - - - - - n = 4

7 - - - - - - (58 + 42 + 27 + 49)/4 = 44

8 - - - - - - (42 + 27 + 49 + 40)/4 = 39.5

9 - - - - - - -(27 + 49 + 40 + 41)/4 = 39.3

10 - - - - - - (49 + 40 + 41 + 27)/4 =39. 3

11 - - - - - - - (40 + 41 + 27 + 41)/2 = 37.3

Using n = 6

Week - - - - - - - - - - n = 6

7 - - - - - - (42 + 35 + 58 + 42 + 27 + 49)/6= 42.2

8 - - - - - - (35 + 58 + 42 + 27 + 49 + 40)/6 = 41.8

9 - - - - - - -(58 + 42 + 27 + 49 + 40 + 41)/6= 42.8

10 - - - - - - (42 + 27 + 49 + 40 + 41 + 27)/6 =39.7

11 - - - - - - - (27 + 49 + 40 + 41 + 27 + 41)/6 = 37.5