How to create global tables with custom code and statistical distributions?

Question

question

Martin B6 asked Feb 09 2021 at 10:52 AM Jeanette F commented Feb 16 2021 at 5:32 AM

How to create global tables with custom code and statistical distributions?

Hi,

in my model I have integrated a fixed inventory list and a fixed order list which is the same in every run. But since I need to use this model for future predictions and replications, I need to change my lists every time I run a simulation. This means that uncertainties and fluctuations have to be integrated into the model. Is it possible with FlexSim to create global tables like Inventory List and Order list with statistical probabilities at the start of the simulation, which change after each run. The idea would be as follows: I have approx. 500 different products (SKUs) which are stored in a statistical distribution to a total of approx. 2000 products and a statistical ArrivalTime in the rack. These products should be statistically allocated to a total of 925 orders. An order can have 1-7 products. Thus, with FlexSim, a new Inventory List with approx. 2000 entries should be created at each simulation start. Can this problem be solved with Process Flow (CustomCode) for example? How can this list with statistical distributions be generated? Maybe someone can support me with this. Enclosed I attach the model. I have already created a global list called InventoryStat.

Test-MilkRun.fsm

Thank you very much!

Software Version:

FlexSim 20.2.3

processflow global table flexsim 20.2.3 customcode

processflow.png (11.0 KiB)

test-milkrun.fsm (1.9 MiB)

· 1

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2021-02-11T18:32:13Z

Parker S answered Feb 11 2021 at 6:32 PM Jason Lightfoot commented Feb 12 2021 at 5:17 PM

@Martin B6

Here is code you can use to populate your Inventory global table:

Table Inventory = Table("Inventory");
Table SKUs = Table("SKUTable");
 
for (int rowNum = 1; rowNum <= 2027; rowNum++) {
    Inventory[rowNum]["SKU"] = SKUs [duniform(1,500,1)][1];
    Inventory[rowNum]["ArrivalTime"] = duniform(0,227,1);
}

Where the "SKUTable" contains a list of your 500 SKUs.

I'm still working on the OrderHistory, I think it will be a bit more tricky. I'm assuming you want to have a fixed list of 925 OrderID that need 1-7 products to be allocated to them, is that correct?

· 2

Martin B6 commented · Feb 12 2021 at 8:05 AM

Hi @Parker S

thank you very much for your answer. Yes exactly, at each start of the simulation a list (OrderHistory) should be generated, which consists of 925 different orders of 1-7 products each. The due date of the order should be stored with a statistical distribution. The idea is that at each simulation start always different Inventory and Order lists are created. Unfortunately I do not know if this is feasible. I tried to integrate the code from you into the model and there was a problem. I always get an error message that the path cannot be found. I do not know exactly what the problem is. Could you help me again and show me how I can integrate the code into the model?

Many thanks!

0 ·

Jason Lightfoot ♦♦ Martin B6 commented · Feb 12 2021 at 5:17 PM

@Martin B6 Normally inventory and order due date are correlated through 'material requirements planning' and 'availability to promise'.

If we generate random SKU arrivals into inventory and random order due dates independantly we might see storage levels and late orders that are not at all representative of the real system with an early order waiting for a very late SKU arrival.

It also seemed in your model so far, that you were preassigning the individual SKUs to an order, but in the completely randomly generated case would you still enforce that, or would you allow, when it arrives, the same SKU number to be reassigned to another order that needs it with an earlier due date ?

I think what you're asking, while possible, raises a lot of questions.

0 ·

question