Compare completion time and target shipment time

Question

question

Quynh Tran asked Sep 20, '23 Jeanette F commented Sep 26, '23

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?

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

Thank you.

Software Version:

FlexSim 23.0.8

optimizer design completion time

1695182771601.png (180.4 KiB)

· 1

Jeanette F ♦♦ commented · Sep 26, 2023 at 04:43 PM

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 ·

Answer 1 · 2023-09-21T12:18:02Z

Jason Lightfoot answered Sep 21, '23 Jason Lightfoot edited Sep 21, '23

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.

question