Len B,

The usage per week is 15,300 pounds (6 day work week) and the daily volume
is 2,550 pounds a day with a 9 day lead time on when the material was ordered
to the arrival day of material. Order minimum is 1,700 pounds.

Thank you
Angela

"Len B" wrote:

You need to know usage per week so if
A2 = 15300
B2 = 2.06
C2 = =IF(B21.75,0,A2-(B2*E2))
D2 = 3400
E2 = 1940 per week say


"Angela" wrote in message
...
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,