contestada

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 370 295 February 415 350 March 405 355 April 435 440 May 430 450 June 495 385 July 415 365 August 330 290 September 385 350 October 515 November 600 December 495 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Solve the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.)

Respuesta :

Answer:

Here in this question, I have used tables to show you more clearly. So please refer to the attachment 1.

Explanation:

Please refer to the attachment 1.

Weighted Moving Average = ∑Quantity*Weights/ ∑weights

Forecast for Oct: (350*0.5 + 290*0.25 + 365*0.25)/ 0.5 + 0.25 + 0.25 = 338.75 0r 339

Forecast for Nov: (339*0.5 + 350*0.25 + 290*0.25)/ 0.5 + 0.25 + 0.25 = 329.5 0r 330

Forecast for Dec: (330*0.5 + 339*0.25 + 350*0.25)/ 0.5 + 0.25 + 0.25 = 337.25 0r 337

Ver imagen adnansoomro2019

Otras preguntas