Question: The sales data for Walmart for 20 weeks are provided. Create a weighted 3WMA and an exponential smoothing forecast and then determine the optimal weights

The sales data for Walmart for 20 weeks are

The sales data for Walmart for 20 weeks are provided. Create a weighted 3WMA and an exponential smoothing forecast and then determine the optimal weights and alpha. Do not start with 0, 1, or blank for the weights or alpha Calculate the MSE for the two sets of forecasts. List the used weights and alpha. Create a line chart showing the sales, W3WMA, exponential smoothing Week 1 1 2 3 4 5 6 7 8 9 10 Sales 1,526 1,929 1,704 1,423 1,430 1,410 1,478 1,698 2,223 2,420 1,938 2,053 2,412 1,939 2,845 2,290 2,618 2,309 2,474 3,038 11 12 13 14 15 16 17 18 19 20

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!

Week Four Homework Assignment - Forecasting Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several...

Week Four Homework Assignment Ajax Manufacturing is an electronic test equipment manufacturing firm that markets a certain piece of specialty test equipment. Ajax has several competitors who...

1. Carol's Auto Sales has sold the following number of cars in the last 6 months: Jan 370 Feb 352 Mar 405 Apr 390 May 372 Jun 471 a) calculate a 3-month moving average forecast for July b) calculate...

Notes: 1 . Problems 2 - 5 require the use of a spreadsheet application like Excel. The relevant Excel Refresher will be held either in class on June 2 7 , 2 0 1 9 or at any office hour on June 2 6 -...

Answer 8. question 8: Discuss considerations and potential issues with the implementation for each of your recommendations: FY2021 forecast, EOQ&ROP, Supplier, Transportation, and Location. What...

The three major types of forecasts used by organizations in planning future operations are: A) strategic, tactical, and operational. B) economic, technological, and demand. C) exponential smoothing,...

Back round: Wes and Steve are partners in a lunch truck company that operates a central kitchen and operates lunch trucks that travel to various locations in Philadelphia, Monday-Friday. The lunch...

What type of company was studied? What kind of product did they sell? What is their geographic reach? Why is demand forecasting in this business? What types of models did the author use? Please give...

1. Lehigh University wants to design a control chart to monitor whether course registration forms are being completed correctly. The university intends to use the chart to see if improvements in the...

The bond dissociation energy for different bonds are given below EH-H = 1042kcal mol 1; Ect-ci = 58k. EH-CI = 432kcal mol ; Electronegativity of hydrogen = 2.05 The elctronegativity of chlorine is...

Find the gravitational force between a particle of mass m and a solid cylinder of radius R and mass Ma distance z apart.

8. Size of Accounts Receivable (LO1) The Thaddee Corporation sells on credit terms of net 30. Its accounts are, on average, four days past due. If annual credit sales are $9.75million, what is the...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...