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