Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve ALL parts in excel thank you. The following gives the number of pints of type B blood used at Woodlawn Hospital in the

Please solve ALL parts in excel thank you.
image text in transcribed
image text in transcribed
The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: a. Forecast the demand for the week of October 12 using a 4week moving average. b. What is the MAD? c. Use a 4-week weighted moving average, with weights of .1, .1,.2, and .6 using .6 for the most recent week. Forecast demand for the week of October 12 . d. What is the MAD? e. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 363 and =,47 f. What is the MAD? g. Based on evaluating all three forecasting models, which forecast should be chosen

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Project Management

Authors: Kathy Schwalbe

6th Edition

978-111122175, 1133172393, 9780324786927, 1111221758, 9781133172390, 324786921, 978-1133153726

More Books

Students also viewed these General Management questions