Question

Here are the data for the past 21 months for actual sales of a particular product:LAST YEAR THIS YEARJanuary 325 260February 440 380March 450 370April 440 420May 380 440June 460 360July 410 375August 370 300September 345 380October 510November 560December 540Develop 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.)

Answer 1

Fore cadet for fourth quarter us $1085

Step-by-step explanation:

One Quarter = 3 months

Demand for quarter 1 = 325 + 440 + 450 = 1215

Quarter Demand in Each Quarter Weighted Forecast

1 1215

2 1280

3 1125

4 1610

5 1010

6 1220

7 1055

8 1085

Weighted moving Average Forecast = ((0.25 * 1010) + (0.25 * 1220) + ( 0.5 * 1055) = 1085

Forecast for the fourth quarter is 1085