software

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 gt; 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