Column that returns next date that satisfies material requirements.

In the above table, I need there to be a new column that shows the date that A10413-00-8 is going to come in (in this case July 19, 2022) to satisfy the requirements of the five highlighted work orders.  The table name is called Summary.  There are thousands of parts and I already have a running total column for each part (Balance) so I need the new date to show when the work orders will be clear to build.  This new column will be the Clear to Build date (CTB).  The CTB date for rows where the Balance figure is NOT negative would simply be the Date column.