I serve several one-product companies that import their finished goods from China. In most cases, there are 4 to 5 months between the order date and the shipment’s receipt.
For modeling purposes, I want to start with the PO date, knowing that the receipt of those goods will be months later. But how do we do that math in Quantrix?
There are two keys to the solution:
- using recursion, and
- the CASE statement
In the video below, my examples are overly simple, but they should prompt a brainstorm or two on how you handle inventory-centric lead-time recursion in your models.
As always, let me know if you would like the underlying file.
