1. Business
  2. Operations Management
  3. question 13 demand data for thirty days have been provided...

Question: question 13 demand data for thirty days have been provided...

Question details

Question 13:

Demand data for thirty days have been provided, along with computed weighted moving average forecasts for days six to thirty, using weights of 0.5, 0.3, 0.1, 0.05, and 0.05, with the largest weight on most recent demand. Please compute the Mean Suared Error (MSE) for the 25 forecasts, and then use SOLVER to find the five weights that will minimize the MSE. Note that your weights must sum to one, and it is OK for some of the weights to be zero.

Report your new (optimized) value for the MSE, to two decimals.

QUESTION 13 Demand data for thirty days have been provided, along with computed weighted moving average forecasts for days six to thirty, using weights of 0.5, 0.3, 0.1, 0.05, and 0.05, with the largest weight on most recent demand. Please compute the Mean Suared Error (MSE) for the 25 forecasts, and then use SOLVER to find the five weights that will minimize the MSE. Note that your weights must sum to one, and it is OK for some of the weights to be zero. Report your new (optimized) value for the MSE, to two decimals. Workbook

Home Insert Page Layout Formulas Data Review View Calibri (Body) Paste J27 0.05 0.05 4 0.5 WMA 6 Weekt) Demand (D,) Forecast (F.J 686 700 692 695 10 681 677 687.50 『 681.90 678.05 680.50 6 675 683 681 693 682 697 704 707 698 695 683 688 694 679 13 14 15 680.80 686.70 684.90 690.60 17 18 19 20 21 12 13 698.00 703.15 700.45 697.65 690.35 688.65 691.35 685.40 685.65 678.40 678.95 679.15 676.20 16 17 18 19 20 23 25 26 27 28 29 30 31 32 688 670 681 679 673 671 670 672 23 25 26 27 28 29 30 672.85 671.60 671.70 34 35 36 37 38 668.80 673 DATA

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution