Question: Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 320 290 February 440

Here are the data for the past 21 months for actual sales of a particular product:

LAST YEAR THIS YEAR
January 320 290
February 440 355
March 450 355
April 480 465
May 455 418
June 455 350
July 380 340
August 340 292
September 400 335
October 480
November 585
December 540

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. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.)

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!