Rack storage (based on SKU)

Question

question

Sunada C asked Aug 13, '18 Sunada C commented Nov 2, '18

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 09: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 03: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 ·

Answer 1 · 2018-08-13T22:27:15Z

Jeff Nordgren answered Aug 13, '18

@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