Question

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

WEEK OF	PINTS USED
August 31	360
September 7	389
September 14	410
September 21	381
September 28	368
October 5	374

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. * Then, 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

Answer 1

Answer 2

a) Three period moving average is the average of previous three period actual data

Fore cast for October 12 = 380.33

b)

Weighted Moving Average Forecast for October 12 = 378.3

c)

Exponential smoothing Forecast F_t+1

F_t+1 = Forecast for the t+1 week

F_t = Forecast for the t week

A_t = Actual data for the t week

= Exponential smoothing

Forecast for October 12 = 377.14