John,

The sales velocity is for each of my products is different but the one
paritcular one I am having problems is manufacturing uses 2,550 pounds every
24 hours. The lead time on this particular product is 9 working days from
day of ordering to day of receipt.

I used total pounds in inventory+amount due/weekly usage to get my weeks of
inventory on hand. The formula actually looks like this =((R2+M2)/Q2).

Thank you in advance for any help you can provide.
Angela

"John Bundy" wrote:

My specialty :) You are missing 2 key components to make this truly useful,
you need to know your sales velocity and lead time. I see you have weeks on
hand so you must have velocity somewhere. What calc did you use to get weeks
in inventory?

-John

"Angela" wrote:

I have excel spreadsheet that shows how much inventory I have on hand in
weeks, how much minimum inventory to keep and the max inventory to have I
need to know if there is a formula that can tell me exactly what to order for
the future?

Listed below is what I have so far:
Max Inv. # of Weeks in Inventory Order Amount Minimum Inv.
15300 2.06 ? 3400

If the inventory falls below 1.75 weeks I need a formula to show how much to
order according to min and max quantity.

Thank you,