Problem 41 Question Help The tollowing table gives the numbe

Problem 4.1 Question Help The tollowing table gives the number of pints or type A blood used at Damascus Hospital in the past 6 weeks Week Of Pints Used August 31 September 7 September 14 September 21 September 28 October 5 370 412 381 371 a The forecasted demand for the week of October 12 using a 3-week m o ng average 372.67 pints round your response ton decr al paces b) Using a 3-week weighted moving average, with weights of 0.15, 0.35, and 0.50, using 0.50 for the most recent week the forecasted demand for the week of October 12-370.75 pints (round your response to two decimal places and remember to use the weights in appropriate orderthe 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 360 and : 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)

Solution

Answer to Problem 4.1 . C )

Following is to be noted:

Ft = alpha x At-1 + ( 1- alpha ) x Ft-1 = 0.2 x At-1 + 0.8 x Ft-1

Where,

Ft = Forecast for period t

Ft-1 = Forecast for period t-1

At-1 = Pints used

Alpha = Exponential smoothing factor = 0.2

Accordingly, Forecasted value for each week including week of October 12 are presented below :

Week

Pints used

Forecast

Aug-31

360

360.00

Sep-07

370

360.00

Sep-14

412

362.00

Sep-21

381

372.00

Sep-26

366

373.80

Oct-05

371

372.24

Oct-12

371.99

Week	Pints used	Forecast
Aug-31	360	360.00
Sep-07	370	360.00
Sep-14	412	362.00
Sep-21	381	372.00
Sep-26	366	373.80
Oct-05	371	372.24
Oct-12		371.99