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 374 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = 374.33374.33 pints (round your response to two decimal places). 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 = 372.55372.55 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 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). Week Of Pints Used Forecast for this Date August 31 360 360 September 7 389 360.00 September 14 412 365.80 September 21 383 375.04375.04 September 28 366 nothing

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.7: Exponential Smoothing Models

Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...

See similar textbooks

Related questions

Concept explainers

Question

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	374

a) The forecasted demand for the week of October 12 using a 3-week

moving average

374.33374.33

pints (round your response to two decimal places).

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 =

372.55372.55

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

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).

Week Of	Pints Used	Forecast for this Date
August 31	360	360
September 7	389	360.00

September 14

412

365.80

September 21

383

375.04375.04

September 28

366

nothing

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.