Auto populate stocks for production factory

[makinmomb]

Column Q3 is where current month is entered manually

I want then then a formula to read stock that is Q4
and populate if that is stock is feasible for how many
months for a stock of 200 formulas should auto feed
50 50 40 30 20 into B7 AND B8 AND B9 AND B10 AND B11
according to
sells trend range D3 to O4

Thus the formula on B3 TO B26 for production
stock population

[JohnTopley]

Try

in B3 and copy down

=IF(MONTH($A3&0)>=MONTH($Q$3&0),IF(SUM($B$2:B2)+INDEX($D$4:$O$4,,MONTH($A3&0))<=$Q$4,INDEX($D$4:$O$4,,MONTH($A3&0)),""),"")

You would be better using actual Excel dates rather than TEXT.

[makinmomb]

Thank you John , wow

[avk]

Dear makinmomb, I have create long back my own "Re-Order-Level" Template.
You just refer it if you comfirtable then use. as per your data record maintain. (Becausei don't know in what type of data you have maintain) Here i develop as per our maintaining data record.
In Consumption sheet : Last 12 month consumption calculated.
In Stock sheet : I just upload daily stock postion from our system. (Just copy paste data)
In On_Transit sheet : Also upload despatch detials from our system. (Just copy paste data)
In Pending sheet : Also upload pending order detials from our system. (Just copy paste data)
In summary sheet : I finalize norm based on consumption. stock / transit / pending data extract from respective sheet using index match formula.
Please refer attach file.
In attach sheet entered few example.

[makinmomb]

Thank you AVK , I will look into your file too

John can you change the stock to 300 instead of 200 ,
it populates stock correctly , but throws around 10 to next year
leaving gaps ?

[makinmomb]

John that should be fine , if it throws something next year I only have to focus looking into continuous
months stock will serve