solution

/in /by

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

/in /by

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!"

solution

/in /by

Refer to Solved Problem 4.1. Using smoothing constants of .6 and .9, develop forecasts for the sales of VW Beetles. What effect did the smoothing constant have on the forecast? Use MAD to determine which of the three smoothing constants (.3, .6, or .9) gives the most accurate forecast.

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

/in /by

As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years:

The director of medical services predicted 6 years ago that demand in year 1 would be 41 surgeries.

a) Use exponential smoothing, first with a smoothing constant of .6 and then with one of .9, to develop forecasts for years 2 through 6.

b) Use a 3-year moving average to forecast demand in years 4, 5, and 6.

c) Use the trend-projection method to forecast demand in years 1 through 6.

d) With MAD as the criterion, which of the four forecasting methods is best?

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