To get my reorder points and2 diff. reorder quantities in the appropriate Quarter columns

I need to have this formula revamp where I add column A the first initial order Quantity be included. I want it included in the section when I used my First Initial Reorder point column C. All my reorder points are in Quarters and need to be displayed when I need to order and how much I need to order.
My first reorder point in column C and first Reorder quantity column A is different since I either need to deplete my stock or order immediately. Then after the first reorder point has come to pass then it needs to go into my 2nd Reorder point column D and use my second reorder quantity column B. This will then be used continuously for the remainder of the time frame.

Currently the formula I use is this.

=IF(OR(COLUMN(A:A)<$C2,MOD(COLUMN(A:A)-$C2,$D2)),0,$B2)

Here is the Excel book with how it should look like and working copy tab as well.

Book1 (1).xlsx

I don't quite understand what you mean. In the example, would you please indicate your input and manually the expected results of the formula with an explanation.

I included in the table under each row what the first column should be.

And I don't understand this either.
Do you now have incorrect results in your sheet? Please omit incorrect results completely.

Furthermore, English is not my native language, which is also a reason that it is more difficult to understand.
I'm sorry.

Sorry, I don't mean it that way.
Now it seems that I only see the input, but not the expected results.

I would like to see the input separately and the expected results (with an explanation) separately.

Or am I overlooking something?

Here is an image of your desired final result.
For readability I have hidden the columns with the totals.

Looking at ROW3 for example,
Why is the first reorder after 1 quarter, the second after 4 quarters and the third after 6 quarters?

In the last copy there are no year totals anymore. That is much easier, you don't need this totals anymore?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...lumns.1240628/)

Please try in E2 copy right and down:

Formula:

Please Login or Register  to view this content.