question

Anutt K avatar image
0 Likes"
Anutt K asked Anutt K answered

How to picking order from Excel.


I has no idea now. Please help me or advise me to find solution.

Import order from excel

o 1 picking order is 1 full pallet containing in total 18 boxes

Each operator to pick 18 boxes from 4 random different destinations where he picks 3-6 boxes per destination

I attach file here.


1652674697491.png

1652674977540.png

1652675019024.png


Import Order.xlsx

Man to Goods.fsm

Thank You very much for help.



FlexSim 22.1.1
excel importorder pickingrandom pick
1652674697491.png (33.1 KiB)
1652674977540.png (318.7 KiB)
1652675019024.png (9.9 KiB)
import-order.xlsx (8.9 KiB)
man-to-goods.fsm (66.2 KiB)
5 |100000

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

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered

Here's a model which uses your data format.

It uses a table query to determine how many order tokens to create in the Source Orders activity:1652810948948.png

Then for each order it writes a table on the token with the SKU quantities:

1652809946270.png

For each row in the table the RunSubFlow creates a token with the label SKU and Qty.

man-to-goods_jl.fsm


1652809946270.png (2.4 KiB)
1652810948948.png (22.3 KiB)
man-to-goods-jl.fsm (70.1 KiB)
5 |100000

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

Anutt K avatar image
0 Likes"
Anutt K answered

Now I can apply form your answer to use and It work. Thank You everyone.

5 |100000

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

Regan Blackett avatar image
0 Likes"
Regan Blackett answered Regan Blackett edited

Picking operations tend to be very customized to a particular system, so it’s hard to give general answers about how to proceed. There are also some things not clear from your description that may change the approach your model may take. For example, do you need to finish picking order 1 before you can start order 2? Can you assemble all 3 orders at once? Can multiple pickers cooperate on a single order or is one picker responsible for an entire order alone? Where are boxes to be picked stored? A Rack/Floor Storage object vs a Queue object might also change how you do things.

Some general things to consider though would be:

  • Data formatting. Using the Excel import/export feature, you can easily bring your data directly into FlexSim. However, the current format may or may not be the easiest way to work with it. This again may depend on the details about how the orders need to be managed. As the modeler you have the freedom to format data in anyway that makes sense to get the right results and make your model easier to work with. For example, I might take your data table and turn it into something like this:

formatting.png

It’s the same as the original data but puts all the information for each order on one row and may make other things in a model easier, depending on your approach.

  • Lists. This kind of model tends to be very dependent on Lists; to signal availability of orders to pickers, track the progress of an order, or to signal an order is complete. You could take data from the table and assign it to process flow Tokens pushing them to a List, and allow pickers to pull from this List so they know what order, SKU and quantity they are responsible for.
  • Storage Objects. You may find these useful for storing items of particular SKUs so that they can be assigned specific slot locations in the objects. They also have process flow activities, Find Slot and Find Item that help find either an available storage slot or an item in the object that needs to be picked.
  • Task Sequences. With a custom picking logic like you are describing you will likely have to define the tasks needed to find the appropriate items for them to transport and take them to their pallets. This tends to be more easily done in process flow.

formatting.png (33.6 KiB)
5 |100000

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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