Rolling Allocation Problem
We have an allocation problem. We have Shortages(Demand) and Supply by month. We have to allocate the oldest supply to the demand ie FIFO. Also, there is an expiry period for the supply, beyond which it cannot be allocated. The same is illustrated in this example, you may note there is a 1-many, many-1 and many-many linkages. I have represented the allocations in another table on the right using source and destination months. The supply 100 on Mar cannot be allocated to Demand in Jul as it violates the expiry period, so it will remain unallocated.
This is just an example, supply and demand could happen on any month.
Any intresting ideas to solve this in anaplan model ?