View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angela Angela is offline
external usenet poster
 
Posts: 85
Default 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,