/
/
/
61) Given the following data, calculate the three-year moving averages
Not my Question
Flag Content

# 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