question

Quynh Tran avatar image
0 Likes"
Quynh Tran asked Jeanette F commented

Compare completion time and target shipment time

Hi all,

In my model, I collected the Completion_time of each order and pushed it to the "Completion_time_of_orders" table by a custom code. The number of orders may change depends on the plan.

Now I want to find a plan that can minimize WIP while still meet the order's delivery time. Can you help me on how I can put the comparison of Completion_time of each order and its Shipment_time as the constraints of the Optimizer model?

1695182771601.png

Because the file is too large, please refer to the onedrive link here: Model.fsm

Thank you.

FlexSim 23.0.8
optimizer designcompletion time
1695182771601.png (180.4 KiB)
· 1
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.

Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Quynh Tran, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Jason Lightfoot edited

I would add a PFM for the number of late orders and add numLate=0 as the constraint.

You can write a simple table query for the PFM to find the number that are late.

We encourage students to research how to and then try and implement the recommendations and and come back with follow up questions if they get stuck.

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.