Is it possible to link MRP data to Flexsim model ?

Question

question

Marco Casavecchia asked Mar 27 2019 at 8:26 AM tannerp commented Apr 16 2019 at 4:26 PM

Is it possible to link MRP data to Flexsim model ?

Hello,

My question is related to MRP data: inventory and demand forecast, in relation to the sources in the model.

How can I link the "on-hand inventory" in the sources I am using for my model?

Also, If my product is made of 10 items in it's BOM, do I have to have 10 sources to reflect that?

Thanks,

Marco

Software Version:

FlexSim 17.2.5

source schedule inventory demand mrp

· 7

tannerp commented · Mar 28 2019 at 7:54 PM

The best way to link your data would be through Global Tables. Do you have any experience with importing tables into FlexSim? Once you've imported a table with all your quantity and label data, you can have the Source reflect that in its production. There's many ways to access table data, however, so I'm afraid I can't give an example without knowing more about your data. Perhaps you could upload your files in a private question if you need further help.

Additionally, you can have 10 sources or use Process Flow to create those 10 items in your BOM. To achieve this using Process Flow, you'd just use Create Object activities after sources. Let me know if you have more questions about this.

1 ·

Marco Casavecchia commented · Apr 02 2019 at 7:31 AM

@Tanner Poulton,

Thanks a lot for your answer. I have no experience in uploading Global Tables. My goal is to know how much of each components of my BOM I have consumed during the simulation run.

To do that, I am thinking of:

1/ Import BOM items and QTY in 1 table

2/ Link each finished flow item to the same table and multiply?

Are there any other methods to do "inventory management" in FlexSim? My ERP can extract tables in csv format.

Thanks,

Marco

0 ·

David Seo Marco Casavecchia commented · Apr 02 2019 at 9:15 AM

@Marco Casavecchia

You should know how to control 'Global Table' of flexsim for the purpose of your doing with BoM and on-hand inventory.

Or if you do not use your BoM data, you can use the process flow template of 'Material Consumption and Replenishment'

0 ·

tannerp Marco Casavecchia commented · Apr 09 2019 at 8:18 PM

Please review the custom code that dynamically updates the Global Table (which could be used as a BOM). Whenever an item is processed, the inventory for that item's type is decremented by 1. Obviously, this model is incomplete, but hopefully you can apply the concepts from it to your own model and make it work.

Hopefully this helps! Global Tables can be very powerful tools and they're worth learning.

Model: inventory-bom.fsm

0 ·

inventory-bom.fsm (123.4 KiB)

global-table-update.png (27.2 KiB)

Marco Casavecchia commented · Apr 10 2019 at 12:25 PM

@Tanner Poulton

Thanks a lot for this inventory-bom code. It is very close to my need.

2 questions on the code itself:

- In the "OnReset" code: can the 500 value be taken from a table cell?

- In the "OnProcessFinish" code: how can I select from which "Type X" it will decrease of -1 as the simulation runs?

Thanks,

Marco

0 ·

Joshua S Marco Casavecchia commented · Apr 10 2019 at 7:56 PM

To pull a value from a table cell, use:

int value=Table("GlobalTable1")[row][column];

Or do you mean pulled from one table and inserted into another?

The "Type X" right now is the Type label on the item coming in, so just edit the line

int row = item.Type;

so that you can select which row will be decremented.

1 ·

Marco Casavecchia commented · Apr 11 2019 at 3:23 PM

I have uploaded an example of what I would like to change in this custom code.

bom-inv-decremental-logic.xlsx

Basically, I need to be able to have something different than just -1 decremental qty. And also, be able to have quantities uploaded of on-hand inventory, instead of 500 for every item.

0 ·

bom-inv-decremental-logic.xlsx (15.4 KiB)

______

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 · 2019-04-11T17:21:34Z

tannerp answered Apr 11 2019 at 5:21 PM tannerp commented Apr 16 2019 at 4:26 PM

Hi @Marco Casavecchia,

I believe that the following updated model should accomplish what you are thinking. There are a couple things I changed.

First, since you have an Excel file now, I was able to use the Excel file for direct import upon model reset (meaning that when you update the Excel sheet, it will update your Global Tables in FlexSim). There's tutorials on how to use FlexSim Import/Export, so hopefully it's straightforward enough that you can pick it up quickly. You will have to change the directory for you model. Do this by clicking the (...) next to Excel Workbook and identifying your Excel sheet.

Second, once you have imported your Global Tables, you'll need to change the code so that you're accessing the current INV value and then subtracting the BOM value from it. I think you called this "- X". The new script for the OnProcessFinish Trigger looks like the image below. Note that I used two row and column values in case you choose to alter those.

Hopefully this helps. Of course, you're probably going to need to designate more functions, such as what happens when the INV levels are insufficient and such. This will all require using a lot of custom code. Before taking on a large model, you might consider talking to your local distributor about consulting. There are many ways to utilize FlexSim and we would hope you can find the best one for your simulation.

Model: bom-inventory.fsm

excel-import-1.png (31.7 KiB)

process-finish-trigger-script.png (17.1 KiB)

bom-inventory.fsm (15.5 KiB)

· 2

Marco Casavecchia commented · Apr 16 2019 at 7:09 AM

Hello @Tanner Poulton,

Thanks a lot, this is very close to my need.

One clarification I might have not made. When the Processor1 is outputting 1 item, the change in INV should be : (with N being the last qty in the Inv column)

Item 1 = N-2

Item 2 = N-1

Item 3 = N-1

Item 4 = N-10

These 4 subtractions should,happen every time Processor1 output qty 1

Right now, the model is doing one item after the other only.

Thanks,

Marco

1 ·

tannerp Marco Casavecchia commented · Apr 16 2019 at 4:26 PM

Instead of using item.Type, just update the code to run a "for()" loop for each row in the table. That way, it will decrement each row for each item. Hopefully this helps. Please see updated model attached.

bom-inventory-update.fsm

0 ·

bom-inventory-update.fsm (14.0 KiB)

question