Replenishment Depending on Stock Level at the Beginning of Each Month

Question

question

DaniCor asked Dec 13, '23 Jason Lightfoot commented Dec 20, '23

Replenishment Depending on Stock Level at the Beginning of Each Month

H comunnity!

I am trying to analyze if it is necessarly to create a new purchase requisition at the beggining of each month considering the stock in transit plus the stock on hand. For example at the start of this month my stock target is 10000 flowitems(I have to try not to exceed this quantity with stock on hand in other words in my queue. the stock on hand plus stock in transit is possible to exceed) and my stcok o hand is 8000 flowitems then I need to create a purchase requisition of 5600 flow items wich is the minimum orfer quantity or more considering that have a lead time average of 122 days and 20 day of standard deviation. If my stock on hand plus my stock in transit is higher than my stock target I dont need to create a new purchase requisition. My first target is to make a periodic review of inventory policie like the image

Software Version:

FlexSim 23.2.2

replenishment material supply safety stock

· 1

Jason Lightfoot ♦ commented · Dec 20, 2023 at 03:37 PM

Hi @DaniCor, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 ·

Answer 1 · 2023-12-13T10:20:18Z

Jason Lightfoot answered Dec 13, '23

What's the question here? Is it how to create periodic events? You can schedule user events or delayed messages or (my preference) use a process flow.

· 6

DaniCor commented · Dec 13, 2023 at 12:20 PM

Yes, create periodic events at the beggining of each month. If my stock on hand plus stock in transit is less than the stock target create a purchase requistion. How'd be using process flow?

My source GENERACION PEDIDO must create a new purchase and deliver to ALMACEN

0 ·

simulacion-diseno.png (115.3 KiB)

Jason Lightfoot ♦ DaniCor commented · Dec 13, 2023 at 05:55 PM

You just have a token that loops around and uses the dateTime class to figure out the delay time to the start of the month.

0 ·

DaniCor Jason Lightfoot ♦ commented · Dec 13, 2023 at 06:03 PM

I should apply that adding a trigger to my queue then use the dateTime class?

0 ·

Show more comments

question