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 372 412 383 366 October 5 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.10, 0.25, and 0.65, using 0.65 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.) c) If the forecasted demand for the week of August 31 is 345 and a = 0.25, 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 345 345 September 7 September 14 372 345.00 412 351.75 September 21 383 September 28 366 October 5 378 October 12

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
The following table provides data on the number of pints of type A blood used at Damascus Hospital over the past six weeks:

| **Week Of**     | **Pints Used** |
|-----------------|----------------|
| August 31       | 345            |
| September 7     | 372            |
| September 14    | 412            |
| September 21    | 383            |
| September 28    | 366            |
| October 5       | 378            |

**Instructions:**

a) To forecast the demand for the week of October 12 using a 3-week moving average, calculate the average pints used over the last three weeks.

b) For a 3-week weighted moving average, use weights of 0.10, 0.25, and 0.65 with the largest weight (0.65) applied to the most recent week, and calculate the forecasted demand for October 12.

c) Apply exponential smoothing with an initial forecast for August 31 of 345 and a smoothing constant (α) of 0.25. Develop forecasts for each subsequent week and the week of October 12.

| **Week Of**     | **Pints Used** | **Forecast for this Date**      |
|-----------------|----------------|---------------------------------|
| August 31       | 345            | 345                             |
| September 7     | 372            | 345.00                          |
| September 14    | 412            | 351.75                          |
| September 21    | 383            |                                 |
| September 28    | 366            |                                 |
| October 5       | 378            |                                 |
| October 12      | –              |                                 |

These calculations will help in predicting future blood usage and managing inventory efficiently.
Transcribed Image Text:The following table provides data on the number of pints of type A blood used at Damascus Hospital over the past six weeks: | **Week Of** | **Pints Used** | |-----------------|----------------| | August 31 | 345 | | September 7 | 372 | | September 14 | 412 | | September 21 | 383 | | September 28 | 366 | | October 5 | 378 | **Instructions:** a) To forecast the demand for the week of October 12 using a 3-week moving average, calculate the average pints used over the last three weeks. b) For a 3-week weighted moving average, use weights of 0.10, 0.25, and 0.65 with the largest weight (0.65) applied to the most recent week, and calculate the forecasted demand for October 12. c) Apply exponential smoothing with an initial forecast for August 31 of 345 and a smoothing constant (α) of 0.25. Develop forecasts for each subsequent week and the week of October 12. | **Week Of** | **Pints Used** | **Forecast for this Date** | |-----------------|----------------|---------------------------------| | August 31 | 345 | 345 | | September 7 | 372 | 345.00 | | September 14 | 412 | 351.75 | | September 21 | 383 | | | September 28 | 366 | | | October 5 | 378 | | | October 12 | – | | These calculations will help in predicting future blood usage and managing inventory efficiently.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman