1. Solve manually. The following gives the number of pints of type A blood used atWoodlawn Hospital in the past 6 weeks.Pints Used360WeekAugust 31September 7September 14September 21September 28389410381368October 5374a. Forecast the demand for the week of October 12 using a 3-week moving average.b. Use a 3-week weighted moving average, with weights of 0.1, 0.3 and 0.6, using 0.6 forthe most recent week. Forecast demand for the week of October 12.c. Compute the forecast for the week of October 12 using exponential smoothing witha forecast for August 31 of 360 and c=0.2.d. Compute the MAD for the 3-week moving average, 3-week weighted moving averageand exponential smoothing models above.

Answered: 1. Solve manually. The following gives…

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 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…
Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
14. The demand for Krispee Crunchies is experiencing a decline. The company wants to monitor demand for this product closely as it nears the end of its life cycle. The following table shows the actual sales history for January to October. Generate forecasts for November to December, using the trend projection with regression method. Looking at the accuracy of its forecasts in the Trend Projection Worksheet, as well as the other statistics provided, how confident are you in these forecasts for November to December? Month January February March April May June Sales 890,000 800,000 825,000 840,000 730,000 780,000 Month July August September October November December Sales 710,000 730,000 680,000 670,000
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…
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).
Sales of the Crown Gems have been increasing over the past five years. The operations manager has estimated sales in 2017 to be 410 Crown Gems. Using exponential smoothing with a weight of α = 0.30, the forecasts for 2017 through 2022 were developed. The forecasts for 2017 through 2022 is: Year Forecast 2016 450 2017 450 2018 463.5 2019 479.85 2021 504.795 2022 528.5565 a. Advise Crown Gems of the benefits associated with this method of forecasting. b.Caution the manager on the limitations associated with your forecast.
Problem 3
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…
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
8
The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6 weeks: a) Forecast the dema nd for the week of October 12 using a3-week moving average.b) Use a 3-week weighted moving average, with weights of .I , .3,and .6, using .6 for the most recent week. Forecast demand forthe week of October 12.c) Compute the forecast for the week of October 12using exponentialsmoothing with a forecast for August 31 of 360 and a = .2
(Use an excel file to show formulas used)

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