Question: 1. What is the forecast for May based on a weighted moving average applied to the following past demand data and using the weights: .40
1. What is the forecast for May based on a weighted moving average applied to the following past demand data and using the weights: .40 and .60 (largest weight is for most recent data & round to one decimal place)?
| Nov. | Dec. | Jan. | Feb. | Mar. | April |
| 3 | 6 | 9 | 2 | 8 | 6 |
| 4.8 | ||
| 6.8 | ||
| 7.2 | ||
| 8.6 |
2. Given an actual demand this period of 103, a forecast value for this period of 105, and an alpha of .4, what is the exponential smoothing forecast for next period?
| 105.8 | ||
| 104.2 | ||
| 102.2 | ||
| 103.8 |
3. Suppose that the actual demand in January and February was 7 units and 9 units respectively. Assume that the forecast for January was 5 units. If the firm uses exponential smoothing with an alpha value of .20 - Determine the forecast for March? (Round answers to two decimal places.)
| 3.72 | ||
| 5.00 | ||
| 6.12 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
