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

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 Mathematics Questions!