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 = 373.33 pints (round your response to two decimal places).b) Using a 3-week weighted moving average, with weights of 0.20, 0.25, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = 373.3 pints (round yourresponse 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 Ofc) If the forecasted demand for the week of August 31 is 360 and a = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the weekof October 12 (round your responses to two decimal places).August 31September 7September 14September 21September 28Pints Used360372412Pints Used360372378368374412378368Forecast for thisDate360360.00363.60378.12

Forecasting is a process that predict the future demand using available past actual information. The…

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

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 370 September 14 412 September 21 383 September 28 371 October 5 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).
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 Oct 12 using a 3 week moving average= 375 pints 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 forecased demand for the week of Oct 12 = 372.20 c) If the forecasted demand for the week of Aug 31 is 360 and (alpha symbol)= 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of Oct 12 week of pints used forecast for this date Aug 31 360…
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 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.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12- 371.15) 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.) Pints Used 345 389 412 378 368 371
What is the connection between using a tracking signal and statistical control limits for forecast control?
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
FORECASTING Sales of industrial vacuum cleaners at Yarena Supply CO. over the past 13 months are as follows: Sales in P1,000 Month Sales in P1,000 Month 11 January 14 August 14 February 17 September 15 March 12 October 10 April 14 November 15 May 16 December 17 June 11 January 11 July Required suing a moving average with three periods, determine the demand for vacuum cleaners for next February?
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
The Vision Hospital is considering the purchase of a new Advance Scan machine. The decision will rest partly on the anticipate patients in the coming months. The numbers of patents during the past years are as follows: Year Number of patents(Actual) 2016 1600 2017 2200 2018 2600 2019 2800 2020 3100 Compute the forecast for the year 2021 using exponential smoothing with a forecast for the year 2016 of 1500 and α = .3
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
Room registrations in the Toronto Towers Plaza Hotel have been recorded for the past 9 years. To project future occu-pancy, management would like to determine the mathemati-cal trend of guest registration. This estimate will help the hotel determine whether future expansion will be needed. Given the following time-series data, develop a regression equation relat-ing registrations to time (e.g., a trend equation). Then forecast year 11 registrations. Room registrations are in the thousands:Year 1: 17 Year 2: 16 Year 3: 16 Year 4: 21 Year 5: 20Year 6: 20 Year 7: 23 Year 8: 25 Year 9: 24
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units)Feb. 19Mar. 18Apr. 15May 20Jun. 18Jul. 22Aug. 20 Forecast September sales volume using each of the following: (1)The naive approach. (2)A five-month moving average. (3)A weighted average using .60 for August, .30 for July, and .10 for June.
Pls do fast within 5 minutes and i will give like for sure Solution must be in typed form

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