inventory formula... help pls.

[Guest]

hi!

i'm doing inventory work for the first time. i would like to know the running balance of my inventory and the reorder point or weeks cover of stock. example colum a (incomming) - colum (b) which is outgoing = columm (c) on hand. we have a 2weeks of stock policy inventory cover on the whole items.

secondly, i am also monitoring the aging of the inventory. what is the formula for 0-30days , 31-60 days, 61-90 days, 120-150days, over 150days

thank you in advance for the assistance!

 

[BrianB]

'--------------------------------------------------
the running balance
A simple SUM() of the stock column ?
'---------------------------------------------------
reorder point
Requires a set amount for each product to compare with stock
IF stock less than or equal re-order number then need to order more.
'----------------------------------------------------
weeks cover of stock
Requires the average weekly usage of each item to compare with stock.
stock divided by weekly usage = number of weeks
'-----------------------------------------------------
aging of the inventory
date2 minus date1 gives the number of days between.
date plus 30 gives the date 30 days after.
'----------------------------------------------------

Hope this helps

 

[Guest]

thanks brian... will try it!