The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: Week Of Pints Used August 31 360 September 7 389 September 14 410 September 21 381 September 28 368 October 5 374 a. Forecast the demand for the week of October 12 using a 4-week moving average. [Select] b. What is the MAD? [Select] c. Use a 4-week weighted moving average, with weights of .1, .3, .6, and .8 using .8 for the most recent week. Forecast demand for the week of October 12. [Select] d. What is the MAD? [Select] e. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 363 and a = .47 [Select] f. What is the MAD? [Select] g. Based on evaluating all three forecasting models, which forecast should be chosen? [Select]

The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: Week Of Pints Used August 31 360 September 7 389 September 14 410 September 21 381 September 28 368 October 5 374 a. Forecast the demand for the week of October 12 using a 4-week moving average. [Select] b. What is the MAD? [Select] c. Use a 4-week weighted moving average, with weights of .1, .3, .6, and .8 using .8 for the most recent week. Forecast demand for the week of October 12. [Select] d. What is the MAD? [Select] e. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 363 and a = .47 [Select] f. What is the MAD? [Select] g. Based on evaluating all three forecasting models, which forecast should be chosen? [Select]

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Similar questions

The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
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).
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 360 September 7 389 September 14 412 September 21 383 September 28 366 October 5 374 a) The forecasted demand for the week of October 12 using a 3-week moving average LOADING... = 374.33374.33 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 = 372.55372.55 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,…
The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: Pints Used Week Of August 31 360 September 7 389 September 14 410 September 21 381 September 28 368 October 5 374 a. Forecast the demand for the week of October 12 using a 4-week moving average. [Select] b. What is the MAD? [Select] 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. [Select ] d. What is the MAD? [Select ] > e. Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 363 and a = [Select] .47 f. What is the MAD? [Select] g. Based on evaluating all three forecasting models, which forecast should be chosen? [Select]
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 389 412 383 366 371 a) The forecasted demand for the week of October 12 using a 3-week moving average decimal places). pints (round your response to two
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.)
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales(000)Units Feb. 15 Mar. 23 Apr. 12 May. 25 Jun. 19 Jul. 28 Aug. 26 Forecast September sales volume using each of the following: (1) A linear trend equation
page 4 of 19) - Google Chrome squ.edu.om/mod/quiz/attempt.php?attempt3D1245076&cmid%3663426&page%3D3 earning System (Academic) erations Management || fall20 Quiz stion 4 Mean Absolute Deviation (MAD) is the always the best in assessing a forecast model accuracy yet vered Select one: ked out of O a. True O b. False Hajir lag question 13 Next page 10 19
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of Pints Used August 31 September 7 September 14 September 21 September 28 345 370 410 378 368 October 5 371 a) The forecasted demand for the week of October 12 using a 3-week moving average = 372.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.30, and 0.55, using 0.55 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.)