The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks:Pints UsedWeek OfAugust 31360September 7 389September 14 410September 21 381September 28 368October 5 374a. Forecast the demand for the week of October 12 using a 4-week moving average. [Select]b. What is the MAD? [Select]c. Use a 4-week weighted moving average, with weights of .1, .1, .2, and .6 using .6 for the most recent week. Forecast demand for theweek of October 12. [Select ]d. What is the MAD? [Select ]>e. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 363 and a =[Select].47f. What is the MAD? [Select]g. Based on evaluating all three forecasting models, which forecast should be chosen? [Select]

Answered: The following gives the number of pints…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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 389 412 383 366 371 a) The forecasted demand for the week of October 12 using a 3-week moving average decimal places). pints (round your response to two
1. The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Part 2 Week Of Pints Used August 31 350 September 7 372 September 14 412 September 21 381 September 28 366 October 5 378 Part 3 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = _____________pints (round your response to two decimal places).
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 350 370 410 381 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376.67 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.35, and 0.45, using 0.45 for the most recent week, the forecasted demand for the week of October 12 = 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.)
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,…
K The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: a) The forecasted demand for the week of October 12 using a 3-week moving average Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 350 389 408 378 366 371 pints (round your response to two decimal places).
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 September 7 September 14 September 21 September 28 345 370 410 378 368 October 5 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 372.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.30, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = 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.)
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales(000)Units Feb. 15 Mar. 23 Apr. 12 May. 25 Jun. 19 Jul. 28 Aug. 26 Forecast September sales volume using each of the following: (1) A linear trend equation
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: a) The forecasted demand for the week of October 12 using a 3-week moving average = Week Of August 31 September 7 September 14 September 21 September 28 October 5 pints (round your response to two decimal places). Pints Used 345 389 408 381 371 374
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 360 389 412 378 366 371 a) The forecasted demand for the week of October 12 using a 3-week moving average: to two decimal places). = pints (round your response
September 14 September 21 September 28 October 5 412 381 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average=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 = 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.)
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 350 370 412 378 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average: response to two decimal places). 106 pints (round your
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 350 370 410 383 368 374 a) The forecasted demand for the week of October 12 using a 3-week moving average=pints (round your response to two decimal places).

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS