The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks:Week OfAugust 31September 7September 14September 21September 28October 5a) 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.20, 0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 =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 x = 0.30, 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 OfAugust 31September 7September 14September 21September 28October 5October 12Pints Used345370408383371374Pints Used345370408383371374Forecast for thisDate345345.00352.50pints (round your response to two decimal places and remember to use the weights in appropriate order -

to find:the forecast for October 12 month using a three-week moving averagethe forecast for October…

Answered: The following table gives the number of…

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

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?
I understand the moving average concept but not the weighted moving average and exponential smoothing
Define the MONITORING FORECAST ERROR?
The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months. Compute an exponentially smoothed forecast with an a value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of January would be (type number only, two decimals) Month October November December January February March April May June July 733.25 Gasoline Demanded (gal.) 800 725 630 500 645 690 730 810 1,200 980
The following table gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 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.30, and 0.60, using 0.60 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 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 August 31 September 7 September 14 September…
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 Aug 31 360 Sep 7 370 Sep 14 412 Sep 21 383 Sep 28 371 Oct 5 371 A) The forecasted demand for the week of October 12 using a 3-week moving average = 375 B) Using the 3-week weighted moving average, with weights of 0.10, 0.35, 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.)
The following table gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 - 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.30, and 0.60, using 0.60 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.) Week Of 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). August 31 September 7 September 14…
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: August 31 September 7 September 14 Week Of September 21 September 28 October 5 Week Of a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). pints (round your 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 = 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 350 and x = 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). August 31 September 7 September 14…
Chart and Regression analysis : What does the intercept predict? X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day) Equation: y=2.9x + 14.5 Slope:2.9 Intercept:14.5 Does the intercept mean the intercept is 14.5 means that the cars sold per day( Y) predicted number of cars on sale lot(X) to be 14.5, but this intercept has no meaning. So, I will not use to predict cars sold per day?
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: S Week Of August 31 September 7 September 14 September 21 September 28 October 5 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 = 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 350 and a = 0.30, 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 350 350.00 356.00 August 31 September 7 September 14 September 21 September 28 October 5 October 12 Pints…
The following table contains the number of complaints received in a department store for the first 6 months of operation: MONTH COMPLAINTS January 39 February 50 March 88 April 99 May June 115 154 If a three-month moving average is used to smooth this series, what would have been the forecast for May?

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