Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started