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

QUESTION 13 Demand data for thirty days have been

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 B D E F H L 1 0.05 2 0.05 0.1 3 4 0.3 5 0.5 WMA Forecast (Fr) 6 Week (t) 7 1 Demand (D) 686 700 692 8 N 9 3 10 4 695 11 5 681 12 6 677 13 7 675 14 8 683 15 9 681 16 10 693 17 11 682 18 12 697 19 13 14 15 20 21 22 23 24 16 17 704 707 698 695 683 679 671 679 679 18 687.50 681.90 678.05 680.50 680.80 686.70 684.90 690.60 698.00 703.15 700.45 697.65 690.35 684.15 677.15 677.60 678.40 674.10 676.90 678.70 675.75 672.85 671.60 671.70 668.80 25 19 26 27 28 20 21 22 670 681 29 23 30 24 679 31 25 673 32 26 671 33 27 670 34 28 672 35 29 666 36 30 673 37 DATA

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!

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

MGMT 3306 Assignment 1 (Due at 11:59 pm Feb 14 CST) Instructions: 1. Please answer the assignment questions in this docx file and save once you're satisfied. Assignment 1 covers the lectures slides...

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

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

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

HTM Realty has a storefront rental property in downtown Draperton, a small college town next to the Tech campus. The property encompasses four business spaces that open onto College Avenue. HTM has a...

1. Solar Insolation We will be using the term Solar Insolation a lot in this course, and your probably have not used it before. Numerical activity: a) Melbourne has an annual solar irradiation of...

A forward contract is different from a futures contract in which of the following way? There is no credit risk in a forward contract. The counterparties of a forward contract are unknown. The forward...

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