What is the forecast for July based on a three-month weighted moving average applied to the following past demand data and using the weights: 8, 6, and 4 (largest weight is for most recent data)? Show all of your computations for April through July.
Month Actual Demand (A)
January 40
February 45
March 57
April 60
May 75
June 87
July