Running production totals

Hi, to all!

You could try this formula:
[D36] : =MAX(,$B36+SUMPRODUCT(($B$25:$B$32=$A36)*$D$25:D$32)-SUM($C36:C36))
And drag it to the right and down.

Check file with proposed solution. Blessings!