Arrival schedule + By Percentage

Question

question

Fernanda Becker asked Oct 8, '16 Joerg Vogel edited Oct 8, '16

Arrival schedule + By Percentage

Dear all,

I'm modeling a retail supply chain and I would like to set my source with an arrival schedule style, in order make my products (there are 200 types of products) arrive just once a week. But I also would like to create these items following a percentage (from a global table), because the idea is that the arrival of one product is a possibility, not a deterministic number.

But when setting the arrival schedule, I found just the option to fill the exactly quantity of each product. I don't want to set a quantity, but a percentage of representativity of each one (from an amount of X, that is the total quantity that I need the source to create at that time). Moreover, this percentage will be in a global table and I will create an User Event to get the values from the global table and put then into the right place.

OBS: The intention is to expose the model to the probability situation, once in reality when a retailer asks for a product, he will not always receive its right quantity.

How can I do this?

Thank you very much!

20161005-modelo.fsm

Software Version:

Choose One

source schedule arrival schedule by percentage

20161005-modelo.fsm (51.7 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2016-10-08T07:57:54Z

Joerg Vogel answered Oct 8, '16 Joerg Vogel edited Oct 8, '16

Before you update the quantities in the schedule table you can try to get the values by the dempirical distribution.In the needed table you set a probability for a quantity of items. The function computes the discrete value which you set in the schedule table right before the next repeat starts.

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joerg Vogel commented · Oct 08, 2016 at 08:03 AM

The node of the schedule can accessed by

getvarnode(current,"schedule")

current works, if you use a trigger in the source. Otherwise you need pointer to the source. Typically you use the Sampler to get such reference. The capacity value is in the 4th column of the table.

0 ·

Joerg Vogel commented · Oct 08, 2016 at 08:27 AM

A really ambitious approach would be to create a new table by SQL like @jordan.johnson has described it in a smaller example here and dump the table into the schedule node.

0 ·

question