Question: (a) Determine the forecast for period 6 using 4 period weighted moving average Three weights, such as 0.15, 0.55, and 0.20 are given . The

(a) Determine the forecast for period 6 using 4 period weighted moving average Three weights, such as 0.15, 0.55, and 0.20 are given . The sales for the last 5 periods are 95, 75, 155, 85 and 70.

(i)(3 points) Compute the fourth weight

(ii)(15 points) Obtain the forecast for period 6 using 4 period weighted moving average.

(b) (7 points) Compute the MAD for the following problem.

Period Sales Forecast

1 91 82

2 110 130

3 80 75

4 75 83

5 113 115

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!

As of 30 April 2011, PLR Corporations accounts payable subsidiary ledger included the following information: PLR completed the following transactions in May 2011: Date Transaction 1...... Paid half...

2. (Total 25 points) (a) Determine the forecast for period 6 using 4 period weighted moving average Three weights, such as 0.15, 0.55, and 0.20 are given. The sales for the last 5 periods are 95, 75,...

- 2 - 2. (Total 25 points) (a) Determine the forecast for period 6 using 4 period weighted moving average Three weights, such as 0.15,0.55, and 0.20 are given. The sales for the last 5 periods are...

Using Data Set E1, what would be the forecast for period 6 using a 3-period weighted moving average? The weights are 0.50, 0.30, 0.20. (Choose the closest answer.) Data Set E1 Period Sales Volume 1...

1. In order to decrease the responsiveness of a forecast made using the exponential smoothing technique, what can we try? Describe with regards to smoothing constant value. 2. While monitoring the...

Given the data below, develop a forecast for period 6 using a four-period weighted moving average and weights of 0.4 for the most recent period, 0.3 for the next most recent period, 0.2 for the next...

Given the data below, develop a forecast for period 6 using a four-period weighted moving average and weights of 0.4 for the most recent period, 0.3 for the next recent period, 0.2 for the next, and...

could you solve it with explain it please 1. Mahmoudco Scooters wants to estimate demand for the next two quarters for scooters in the market. Sales data consist of trend and seasonality. a. Quarter...

Given the following data, develop a demand forecast for period 7 using a 4-period weighted moving average, with weights of 0.10, 0.15, 0.30, and 0.45, where 0.45 is used for the most recent week....

Two examples of massively mismanaged projects are TAURUS and the Big Dig. The first, formally called the London Stock Exchange Automation Project, cost $575 million before ft was finally abandoned....

What is the basis for the separation of proteins by the following techniques? (a) Gel-filtration chromatography (b) Affinity chromatography (c) Ion-exchange chromatography (d) Reverse phase HPLC

Which of the following statements is incorrect? Question 11Select one: a. The normal balance of an expense account is a credit. b. The normal balance of the accounts receivable account is a debit. c....

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