Question: 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,

Demand data for thirty days have been provided,

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 A B 1 2 a 4 5 0.05 0.05 0.1 0.3 6 WMA Forecast Ft) Week (t) 7 8 9 10 11 12 12 14 15 16 17 18 19 2 3 4 5 6 7 8 9 10 12 20 21 13 14 15 Demand (DE) 686 700 692 695 681 699 675 683 681 693 702 697 704 707 69B 695 683 688 694 679 688 670 681 679 673 688 670 672 666 673 17 18 19 20 22 22 24 25 26 27 28 29 30 31 687.30 692.90 684.65 682.70 681.90 687.80 694.90 696.60 700.00 704.15 701.45 697.65 690.35 688.65 691.35 685.40 685.65 678.40 678.95 679.15 676.20 681.35 676.70 673.40 669.65 21 22 23 22 24 25 26 27 28 29 30 35

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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...

Final Project Assignment SCM 301 Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The purpose of...

Answer questions 5 & 6 please. I will downvote if not. Throx sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution...

Here is all the information provided with the answers to Q 1 and 2. If someone could please help me with 3 and 4. There is no more information or references provided other than what is above. 3) This...

Provide the company with the following recommendations for FY2020 to improve SCM performance, based on analysis of available data and appropriate methods from SCM 301. Be sure to justify your...

Use data in worksheet named Q1-4 to answer questions 1 4. Assume the sample data was published in a business magazine. 1) Which of the following is true about the data? A. Class is qualitative and...

Comp sells higher-end custom-design socks in three-sock sets (rather than the customary two sets). The company operates from a small packaging and distribution facility in Richmond, CA from which it...

Company Background Information Throx sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution facility in Richmond, CA...

The Valley Wine Company produces two kinds of wineValley Nectar and Valley Red. The wines are produced from 64 tons of grapes the company has acquired this season. A 1,000-gallon batch of Nectar...

Analyze the following data to determine the total annual cost of making or buying a part. Freight Cost Expected annual quantity Variable cost per unit Annual fixed costs Make 20,000 units. $5.00...

What are "home - made dividends" and why would investors "make" them? A 0 Home - made dividends represent sales of stock by relatively impatient investors. 8 Home - made dividends represent purchases...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...