How do I create a script to calculate expected inventory levels based on a reorder point and order quantity?
Hello,Attached is a jmp data set with consumption data for a part. I have a beginners understanding of column formulas, but not enough to achieve the end result I want with this data set. I'd like to be able to input a starting inventory level, a reorder point, a lead time and an order quantity into a formula or script which will output how many pieces will remain in inventory using those inputs...