I need to calculate the weighted moving average to forecast #5 sales with weights 0.1, 0.3 and 0.6. I am being given #2 thru #6. Sales are: #2 = 21, #3 = 23, #4 = 21, #5 = 20, #6 = 15I'm confused...

I need to calculate the weighted moving average to forecast #5 sales with weights 0.1, 0.3 and 0.6. I am being given #2 thru #6. Sales are: #2 = 21, #3 = 23, #4 = 21, #5 = 20, #6 = 15 I'm confused because it appears that I don't need #6 at all. Is this the correct formula: F5 = A4*0.6 + A3*0.3 + A2* 0.1 F5 = 21.6