Dynamics Community Forum Thread Details

Calculate minimum Downtime for Production order line using Custom parameters in D365 F&O

Hey Experts,

I have requirement where user wants to plan his production orders so as to minimize the downtime of Production line thereby increasing the efficiency.

For example, in a day I have 3 orders (PO01, PO02, PO03) to be executed on one machine line (M/C01).

But due to different attributes of Product here in my case Colour and Size, the downtime required is different for every attribute enumeration.

Suppose, I have 3 different colours and 3 different size for a product. User will define the downtime to in custom master as shown in below screenshot, "Colour Code Change Time" and "Size Code Change Time".

Now here I must calculate all 9 permutation and combinations so that I can pick minimum time.

For reference, I have shown 2 combinations in below screenshot. And as 40 min is minimum time, I will load the order in sequence of PO03, PO02 and PO01.

Now I need to make this completely dynamic. There might be 3, 4, 5 or even upto 10 orders in a day.

Can anyone please suggest how should I calculate minimum possible time for that particular production line? I must try all Permutation and Combinations to reach to conclusion. Using Tables and "while loops", it just seems impossible because that will result in much extended runtime.

Is there any other library that I can use in combination with tables? Please suggest.

Thank you in advance.