Rack storage (based on SKU)

Question

question

Sunada C asked Aug 13 2018 at 8:24 PM Sunada C commented Nov 02 2018 at 3:03 PM

Rack storage (based on SKU)

test-rack-placement.fsmHi,
I am interested in importing a list of SKU with different locations for storage & retreival in a rack. I saw a lot of posts that deal with the subject, but I am new to flexsim and was unable to duplicate some of the models that I downloaded from this forum. I have two questions. From my very rudimentary understanding, I first need to create a table that will list different skus along with the rack, bay and level for each of them as a global Table. The question, I have is how do I get the source to generate different itemtypes (It looks like this is something that I am unable to do). Please see a model that I created. This does not even run on my end.

Software Version:

FlexSim 18.2.0

rack storage

test-rack-placement.fsm (18.7 KiB)

· 2

Jeff Nordgren commented · Aug 13 2018 at 9:52 PM

@Sunada C

You mention that your global table would have a SKU and a rack with bay and level. Does that mean there is only one place that the SKU can be placed? Would you have unlimited capacity in the rack for multiple items of the same SKU? I would have an itemtype for each different SKU. Would that work on your end?

Thanks.

0 ·

Sunada C Jeff Nordgren commented · Nov 02 2018 at 3:03 PM

@Jeff Nordgren

So I have a master SKU list with their respective placement in different racks from our database. I would like to use this to place the SKUS in appropriate racks. So I saw that in your model, you created labels for flow items which also had level and bay and in the place in bay or place in level functionality of the rack you did item.bay or item.level. How do I extend this to include different rack placement by default?

0 ·

______

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 · 2018-08-13T22:27:15Z

Jeff Nordgren answered Aug 13 2018 at 10:27 PM

@Sunada C,

Attached is your model with the changes that I've made to it. Take a look at the model and see if something like this would work for your situation.

I added an Excel Import that will import an Excel worksheet into both the Source and the GlobalTable. I wasn't sure which one you would rather use, so I did both. To import from Excel, just press the Import Tables button on the bottom left of the import window. I also added the label "Type" and color the flowitems based on that label. I also added a fourth row to the table just so you could see that it works properly.

If you have any questions or problems, please don't hesitate to ask. The model and Excel file are attached.

Thanks.

test-rack-placement-jn1.fsm

rackstorage.xlsx

test-rack-placement-jn1.fsm (44.0 KiB)

rackstorage.xlsx (8.6 KiB)

question