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 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
1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are conducting an inventory control study of all their items. The following data for the year 2006 are for one such item, which is not seasonal. [10 Points] Month Sales Jan Feb 18 19 Mar Apr May Jun 17 21 20 19 Jul 20 Aug 23 a. Use trend projection to estimate the relationship between time and sales (state the trend line equation in this problem). b. Calculate forecasts for February 2007, April 2007, and February 2008
Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 a. Construct a time series plot. What type of pattern exists in the data? Trend Pattern Seasonal Pattern Horizontal Pattern O Trend and Seasonal Pattern Question 11 5 pts b. Create the following dummy variables: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Create a variable t such that t = 1 for quarter 1 of year 1, t = 2 for quarter 2 of year 1, ..., t = 12 for quarter 4 of year 3. Use these dummy variables and t to develop an estimated regression equation to account for seasonal effects and any linear trend in the data. What is the forecast for quarter 1 of next year?
Descriptive statistics for the closing stock prices of two companies for several trading periods are shown below. Baba, Inc Maman, Inc. Mean 4.00 Mean 15.91 Standard Error 0.11 Standard Error 0.29 Median 3.92 Median 16.59 Mode 4.19 Mode 15.58 Standard Deviation 1.12 Standard Deviation 3.21 Sample Variance 1.25 Sample Variance 10.31 Kurtosis -1.15 Kurtosis 3.52 Skewness 0.08 Skewness -2.09 Range 3.95 Range 13.45 Minimum 2.03 Minimum 5.55 Maximum 5.98 Maximum 18.99 Sum 436.32 Sum 1972.61 Count 109 Count 124 Which company's stock price has a more dispersed distribution? Maman, Inc. Baba, Inc.
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 350 370 410 381 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376.67 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.35, and 0.45, using 0.45 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.) 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 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…
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).
b. Compute 2s control limits for each forecast. (Do not round your intermediate calculations. Round your answers to 2 decimal places.) Forecast Method 1 Method 2 Control Limits
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…

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