Lead Time

TAGORTI
TAGORTI
in Modeling

Hello,

 

I am trying to calculate production date based on the delivery date and the leadtime.

But the problem that, I need to exclude weekends and it didn't work. I tried several methods but it didn't work on all the cases.

 

Any idea that helps ?

 

Thanks in advance.

 

Regards

Tagged:

Best Answer

  • nikolay_denisov
    nikolay_denisov
    Answer ✓

    Hello @TAGORTI 

    I have an idea, but it might be not fully aligned with best practices.

     

    So if you have to calculate lead time only for this current year - you could do it via module which will have a daily timescale with dimension of your material.

    So as an input you will have a date order; Lead time (working days).

    Please see my small POC:

    Screenshot 2020-10-09 at 19.09.07.png

     

    Screenshot 2020-10-09 at 19.09.26.png

    Regards, Nikolay

Answers

  • TAGORTI
    TAGORTI

    Thank you Nikolay.

     

    It is a good solution but I don't know if it is recommended as a best practice.

     

    Regards

Categories