4.1 The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of Pints Used August 31 September 7 September 14 September 21 September 28 October 5 360 389 410 381 368 374 a) 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 .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = .2.

4.1 The following gives the number of pints of type A blood used at Woodlawn Hospital in the past 6 weeks: Week Of Pints Used August 31 September 7 September 14 September 21 September 28 October 5 360 389 410 381 368 374 a) 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 .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = .2.

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

Related questions

Q: Discuss Qualitative forecasting technique. Explain the situations where we use Qualitative methods.…

A: Forecasting is the process of making assumptions of the future on the basis of past and present data…

Q: Discuss when to use a time series forecasting techniques ?

A: Historical data, and hence projected variables, are subjected to statistical analysis. The…

Q: Explain the benefits does exponential smoothing have over moving avarages as a forecasting tool ?

A: While in Moving Averages the previous perceptions are weighted similarly, Exponential Smoothing…

Q: orecasting is the primary function for predicting the future using the available data to make the…

A: Forecasting is the primary function for forecasting the future and making decisions based on the…

Q: he formula of exponential smoothing method of forecastin

A: Exponential smoothing is a time series forecasting method for univariate data. Exponential smoothing…

Q: Discuss the basic assumptions made when using time series forecasting techniques as opposed to…

A: Several assumptions are made during the Time Series Initial Phase.

Q: The moving average forecasting method is typically bestfor products:a) Functional b) Innovativec)…

A: The correct answer is option c) Mature. Moving Average formula is used to average the number of…

Q: What advantages does exponential smoothing have over movingcaverages as a forecasting tool?

A: The following are the benefits of exponential smoothing as a forecasting tool over moving averages.…

Q: Explain the basic assumptions made when using time series forecasting techniques as opposed to…

A: The Time Series Initial Phase makes a variety of assumptions.

Q: Discribe how to determine an appropriate method for calculating the forecast error and discuss the…

A: The process of forecasting involves making predictions about the future based on historical data and…

Q: When should time series forecasting techniques be used?

A: The statistical data and, as a consequence, the projected features are analyzed using statistical…

Q: Describe and evaluate the method of forecasting based on a time series analysis when a trend is…

A: Forecasting is the practice of estimating the size of unknown future events and generating different…

Q: How is forecasting accuracy measured? (Provide a definition for “forecasting error” and mention two…

A: Forecasting is used in all kinds of departments and industries. Some of the areas where this is…

Q: What does the term biased mean in reference to a particular forecasting technique?

A: The forecasting techniques are used for predicting the future demand and sales of the product. The…

Q: Describe what "prediction" means for forecasting models.

A: Forecasting is the process of predicting the future demand according to the previous data and…

Q: Discuss when is time series forecasting used?

A: Forecasting is a strategy for forecasting future events using historical data and knowledge.

Q: Explain the similarities and differences between quantitative forecasting and qualitative…

A: Forecasting refers to the process of making predictions for the future using past and present data.…

Q: There are two general methods to forecasting:Even, what is their meaning?

A: The organization's forecasting is critical. External forces are used to forecast, and a few…

Q: Which qualitative forecasting technique was developed to ensure that the input from every…

A: Delphi method.

Question

100%

Please solve the show solution for the FORECASTING problem. Thanks

4.1 The following gives the number of pints of type A
blood used at Woodlawn Hospital in the past 6 weeks:
Week Of
Pints Used
360
August 31
September 7
September 14
September 21
September 28
October 5
389
410
381
368
374
a) 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.1, .3,
and .6, using .6 for the most recent week. Forecast demand for
the week of October 12.
c) Compute the forecast for the week of October 12 using exponential
smoothing with a forecast for August 31 of 360 and a - .2.

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Explain how CPFR can be used to reduce forecasting error.
What benefits does exponential smoothing have over moving averages as a forecasting tool?
Give three examples of unethical conduct involving forecasting and the ethical principle each violates
Briefly describe the steps that are used to develop a forecasting system. Using a forecasting problem, illustrate each of these steps. Which step do you think is most important? Why?
Explain different forecasting techniques like moving averages, exponential smoothing, regression etc.
Explain how do exponential smoothing have benefits over shifting averages as forecasting tool ?
Describe the various types of time-series and associative forecasting models. Which types of organizations are each of these most applicable to, and why?
The worksheet Hudson Demand Case Data in MindTap provides the number of visits over one year from January to December (52 weeks). Chart the data and explain the characteristics of the time series. How would you forecast future demand for customer visits? What criteria will you use to determine a “good” forecast? What methods would you use, and why? What is your final recommendation with respect to a forecasting method? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Define time-series forecasting model and give examples.
Explain why is accurate forecasting so important to companies that use a continuous replenishment inventory system?
Discuss the importance of the forecasting in the business world.
Discuss the techniques of forecasting and its types. Also explain the limitations of each technique?