Hi all.
I am making an inventory list and want to have a reorder date based on: current inventory, usage pr. day, safety stock and reorder time (days).
How do I go about to have the reorder date calculated?
Best regards.
Stefan Pall.
Hi all.
I am making an inventory list and want to have a reorder date based on: current inventory, usage pr. day, safety stock and reorder time (days).
How do I go about to have the reorder date calculated?
Best regards.
Stefan Pall.
=today()+roundup((CurrentInventory-safetyStock) divided by usage pr day)-reorder time
Best of luck.
Chris
Click * below if this answer helped
Thanks Chris.
Worked fine.
Just the thing I was looking for.
Best regards.
Stefan Pall.
Hi Stefan
If you are happy with this, please click the add reputation and mark the thread as closed.
Regards Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks