Info
Warning
Danger
/
/
/
61) Given the following data, calculate the three-year moving averages

Question : 61) Given the following data, calculate the three-year moving averages

61) Given the following data, calculate the three-year moving averages for years 4 through 10.

Year

Demand

1

74

2

90

3

59

4

91

5

140

6

98

7

110

8

123

9

99

62) What is the forecast for May based on a weighted moving average applied to the following past demand data and using the weights: 4, 3, 2 (largest weight is for most recent data)?

Nov.

Dec.

Jan.

Feb.

Mar.

April

37

36

40

42

47

43

63) Weekly sales of copy paper at Cubicle Suppliers are provided in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week 8 with the more accurate method.

WeekSales (cases)

117

221

327

431

519

617

721

Solution
5 (1 Ratings )

Solved
Management 7 Months Ago 107 Views
This Question has Been Answered!
Expert Answer