E8.12 Calculate remaining MFG Lead Time per Work Order

[cekay90]

Hi experts!
I work in a manufacturing company that I'm supporting especially from a Business Intelligence Point of View.
My objective now is to provide a holistic picture about all work orders in WIP with current status and remaining mfg lead time.
I'm already working with F4801 to extract current wip, combined with F3003 to calculate the number of total process steps.
I extraced the standard Lead Time Level from F4102.
What is missing now is the "backwards calculation" of the remaining lead time based on current state in F4801.
Is this possible?
I know it will not display the truth, but is a step forward.

I'm grateful for every help/ tip!

 

[vinngh]

Hello , By looking at the scenario you mentioned, I think the logic can be developed by checking the details from V3112A which shows the completed and remaining quantity at each opertion. It shows the Run labor hours , machine hours as per Work Order quantity. Example Routing as 333 hours as Labor hours with Time basis code as 3 , If the Work Order is for 3 EA then the Run labor hours will be showing as (333/1000)*3 = 1. Out of 3 EA, if particular Operation step has remaining quantity of 2 then you can calculated the value as (333/1000)*2 = .666 hours.
Hence for each Operation, the number of remaining hours can be calculated, accordingly SUM of each operation hours, Manufacturing Lead time will be calculated. If you have Setup Hours and Move hours, that calculation also needs to be considered with formula in given image. I believe this way you can achieve for the required result.
Good Luck!