Problem 4.1 Question Hel 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 345 372 412 383 368 374 a) The forecasted demand for the week of October 12 using a 3-week moving average - 373.33 pints (round your response to two decimal places). October 5 371 a) The forecasted demand for the week of October 12 using a 3-week moving average - 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 - 372.40 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) -) If the forecasted demand for the week of August 31 is 350 and 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). b) Using a 3-week weighted moving average, with weights of 0.20, 0.30, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 - 372.40 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 350 and a = 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) Week of Pints Used Forecast for this Date August 31 350 350 September 7 370 350.00 September 14 408 September 21 378 368.25 September 28 370.69 October 5 371 370.77 October 12 370.83 355 00 371 Question is complete. Tap on the red indicators to see incorrect answers Score: 0 of 1 pt 7 of 8 (8 complete) HW Score: 75%, 6 of 8 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: 3 3,450 4 3,750 5 3.750 Year 2 Mileage 3.100 3,950 a) Using a 2-year moving average, the forecast for year 8 miles (round your response to the nearest whole number). e a) Using a 2-year moving average, the forecast for year 6 = 3,775' miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = 75.0 miles (round your response to one decimal place). (Hint: You will have any 3 years of matched data.) C) The forecast for year 6 using a weighted 2-year moving average with weights of 0.45 and 0.55 (the weight of 0,55 is for the most recent period) = 3.778 miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.45 and 0.55 = 92.5 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) d) Using exponential smoothing with a = 0.30 and the forecast for year 1 being 3,100, the forecast for year 6 = 3,593 miles (round your response to the nearest whole number) Question is complete. Tap on the red indicators to see incorrect answers