Problem 4.1 Question Help The tollowing table gives the number of pints or type
ID: 416311 • Letter: P
Question
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)Explanation / Answer
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
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.