Question

the following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 345 370 410 383 371 374 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10.0 25, and 065. using 0.65 for the most recent week, the forecasted demand for the week of October 12 - 374 pints (round your response to two decimal places and remember to use the weights in appropriate order -- the largest weight applies to most recent period and smallest weight applies to oldest period) c) If the forecasted demand for the week of August 31 is 345 and a = 0.20 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) Week Of Pints Used Forecast for this Date 345 345.00 350.00 August 31 September 7 September 14 September 21 370

Answer 1

Week Pints used 345 370 410 August 31 September 7 September 14 September 21 September 28 October 5 October 12 383 371 374 Forecast 345 345 370 c. Week Pints used August 31 September 7 September 14 September 21 September 28 October 5 410 383 371 374 345 350 362 366.2 367.16 October 12 368.528 345 345 Exponential Smoothing August 31 September 7 September 14 September 21 September 28 October 5 October 12 350 362 Forecast = ( 410 * 0.2) + ( 350 * (1 - 0.2)) 366.2 Forecast = ( 383 * 0.2) + ( 362 * (1 - 0.2)) 367. 16 Forecast = ( 371 * 0.2) + ( 366.2 * (1 -0.2)) 368.53 Forecast = ( 374 * 0.2) + (367.16 * (1 - 0.2))

Sorry for the wrong answer, I took the wrong actual value for the October 5. I have corrected the answer.