solution

The actual demand for the patients at Omaha Emergency Medical Clinic for the first 6 weeks of this year follows:

Clinic administrator Marc Schniederjans wants you to forecast patient demand at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167 three periods ago.

a) What is the value of your forecast?

b) If instead the weights were 20, 15, 15, and 10, respectively, how would the forecast change? Explain why.

c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Use exponential smoothing with a smoothing constant of 0.3 to forecast the registrations at the seminar given in Problem 4.10. To begin the procedure, assume that the forecast for year 1 was 5,000 people signing up.

a) What is the MAD?

b) What is the MSE?

Problem 4.10

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table:

a) Develop a 3-year moving average to forecast registrations from year 4 to year 12.

b) Estimate demand again for years 4 to 12 with a 3-year weighted moving average in which registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1.

c) Graph the original data and the two forecasts. Which of the two forecasting methods seems better?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Refer to Solved Problem 4.1.

a) Use a 3-year moving average to forecast the sales of Volkswagen Beetles in Nevada through year 6.

b) What is the MAD?

c) What is the MSE?

Problem 4.1

The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks:

a) Forecast the demand for the week of October 12 using a 3-week moving average.

b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12.

c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = .2.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Refer to Solved Problem 4.1.

a) Using the trend projection (regression) method, developa forecast for the sales of Volkswagen Beetles in Nevada through year 6.

b) What is the MAD?

c) What is the MSE?

Problem 4.1

The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks:

a) Forecast the demand for the week of October 12 using a 3-week moving average.

b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12.

c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = .2.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"