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