Question: 3.2. Given the following data, calculate the three-month moving average forecasts fo months 4, 5, 6, and 7. Month Actual Demand Forecast 1 1 00

3.2. Given the following data, calculate the

3.2. Given the following data, calculate the

3.2. Given the following data, calculate the three-month moving average forecasts fo months 4, 5, 6, and 7. Month Actual Demand Forecast 1 1 00 70 3 40 4 50 5 70 6 65 8.4. If the forecast for February was 122 and actual demand was 135, what would be the forecast for March if the smoothing constant (a) is 0.15? Use exponential smoothing for your calculation. Answer. Forecast 123.95 = 124 8.9. If the average demand for the first quarter was 140 and the average demand for all quarters was 175, what is the seasonal index for the first quarter? Answer. Seasonal index 0.80 8.10. Using the data in problem 8.9, if the forecast for next year is 800, calculate the fore- cast for first quarterly demand next year. Answer. Forecast for first quarter = 160 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. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!