question

Sunada C avatar image
0 Likes"
Sunada C asked Sunada C commented

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.

FlexSim 18.2.0
rack storage
test-rack-placement.fsm (18.7 KiB)
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Jeff Nordgren avatar image Jeff Nordgren commented ·
@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 Likes 0 ·
Sunada C avatar image Sunada C Jeff Nordgren commented ·
@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 Likes 0 ·

1 Answer

Jeff Nordgren avatar image
1 Like"
Jeff Nordgren answered

@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)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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