G
Gizmo63
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
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