Hi all, this is a re-post as I could really use some help on this.

I'm guessing there could be an accounting style function that may work for
this; it's like taking a total loan value, planning a series of variable
repayments and then asking at what point in the 'repayment plan' does the
'owed' value hit zero. e.g. the 5th payment or 9th or whatever.

"Gizmo63" wrote:

Hi folks,

Stock cover is usually based on history or a weeks snap shot (simply 10k of
stock with last week sales @ 2k = 5 weeks) buit this is not what I'm after.

Is there a function or cunning formula that will looks into the future
within a defined array and effectively say when stock would be exhausted e.g.

Sales forecast by week: 20 - 10 - 15 - 5 - 32
Open Stock at now: 47
Therefore looking ahead means that the stock will run out in less than 4 weeks
i.e. 20+10+15+5 47
Likewise 80 of stock would last less than 5 weeks.

In a nutshell I want to use the forecasted sales rather than history. Using
a hidden cumulative row is not really an option as the next stage would be to
extend the stock into forecasts to build a stock cover pattern for the future.

A macro is not an option, it has to be formula contained.

Any help and cunning solutions gratefully accepted.

Giz