Aging Stock

[eptaqlik]

How to solve this problem?

I have record with material, current stock, consumption period A, B, C, D, E

I would like to have an indication of what period I will go to exhaust my stock by assuming that consumption in the coming months will be like those of the previous ones.

In the excel file the result I would like.

Many tks in advance.

Ciao

Marco