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 20 October 5 4 August 31 September 7 September 14 September 21 September 28 October 5 October 12 360 370 400 383 Pints Used 371 378 360 370 400 383 371 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.35, 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 penod and smallest weight applies to oldest period, c) If the forecasted demand for the week of August 31 is 360 and a=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 378 D Forecast for this Date 360 350.00 362.00 □ 17 1 8

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 20 October 5 4 August 31 September 7 September 14 September 21 September 28 October 5 October 12 360 370 400 383 Pints Used 371 378 360 370 400 383 371 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.35, 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 penod and smallest weight applies to oldest period, c) If the forecasted demand for the week of August 31 is 360 and a=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 378 D Forecast for this Date 360 350.00 362.00 □ 17 1 8

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

What are the basic assumptions in contrast to causal techniques when using predictive time series techniques?
Below is the number of complaints received in a department store for the first six months of operation: Month Complaints January February March April May June 37 48 84 96 114 148 If a three-month moving average is used to smooth this series, what would have been the forecast for July, rounded to the nearest whole number?
Develop a 1 year periodized program for a Major League Baseball population. Use the traditional periodization model and align your periods with the four sport seasons. Explain why you made the selections of frequency, load, duration, and specific exercises.
South Africa Airways would like to monitor its airline’s performance. Each week for the past 20 weeks, they checked each week a random sample of 100 flight arrivals for “one-time” performance. The table that follows contains the number of flights that did not meet South Africa Airways definition of “one time”: Week Late flights 1 2 2 4 3 10 4 4 5 1 6 1 7 13 8 9 9 11 10 0 11 3 12 4 13 2 14 2 15 8 16 2 17 3 18 7 19 3 20 2 Which control chart is appropriate to analyze the above data? Justify your answer
I used excel and got a 1.31 on this question, but my friend got another answer.
bex Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 3.136512 0.964065 0.985521 0.971252 0971252 Given the above regression statistics, what is the value of the coefficient of determination? 0.964065 3.136512
Based on the following regression ANOVA table, how many predictors are studied? Source df SS MS F Regression 4 1793.2356 448.3089 7.4854 Residual 45 2695.0996 59.8911 Total 49 4488.3352 1 3 4 5
(Use an excel file to show formulas used)