Question: Estimate sales again with a weighted moving average in which sales in the most recent week are given a weight of 3, sales in the

Estimate sales again with a weighted moving average in which sales in the most recent week are given a weight of 3, sales in the second most recent week are given a weight of 2, and sales in the third most recent week are given a weight of 1. WEEK Demand 3 week weighted moving average ABS 1 310 2 325 3 340 4 330 5 350 6 360 7 (2 pts) Prediction for week 7 (3 week weighted moving average): ______________________ (2 decimal places) (2 pts) MAD for 3 week weighted moving average: ___________________ (2 decimal places) (2 pts) Which method do you think is better (3 week moving average or 3 week weighted moving average?________________________ Why?_____________________________

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 Mathematics Questions!

5-20 Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given in Problem 5-17. Assume that last period's forecast for year 1 is 5,000 bags to begin the...

The information obtained from 5-17 is needed in order to solve 5-18 and 5-20. That is why they are all put together. Thank you! 5-17 Data collected on the yearly demand for 50-pound bags of...

Need asnwer for 5-19 182 CHAPTER 5 FORECASTING 9: 5-17 Data collected on the yearly demand for 50-poundton : 5-23 W bags of fertilizer at Wallace Garden Supply are shown in the following table....

Options: 9 9.67 10.2 Not enough information An advertising agency uses exponential smoothing method to forecast the number of viewers for a TV show that is broadcasted every Tuesday night. The...

for the second most recent observation, and for third most recent observation, compute a three-week weighted moving average for the time series. (Round your (a) Using a weight of for the most recent...

1. The owner of Limp Pines Resort wanted to know the average age of its clients. A random sample of 25 tourists is taken. It shows a mean age of 46 years with a standard deviation of 5 years. The...

Question 57 Not yet wred Marked out of 500 Plaquests A company would like to forecast the Automobile Tire Sales based on the weighted moving average method. The weight is 3 for the most recent month,...

Using the 4 weeks of data below, forecast sales for the fifth week using a 3 - week weighted moving average. The most current weight is 0 . 5 , and the oldest weight is 0 . 2 . ( round to nearest...

A . What are the stages inspection is done and related documents in engineering industry? B . Describe & present the document based on which the inspection is carried out. C . Use a 3 period weighted...

Please answer in Excel and show formulas. A. The annual demand for lime bags at McCall's Garden Supply for the past 11 months is provided in the image below. Use 2-month, 3-month, and 4-month moving...

Repeat Exercise 1 using the Gauss-Seidel method. In Exercise 1 a. 3x1 x2 + x3 = 1, 3x1 + 6x2 + 2x3 = 0, 3x1 + 3x2 + 7x3 = 4. b. 10x1 x2 = 9, x1 + 10x2 2x3 = 7, 2x2 + 10x3 = 6. c. 10x1 + 5x2 = 6,...

The operations manager of a body and paint shop has five cars to schedule for repair. He would like to minimize the throughput time to complete all work on these cars. Each car requires body work...

A probability sampling wherein chance and system are used to determine the membership in the sample. Question 99Select one: a. Cluster sampling b. Simple random sampling c. Systematic sampling with a...

You have been asked to determine the amount available for the unsecured claims, calculate the cents on the dollar that the unsecured creditors are estimated to get, and calculate the estimated...