Question: 8.1 Over the past three months the demand for a product that has been 255, 219, and 231. Calculate the three-month moving average forecast for
8.1 Over the past three months the demand for a product that has been 255, 219, and 231. Calculate the three-month moving average forecast for month 4. If the actual demand in month 4 is 228, calculate the forecast for month 5. (worth 2 points)
8.2 given the following data calculate the three-month moving average forecasts for months 4, 5, 6, and 7.(worth 2 points)
Month
Actual demand
Forecast
1
60
2
70
3
40
4
50
5
70
6
65
7
8.5 If the old forecast is 100 and the latest actual demand is 83, what is the exponentially smoothed forecast for the next period? Alpha is 0.25(worth 2 points)
8.6 Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. The smoothing constant is 0.2 and the old forecast for month 1 is 245.(worth 2 points)
Month
Actual demand
Forecast demand
1
260
2
230
3
225
4
245
5
250
6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
