The Beta automobile dealer in Quezon Avenue area wants to accurately forecast demand for the Beta special edition car during the next month. Because the distributor is in Korea, it is difficult to send cars back or reorder if the proper number of cars is not ordered a month ahead. From sales records, the dealer has accumulated the following data for the past year.
Month(Past Yeas) Cars (Demand)
January 60
February 70
March 50
April 90
May 10
June 80
July 150
August 70
September 110
October 150
November 130
Required:
a. Compute the three and five-month moving average forecast of demand.
b. Determine the weighted moving average.