I don't understand how to calculate this. Can you teach me how to solve for a 4 month moving average where the weights are 0.4, 0.3, 0.2, and 0.1 used in order with the largest weight being applied to the most recent month, what is the forecast for July?
Month Demand
January 117
February 110
March 125
April 117
May 121
June 125
July