1. Given the following actual sales, t A(t) 1 8 2 4 3 4 5 a....

Transcribed Image Text:

1. Given the following actual sales, t A(t) 1 8 2 4 3 4 5 a. Use a 3 period Simple Moving Average method to forecast sales in periods 6, 7, and 8. b. Use a 3 month Weighted Moving Average method (with weights of 0.6, 0.3, 0.1) to forecast sales in periods 6, 7, and 8. 1 2 Forecasting Practice Problems 11 10 2. A. For the data given below, what would the naive forecast be for the next period (period #5)? Demand Period 58 59 B. Using a simple 3 period moving average, determine the forecast for period number 5. 5 3. Given the following historical data, what is the simple three-period moving average forecast for period 6? Period Value 73 68 65 72 67 4. Given the following historical data and weights of .5, 3, and .2, what is the three-period weighted moving average forecast for period 5? Value Period Period Value 138 148 142 1 2 5. Develop a forecast for the next period, given the data below, using a 3-period moving average. Period 1 1 2 3 4 Demand 19 20 18 19 17 6. Given the data below, develop a forecast for period 6 using a four- period weighted moving average and weights of .4, .3, .2 and.1 Period Demand 19 20 18 19 17 7. Compare and contrast simple, weighted and nave forecasting methods. 1. Given the following actual sales, t A(t) 1 8 2 4 3 4 5 a. Use a 3 period Simple Moving Average method to forecast sales in periods 6, 7, and 8. b. Use a 3 month Weighted Moving Average method (with weights of 0.6, 0.3, 0.1) to forecast sales in periods 6, 7, and 8. 1 2 Forecasting Practice Problems 11 10 2. A. For the data given below, what would the naive forecast be for the next period (period #5)? Demand Period 58 59 B. Using a simple 3 period moving average, determine the forecast for period number 5. 5 3. Given the following historical data, what is the simple three-period moving average forecast for period 6? Period Value 73 68 65 72 67 4. Given the following historical data and weights of .5, 3, and .2, what is the three-period weighted moving average forecast for period 5? Value Period Period Value 138 148 142 1 2 5. Develop a forecast for the next period, given the data below, using a 3-period moving average. Period 1 1 2 3 4 Demand 19 20 18 19 17 6. Given the data below, develop a forecast for period 6 using a four- period weighted moving average and weights of .4, .3, .2 and.1 Period Demand 19 20 18 19 17 7. Compare and contrast simple, weighted and nave forecasting methods.