Formula help with ordering quantity
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,
|