Create an Excel spreadsheet to answer the following questions. Apply formulas/functions with cell references. Submit your Excel file through Blackboard.

The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks:

Week Of	Pints Used
August 31	360
September 7	389
September 14	412
September 21	383
September 28	366
October 5	378

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

b) Using a 3-week weighted moving average, with weights of 0.15, 0.25, and 0.60, determine the forecasted demand for the week of October 12.

c) If the forecasted demand for the week of August 31 is 360 and = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places).