Hi,
I have calculated the par levels for weekly ordering and thats fine.
I am trying to figure out a formula which can calculate me the amount to be ordered on the basis of the closing stock on a Sunday night.
For example :
Par level for Anchovies is 35 pkts ( in cell c3)
Closing stock for Anchovies is 24 ( this is on another sheet called "average use")
It would be easy to calculate 35-24 , however the case size for Anchovies is 24 pcs in one box. I cannot order less.
So if the quantity goes below 35 pkts, what formula would give me the figure "1" ( which would mean 1 box) in cell D3 , where I want the "To order" quantity to be.
Makes sense.??
I have a whole list of about 100 items with different case sizes. It would be fantastic , if I could just feed the closing stock and it calculates me what to order, in the particular case size
ANy help would be highly appreciated
Many thanks
I have calculated the par levels for weekly ordering and thats fine.
I am trying to figure out a formula which can calculate me the amount to be ordered on the basis of the closing stock on a Sunday night.
For example :
Par level for Anchovies is 35 pkts ( in cell c3)
Closing stock for Anchovies is 24 ( this is on another sheet called "average use")
It would be easy to calculate 35-24 , however the case size for Anchovies is 24 pcs in one box. I cannot order less.
So if the quantity goes below 35 pkts, what formula would give me the figure "1" ( which would mean 1 box) in cell D3 , where I want the "To order" quantity to be.
Makes sense.??
I have a whole list of about 100 items with different case sizes. It would be fantastic , if I could just feed the closing stock and it calculates me what to order, in the particular case size
ANy help would be highly appreciated
Many thanks