Running production totals

Hello,

I am running a production schedule for different part numbers. Every two rows at the top, sums into a cover column. (example, D4:D5 is D15).
My problem is that I'm trying to develop the best way to get the running totals numbers needed for production to fill the schedule and to replenish up to the safety stock number for 2/19 to 5/7 in each row.
Of course, each week the quantity on hand changes so the numbers may fluctuate as well as the schedule.
The top row (15) should have the numbers 0 0 0 0 1 1 0 0 0 0 0 0
The second row (16) should have numbers 0 18 5 19 19 15 15 19 47 41 10 22
and so on. Any help would be appreciated. Thanks!

production.png

Thank you for your reply,

I've done as requested.

I've uploaded the workbook as attachment schedule.xlsx

The highlighted area in yellow is where I need results with some intructions.

I have manually entered the results expected in the top area. Thanks!

Very good. This is exactly what I needed.
I'll work on getting the offset done correctly.
I appreciate you help, thank you very much.

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!