The number of items sold over a four-month period are: month 1 2 3 4 sales 5100 5500 5400 5600 Calculate the forecasts for the 4th and 5th months using 3-month weighted moving average method with weights of 0.6 for the most recent month and 0.3 for the next to the most recent month. Further, suppose that the exponential smoothing constant α=0.5. Then calculate the forecasts for 3rd, 4th and 5th months, using exponential smoothing method. Under the 3-month weighted moving average method, what is the forecast for the fourth month?

Question

09-04-2021
Mathematics

contestada

The number of items sold over a four-month period are: month 1 2 3 4 sales 5100 5500 5400 5600 Calculate the forecasts for the 4th and 5th months using 3-month weighted moving average method with weights of 0.6 for the most recent month and 0.3 for the next to the most recent month. Further, suppose that the exponential smoothing constant α=0.5. Then calculate the forecasts for 3rd, 4th and 5th months, using exponential smoothing method. Under the 3-month weighted moving average method, what is the forecast for the fourth month?

Respuesta :

Otras preguntas

Which of the following statements is true with respect to protonema? It gives rise to sporophyte. It produces male gametes. It gives rise to gametophyte.

George studied 3/4 hour on monday and 7/8 hour on tuesday. how long did he study altogether on both days?

In the first section of Beowulf, which part is most clearly exposition? A. The tense verbal exchange between Unferth and Beowulf. B. The fight between Beowulf

According to Aristotle, the events of a tragedy are connected through __________. 1. diction 2. song 3. thought 4. plot

Appeals to logos were common in colonial era rhetoric because so many people believed in _____. A. Romanticism B. Patriotism C. Rationalism D. Symbolism

order these numbers from least to greatest. −11.6 , 11510 , −837 , −133

arrange following nbers in increasing order 2.3 45.1 18.735 0.9862 7

What is the area of the triangle?

Analogy: splitting nuclei is to ____________ as joining nuclei is to __________. fission; fusion fusion; fission bonding; splitting fission; bonding

What must the turgor pressure equal if there is no net diffusion between the solution and the cell?

good job

Omm2 Omm2 · Answer 1 · 2021-04-12T19:34:24+02:00

Answer:

By using 3-month weighted moving average method -

Forecasts for the 4th month = 5400

Forecasts for the 5th month = 5530

By using Exponential smoothing method -

Forecasts for 3rd month = 5300

Forecast for 4th month = 5350

Forecast for 5th month = 5475

Step-by-step explanation:

To find - Calculate the forecasts for the 4th and 5th months using 3-month weighted moving average method.

Calculate the forecasts for 3rd, 4th and 5th months, using exponential smoothing method.

Proof -

Given that,

month 1 2 3 4

sales 5100 5500 5400 5600

F(4) = 0.6 A(3) + 0.3 A(2) + 0.1 A(1)

= 0.6 [ 5400] + 0.3 [ 5500] + 0.1 [ 5100]

= 3240 + 1650 + 510

= 5400

⇒forecasts for the 4th month = 5400

Now,

F(5) = 0.6 A(4) + 0.3 A(3) + 0.1 A(2)

= 0.6 [ 5600] + 0.3 [ 5400] + 0.1 [ 5500]

= 3360 + 1620 + 550

= 5530

⇒forecasts for the 5th month = 5530

Now,

Given that, the exponential smoothing constant α=0.5

Month Sales Forecast

1 5100 5100

2 5500 5100 + 0.5(5100 - 5100) = 5100

3 5400 5100 + 0.5(5500 - 5100) = 5300

4 5600 5300 + 0.5(5400 - 5300) = 5350

5 5350 + 0.5(5600 - 5350) = 5475

∴ we get

By using Exponential smoothing method -

Forecasts for 3rd month = 5300

Forecast for 4th month = 5350

Forecast for 5th month = 5475