PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER.

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

Week of	Demand	Forecast
31-Aug	360
7-Sep	389
14-Sep	410
21-Sep	381
28-Sep	368
5-Oct	374

1. Forecast the demand for the week of October 12 using a 3-week moving average.
2. Use a 3-week weighted moving average, with weights of 0.1, 0.3, and 0.6, using 0.6 for the most recent week. Forecast demand for the week of October 12
3. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = 0.2