contestada

Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 310 270 February 405 365 March 380 360 April 470 455 May 415 395 June 490 400 July 440 340 August 325 260 September 375 360 October 540 November 595 December 515 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 :

Tundexi

Answer:

1041.25

Explanation:

Quarterly sales of most recent quarter Q3 = 340 + 260 + 360 = 960

Quarterly sales of most recent quarter Q2 = 455 + 395 + 400 = 1,250

Quarterly sales of most recent quarter Q1 = 270 + 365 + 360 = 995

Using 3 quarter weighted moving average:

F4 = 0.5(Q3) + 0.25(Q2) + 0.25(Q1)

F4 = 0.5(960) + .025(1250) + 0.25(995)

F4 = 1041.25

Hence, forecast for the fourth quarter using a three-quarter, weighted moving average is 1041.25

Otras preguntas