Limit Only 1 SKU per Slot without using Paint Slot Labels

Question

question

Jayson K asked Apr 11, '21 Jayson K commented Apr 11, '21

Limit Only 1 SKU per Slot without using Paint Slot Labels

Hi, for the warehousing model_Gravity Flow Rack, I have 5 pallets per slot in gravity flow rack but I want to limit only 1 SKU per slot. Hence, the 5 pallets are same SKU. I can't use "Paint Slot Label" as I have 140++ SKUs and the number of pallets for each SKU is dynamically changing throughout the model. How can i do that with logics below:

a) Inbound pallet search the same SKU pallet in slot and the slot less than 5 pallets

b) If statement above false, it will look for slot with empty pallet/item.

Storage Utilization Simulation_3.fsm

Software Version:

FlexSim 21.0.2

flexsim 21.0.2 slot assignment slot query

storage-utilization-simulation-3.fsm (205.6 KiB)

5 |100000

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

Answer 1 · 2021-04-11T17:23:47Z

Jason Lightfoot answered Apr 11, '21 Jayson K commented Apr 11, '21

The find slot has an OnSuccess option to set the slot label - say 'SKU' to the sku being stored.

To match the sku you can then in the query use

WHERE slot.slotItems.length < 5  AND slot.SKU=$1.sku

or if the SKU label is indexed on the storage system GUI

WHERE slot.slotItems.length < 5 AND SKU=$1.sku

this assumes you pass in the pallet as $1 and it has a label on it called sku

Then you need to add another query for the case where you don't find a matching SKU which would be

WHERE slot.slotItems.length=0

Finally - you don't need to BookPalletinSlot, as the FindSlot activity does that for you.

1618161822432.png (5.9 KiB)

· 1

5 |100000

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

Jayson K commented · Apr 11, 2021 at 06:03 PM

It works perfectly. Thank you so much for the promptly reply :)

0 ·

question